BH Notes, where Action = email

Post questions on how to interpret your Bullhorn SQL Server backup of your Database.

Moderators: StaffingSupport, s.emmons

Posts: 8
Joined: Fri Mar 21, 2014 1:50 pm

BH Notes, where Action = email

Postby bhdataq » Mon Apr 14, 2014 3:55 pm

Regarding emails that become Notes (action = email) associated with either a candidate or client...

In BullHorn we're seeing that the notes with an Action = email are truncated. Part of the note will display, but there is a hyperlink reading "more" at the end. When you click "more" you are directed to the actual email correspondence.

In the database Backup, the word "more" is displayed at the end of the note.

What is the logic for determining how much of a note (with action = email) is displayed before the "more" hyperlink appears? Also, how do we get the entire text of the note (action = email) within the database backup, rather than having "more" appear at the end?


Site Admin
Posts: 2053
Joined: Wed Dec 31, 1969 8:00 pm

Re: BH Notes, where Action = email

Postby apsmith » Wed Aug 27, 2014 2:11 pm

There was an issue with notifications on this forum, we truly apologize for the delay in responding.

To get the entire text of the note, you will need to open up the message body of the email. This is stored as a compressed binary in the BH_UserMessage table.
Andrew Smith
Director, Technical Operations
Developer Forum Admin

Return to “BH Backup Information”

Who is online

Users browsing this forum: No registered users and 1 guest