Successfactors OData API future Hire query

[VijayK]

Hello,

Working on an interfacce where we need to pick delta changes along with future hire.

Root Resource Path: WorkOrder

$select=userSysId,startDate,vendor,userSysIdNav/firstName,userSysIdNav/lastName,userSysIdNav/userId,userSysIdNav/empInfo/userId,userSysIdNav/empInfo/personIdExternal,userSysIdNav/empInfo/startDate,userSysIdNav/empInfo/jobInfoNav/company,userSysIdNav/empInfo/jobInfoNav/location,userSysIdNav/empInfo/jobInfoNav/countryOfCompany,userSysIdNav/empInfo/jobInfoNav/costCenter,userSysIdNav/empInfo/jobInfoNav/shiftCode,userSysIdNav/empInfo/jobInfoNav/shiftCodeNav/externalCode,userSysIdNav/empInfo/jobInfoNav/managerId,userSysIdNav/empInfo/jobInfoNav/customString1,userSysIdNav/empInfo/personNav/personalInfoNav/firstName,userSysIdNav/empInfo/personNav/personalInfoNav/lastName,userSysIdNav/empInfo/jobInfoNav/eventReason,userSysIdNav/empInfo/jobInfoNav/customString20,userSysIdNav/empInfo/jobInfoNav/startDate,userSysIdNav/empInfo/isContingentWorker,userSysIdNav/empInfo/jobInfoNav/managerEmploymentNav/jobInfoNav/customString20,lastModifiedDateTime,userSysIdNav/lastModifiedDateTime,userSysIdNav/empInfo/lastModifiedDateTime,userSysIdNav/empInfo/jobInfoNav/lastModifiedDateTime,userSysIdNav/empInfo/personNav/lastModifiedDateTime,userSysIdNav/empInfo/personNav/personalInfoNav/lastModifiedDateTime,userSysIdNav/empInfo/hiringNotCompleted,userSysIdNav/empInfo/jobInfoNav/emplStatus,userSysIdNav/empInfo/jobInfoNav/emplStatusNav/id,userSysIdNav/empInfo/jobInfoNav/emplStatusNav/externalCode,userSysIdNav/status&$expand=userSysIdNav,userSysIdNav/empInfo,userSysIdNav/empInfo/jobInfoNav,userSysIdNav/empInfo/jobInfoNav/shiftCodeNav,userSysIdNav/empInfo/personNav/personalInfoNav,userSysIdNav/empInfo/personNav,userSysIdNav/empInfo/jobInfoNav/managerEmploymentNav/jobInfoNav,userSysIdNav/empInfo/jobInfoNav/managerEmploymentNav,userSysIdNav/empInfo/jobInfoNav,userSysIdNav/empInfo,userSysIdNav,userSysIdNav/empInfo/jobInfoNav/emplStatusNav&$filter=(lastModifiedDateTime gt datetimeoffset'2023-04-30T00:00:00Z' or userSysIdNav/lastModifiedDateTime gt datetimeoffset'2023-04-30T00:00:00Z' or userSysIdNav/empInfo/lastModifiedDateTime gt datetimeoffset'2023-04-30T00:00:00Z' or userSysIdNav/empInfo/jobInfoNav/lastModifiedDateTime gt datetimeoffset'2023-04-30T00:00:00Z' or userSysIdNav/empInfo/personNav/lastModifiedDateTime gt datetimeoffset'2023-04-30T00:00:00Z' or userSysIdNav/empInfo/personNav/personalInfoNav/lastModifiedDateTime gt datetimeoffset'2023-04-30T00:00:00Z')&fromDate=2023-04-30&toDate=9999-12-31

above fiter query is not working as expecte, it's not returing future Hire.

if i use filter query as "userSysIdNav/status eq 'inactive'&fromDate=2023-04-30&toDate=9999-12-31" it's returning the future hire without EmpJob segment (where as EmpEmployment segment present)

Also, i tried diffrent filter query combination like

1. "(userSysIdNav/status eq 'inactive' or active)&fromDate=2023-04-30&toDate=9999-12-31"

2. userSysIdNav/status eq 'inactive' and userSysIdNav/empInfo/jobInfoNav/startDate gt datetime'2023-04-30T00:00:00.000'&fromDate=2023-04-30&toDate=9999-12-31

Still the future dated hire is not able query,

Regards

Krishna