Pulling date limited data from JobOrderEditHistoryFieldChange table

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

Moderators: StaffingSupport, s.emmons, BullhornSupport

Post Reply
ivandevpartner
User
Posts: 7
Joined: Fri Jan 25, 2019 11:10 am

Pulling date limited data from JobOrderEditHistoryFieldChange table

Post by ivandevpartner » Fri Jan 25, 2019 11:37 am

Hello,
Can anyone help me with the concept of pulling data from JobOrderEditHistoryFieldChange table that has been changed or added within a specific time frame?

Ideally I'd like it to be something like this:

Code: Select all

/query/JobOrderEditHistoryFieldChange?where=(dateAdded>=946677600000)AND(dateAdded<=1577829600000)&fields=oldValue,newValue,columnName,display,id,editHistory(id)&sort=id&count=500&start=0
I am aware that the table has no date field so that is why I need some other way to handle additions or changes in that field.
Last edited by ivandevpartner on Wed Jan 30, 2019 3:02 am, edited 1 time in total.

KevinSupport
User
Posts: 3
Joined: Tue Jan 29, 2019 2:26 pm

Re: Pulling date limited data from JobOrderEditHistoryFieldChange table

Post by KevinSupport » Tue Jan 29, 2019 2:52 pm

Hi Ivan,

You need to get the dateAdded from the Edit History which you can do with a small alteration to your call:

Code: Select all

/query/JobOrderEditHistoryFieldChange?where=(editHistory.dateAdded>=946677600000)AND(editHistory.dateAdded<=1577829600000)&fields=oldValue,newValue,columnName,display,id,editHistory(id)&sort=id&count=500&start=0&BhRestToken=eb913efc-bc2c-4e71-93e3-9d7b01e3d624
To be specific, you need to change dateAdded to editHistory.dateAdded so that it pulls the associated dateAdded from the {Entity}EditHistory table.

ivandevpartner
User
Posts: 7
Joined: Fri Jan 25, 2019 11:10 am

Re: Pulling date limited data from JobOrderEditHistoryFieldChange table

Post by ivandevpartner » Wed Jan 30, 2019 9:51 am

Looks like that worked.
Thanks.

Post Reply