Symptom
You are unable to add a filter for LastChangeDateTime in OData. An error occurs.
Error: "Error in filter System Query, Operation failed::Issue occurred during query execution in TREX (6930): attribute value is not a number;exception 70006930: attribute value is not a number".
Environment
SAP Business ByDesign
Reproducing the Issue
In SAP Business ByDesign:
-
Go to Application User & Management work center
- Click on Custom OData Service view
- Click on New
- Create a custom OData service
In Postman:
- Create GET request with Expand
- Execute GET request
Cause
The date format is incorrect.
Resolution
The date should be passed in the following format yyyymmddhhmmss.
Keywords
Fehler in filter-Systemabfrage, Vorgang fehlgeschlagen, Problem beim Ausführen der Abfrage in TREX (6930 ), Projekte im System abrufen, Filter nach Datum, attribute value is not a number, exception 70006930, , KBA , AP-RC-ODF-BYD , OData Framework and Console (ByD) , Problem