Symptom
Getting an error when try to add a filter with field “lastModifiedForAppStatus” from JobApplication entity in query
Environment
Successfactors RCM SFAPI
Reproducing the Issue
SFAPI response throwing an error when try to add a filter with field “lastModifiedForAppStatus” in the query. Field is present in the SFAPI “JobApplication” entity.
Querry having issue:
select candidateId, statusId, jobReqId, jobReqTemplateId from JobApplication where lastModifiedForAppStatus > to_date('2015-06-13T00:00:01Z')
Request: Add a filter with field "lastModifiedForAppStatus"
Response:Getting an error "SFAPI Domain Error" in the response
Resolution
The issue is because of the incorrect format of the date field in the filter used in the query.
Correct format for lastModifiedForAppStatus field when used in filter in query is below:
SELECT candidateId,jobReqId,jobReqTemplateId,statusId FROM jobapplication WHERE lastModifiedForAppStatus > to_date('2015-06-13','yyyy-mm-dd')
The difference in the error query and the correct one is the format of the date which is highlighted in bold above. When you run this query, it will result the data.
Keywords
lastModifiedForAppStatus, JobApplication Entity , KBA , LOD-SF-RCM-API , Webservices & APIs , Problem