jobFieldChanges()
Return a sequence of changes for the current job, for the given field
Syntax
Single field: jobFieldChanges(fieldCode, fromDate, untilDate)
Multiple fields: jobFieldChanges(['fieldCode1', 'fieldCode2'], fromDate, untilDate)
Parameters
Return Type
Sequence <Job Changes>
Examples
jobFieldChanges(baseComp, '-5y').count()
Returns how many times the baseComp field has changed in the last 5 years for a specific job.
Would return 3 if the person had 3 changes to their baseComp field in the time period.
jobFieldChanges(baseComp, '2024-01-01', '2025-01-01')
Returns a sequence of changes to the base comp field between 1/1/2024 and 1/1/2025 for a specific job.
jobFieldChanges([department,team,location], '2020-01-01', '2025-01-01')
Returns a sequence of all changes to the department, team, or location fields for a specific job.
jobFieldChanges('title').map{it.update.title}
Example return: ["Software Engineer", "Senior Software Engineer"]
Returns an array of all of the titles across the changes.
jobFieldChanges('title').map{date}
Example Return: [2020-01-01, 2020-01-02]
Returns an array of all of the dates of that the changes occured on.
CQLT Example Template
This would retun a table row with the date of the change and the field that was updated with the title.
{% for change in jobFieldChanges('title') %}
<tr>
<td>{{change.date}}</td>
<td>{{change.title}}</td>
</tr>
{% endfor %}