I have created a query to retrieve information from SuccessFactors Recruiting, and I am using picklist fields on my where clause, but sometimes the fields return values, and sometimes they don't.
SAP SuccessFactors Recruiting Management
This happens because the Picklist fields that have not been touched yet have their information set as "NULL" but once changed they will never return back to null.
Picklist fields on the screen are as "No Selection" if they have never been touched they are NULL on the database column. Now, if by any chance you change the value to something else, save it and then change it back to "No Selection", this field is not going to change back to NULL, they will now be Empty, or "". That is due the platform architecture and how the system updates its values.
To resolve this problem when using picklists on your parameters or where clause, you can will need to test the both options, example:
picklist_1 <> "" and picklist_1 is not null
picklist, null, value, missing, sfapi, odata, no, selection, empty, incorrect, data, where, parameter, clause , KBA , LOD-SF-RCM-API , Webservices & APIs , Problem