Hello,
I would like to know if there is any entity that holds the history of changes done do ClientContacts, specifically the "status" field.
Some entities support {Entity}EditHistory and {Entity}EditHistoryFieldChange tables to track field changes, but it looks like ClientContact is not one of them.
Is there any was to get the values of the "status" field and the date that those were applied?
Tracking ClientContact changes
Moderators: StaffingSupport, s.emmons, BullhornSupport
-
- User
- Posts: 12
- Joined: Fri Jan 25, 2019 11:10 am
-
- User
- Posts: 3
- Joined: Tue Jan 29, 2019 2:26 pm
Re: Tracking ClientContact changes
Hi Ivan,
ClientContact edit history is available in the {Entity}EditHistory and {Entity}EditHistoryFieldChange tables under the User entity. User comprises all "people" entities so you would want to use the UserEditHistory entity if pulling edit history for ClientContact, Candidate, CorporateUser, or Lead records.
ClientContact edit history is available in the {Entity}EditHistory and {Entity}EditHistoryFieldChange tables under the User entity. User comprises all "people" entities so you would want to use the UserEditHistory entity if pulling edit history for ClientContact, Candidate, CorporateUser, or Lead records.
-
- User
- Posts: 12
- Joined: Fri Jan 25, 2019 11:10 am
Re: Tracking ClientContact changes
Thanks for the info.
I have hit a small problem with pulling changes for ClientContacts specifically.
The following request gives me an error on my targetEntity filter:
The error:
I am sure that there is a field called "_subtype" in the targetEntity object.
Is the request semantically wrong, or is the approach completely wrong?
I have hit a small problem with pulling changes for ClientContacts specifically.
The following request gives me an error on my targetEntity filter:
Code: Select all
query/UserEditHistory?where=(dateAdded>=946677600000)AND(dateAdded<=1577829600000)AND(targetEntity._subtype=ClientContact)&fields=targetEntity,dateAdded,id&sort=id&count=500&start=0
Code: Select all
"errorMessage": "Where clause 'subtype' at position 73 is not a valid field name.",
"errorCode": 400
Is the request semantically wrong, or is the approach completely wrong?
-
- User
- Posts: 3
- Joined: Tue Jan 29, 2019 2:26 pm
Re: Tracking ClientContact changes
Hi Ivan,
You cannot search or filter off the subtype field. Instead I would recommend getting your desired list of Contacts first through a query against the ClientContact entity then putting those IDs into a UserEditHistory query.
/query/UserEditHistory?where=targetEntity.id IN ([comma separated list of IDs])&BhRestToken=4f868c1b-81ba-4b65-9326-404119d57bf9&fields=*
You cannot search or filter off the subtype field. Instead I would recommend getting your desired list of Contacts first through a query against the ClientContact entity then putting those IDs into a UserEditHistory query.
/query/UserEditHistory?where=targetEntity.id IN ([comma separated list of IDs])&BhRestToken=4f868c1b-81ba-4b65-9326-404119d57bf9&fields=*
Re: Tracking ClientContact changes
Hello Ivan,
This is Joseph from the Bullhorn Support team.
As stated previously, you cannot filter off of the _subtype field. Running some tests on this, however, it appears that you can filter off of the personSubtype field which should match the _subtype. Try the following:
This is Joseph from the Bullhorn Support team.
As stated previously, you cannot filter off of the _subtype field. Running some tests on this, however, it appears that you can filter off of the personSubtype field which should match the _subtype. Try the following:
Code: Select all
query/UserEditHistory?where=(dateAdded>=946677600000)AND(dateAdded<=1577829600000)AND(targetEntity.personSubtype='ClientContact')&fields=targetEntity,dateAdded,id&sort=id&count=500&start=0