In CPI I am passing the below query to fetch sequence number of particular employee on particular effective date from Job Info change history
$select=seqNumber,userId,startDate&$filter=startDate eq datetimeoffset'${property.effectivedate}'&$filter=userId eq '${property.userid}'
But I am getting sequence number of latest record in change history But not getting the particular effective dated sequence number.
Actual requirement: I want to insert a record in change history of Job Info on a particular effective date only, not as a latest one. So, I need sequence number, then I will add 1 to it (seqNumber+1) then insert record in change history.
Could you please provide the solution for it.