Skip to Content
0
Feb 01, 2023 at 12:57 PM

Fetching Sequence number of particular effective date record from Job Info change history

103 Views

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.