OData Filter Builder
ODataBuild OData filter expressions visually. Generate $filter query strings with operators eq, ne, gt, ge, lt, le, and logical operators and/or for SAP OData services.
Filter Conditions
Advertisement
About OData Filter Builder
SAP OData services power almost every Fiori app and S/4HANA Cloud API, but hand-writing $filter query strings is error-prone — especially juggling OData v2's datetime'...' literals against OData v4's ISO 8601 dates. This builder assembles valid $filter expressions field by field so you avoid quoting mistakes and operator typos that would otherwise only surface at runtime in Gateway or the Fiori Elements list report.
How to use this tool
- Add a filter row and choose the field name as it appears in your CDS view or OData entity.
- Pick the field type (string, integer, date, etc.) so the tool quotes and formats the value correctly for OData v2 or v4.
- Choose an operator (eq, ne, gt, ge, lt, le, contains, startswith, endswith) and enter the comparison value.
- Chain additional conditions with and/or — the tool keeps operator precedence readable.
- Copy the generated $filter string directly into your service URL, SEGW test tool, or Postman request.
All processing happens locally in your browser. No data is sent to any server. Your SAP code and business data remain private at all times.
Frequently Asked Questions
What is an OData filter expression?
An OData filter expression is a query parameter ($filter) used in OData services to restrict the data returned by a request. SAP uses OData extensively in Fiori apps and S/4HANA APIs.
What OData versions does this tool support?
The OData Filter Builder supports both OData v2 (used by classic SAP Gateway) and OData v4 (used by SAP S/4HANA Cloud APIs). The syntax differences are handled automatically.
Can I use this for SAP Fiori app development?
Yes! This tool is specifically designed for SAP Fiori development. You can build complex filter expressions for SmartFilterBar, and test them against your OData service endpoints.
How do I combine multiple filters with AND/OR?
Add multiple filter rows using the "+ Add Filter" button. Each row has a logical operator selector (AND/OR) that connects it to the previous filter. The tool generates the correctly parenthesized expression automatically.
Advertisement