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: 1
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 24 times

Post Reply