Database field vs UI Label

Forum for users and developers of Bullhorn's API service.

Moderators: StaffingSupport, s.emmons, BullhornSupport

Post Reply
orangepeak
User
Posts: 2
Joined: Tue Apr 07, 2020 8:07 am

Database field vs UI Label

Post by orangepeak »

HI There
we need an overview of the mapping between all database fieldnames and their corresponding UI labels.
We can get it manually in the UI via Menu/Admin/Field Mappings but the is too labour entinsive.

From the your support we got the query (below and attached) we should use, see attached.

But when we take the documentation, the only call we think is usable is http://bullhorn.github.io/rest-api-docs ... #get-query

But here we can't releae the query.

Can you help us out?
Happy to explain a little further in a Zoom meeting with our developer.

Many thanks
Arjan

QUERY:

use BULLHORN11963;
SELECT Top 4000
entity AS Entity,
columnName AS Field,
display AS Label,
editType,
sortOrder,
isRequired AS isRequired,1
isHidden,
valueList,
defaultValue
FROM BULLHORN11963.BULLHORN1.BH_FieldMapList a WITH (nolock)
WHERE privateLabelID = 18491
AND editType NOT LIKE 'System'
AND entity IN ('Candidate','Client','Client Contact','Job Posting','Job Posting II', 'Job Posting III', 'Job Posting IV', 'Job Posting V','Lead','Opportunity','Placement')
ORDER BY entity,sortOrder ASC
Attachments
BH query database veld vs UI label 20200406.txt
(511 Bytes) Downloaded 28 times

orangepeak
User
Posts: 2
Joined: Tue Apr 07, 2020 8:07 am

Re: Database field vs UI Label

Post by orangepeak »

Hello, can someone from Bullhorn help us with this?

Please contact me on meester@orangepeakcompany.com

Many thanks
Arjan Meester

pmularski
Bullhorn Support Staff
Posts: 935
Joined: Wed Dec 31, 1969 8:00 pm

Re: Database field vs UI Label

Post by pmularski »

Good Morning Arjan,

My apologies for the delay in our response.

Have you had a member of the team reach out with the data pull you were looking to receive? If not, please let me know.

-Pat
Patrick Mularski
Senior Enterprise Support Analyst
B U L L H O R N
Staffing and Recruiting Software, On Target, On Demand
Bullhorn Support Contact Numbers
US: 617-478-9126
UK: 44 800 032 2848
Australia: 61 28 073 5089
International: 617-478-9131

Post Reply