SAP Knowledge Base Article - Public

2793737 - When querying in the entity JobReqScreeningQuestion with $select operation I have no results - Recruiting Management

Symptom

When querying in the entity JobReqScreeningQuestion using the operator $select I have no results in the response back from SuccessFactors.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP SuccessFactors Recruiting Management

Reproducing the Issue

  1.  Perform a query on the entity JobReqScreeningQuestion, for example:
    odata/v2/JobReqScreeningQuestion?$filter=jobReqId eq 55 &$format=json
  2. See that the system will return you all values present on that entity:
    full_result.jpg
  3. Now perform the same query, but add the $select operator, for example:
    odata/v2/JobReqScreeningQuestion?$select=jobReqId&$filter=jobReqId eq 55 &$format=json
  4. Notice that now you don't have any results back from your query:
    no_result.jpg

Cause

This because of the way the system was desgined and happens because the JobReqScreeningQuestion has an internal dependency on the value jobReqContent.

Resolution

To perform a query on this entity and use the $select operator, the solution is simple as adding the field jobReqContent to your $select field list.

For example, if we run the same query as before, but add the jobReqContent into the $select operation, we get the values back on the response.

Query: odata/v2/JobReqScreeningQuestion?$select=jobReqId,jobReqContent&$filter=jobReqId eq 55 &$format=json

Result: 
select_result.jpg

OBS: Notice that the system brought back only the field present on the $select operation, as it should

Keywords

jobReqScreeningQuestion, jobReqContent, job, req, content, screening, question, $select, operator, api , KBA , LOD-SF-RCM-API , Webservices & APIs , Problem

Product

SAP SuccessFactors Recruiting all versions