When running a query over a RCM entity and filtering the data using a custom field an error is exhibit saying that is not possible to filter using the field. The data dictionary also shows the properties filterable = false and sortable = false.
Error message: Bad property expression: <field>; <field> is not filterable / Bad property expression: <field>; <field> is not sortable
Here how it is displayed in Odata data dictionary:
Here is how the field is configured in Job Application template:
SuccessFactors BizX - Recruiting Management (RCM)
Reproducing the Issue
Go to Admin Center > Search for OData API Data Dictionary > Search for the RCM entity.
In order to change the attributes filterable and sortable you have to make a configuration in the back end. It is necessary to add the custom fields in "Configure Reportable Custom Fields".
Go to Provisioning > Configure Reportable Custom Fields.
Add the field in the correct section as configured in the data model. In this case, I have the field jobStarDate configured as a Date field in Job Application data model:
Save your changes:
Ensure that you do not get any error messages:
Run the Synchronizition:
When you receive the email stating the synchronization is ready, go to your instance and refresh the metadata:
In case you do not know how to refresh the Metadata take a look at the article 2171588.
The refresh can take a few minutes to reflect the new configuration. After you finish all the steps, access the Odata Dictionary again and you will see the new values for the attributes filterable and sortable:
sortable; filterable; COE003 , KBA , LOD-SF-RCM-INT , Integrations & Intelligent Services , LOD-SF-RCM , Recruiting Management , LOD-SF-RCM-API , Webservices & APIs , How To