Page 1 of 1

Which table is best used to map documents?

Posted: Fri Feb 26, 2021 6:11 am
by MercuryAl
Hi

Database question here.
We normally use bullhorn1.BH_UserWorkFile to link document to database records, which has worked well in the past.
However we've starting finding that documents are missing from that table and were in bullhorn1.BH_UserMessageFile instead.

Does anyone know what the difference between these two tables is and which is best used to link documents to db records?

Thanks

Re: Which table is best used to map documents?

Posted: Fri Feb 26, 2021 1:07 pm
by ytorres
Hello,

UserMessageFile is used for emails, UserWorkFiles is part of View_CandidateFile and is used for files in the UI normally.

Thank you!