Logical operators and their parameters evaluate true or false statements and filter data within the resource.
The table below lists available logical operators in the Anaplan Financial Consolidation API:
| Operator | Description |
| Equals (eq) | The eq operator returns true if the left operand is equal to the right operand. Otherwise, it returns false. |
| Not equals (ne) | The ne operator returns true if the left operand is not equal to the right operand. Otherwise, it returns false. |
| Great tehan (gt) | The gt operator returns true if the left operand is greater than the right operand. Otherwise, it returns false. |
| Great than or equal (ge) | The ge operator returns true if the left operand is greater than or equal to the right operand. Otherwise, it returns false. |
| Less than (lt) | The lt operator returns true if the left operand is less than the right operand. Otherwise, it returns false. |
| Less than or equal (le) | The le operator returns true if the left operand is less than or equal to the right operand. Otherwise, it returns false. |
| And | The and operator returns true if both the left and right operands evaluate to true. Otherwise, it returns false. |
| Or | The or operator returns false if both the left and right operands both evaluate to false. Otherwise, it returns true. |
| Not | The not operator returns true if the operand returns false. Otherwise, it returns false. |
| Has | The has operator returns true if the right operand is an enumeration value whose flag(s) are set on the left operand. |
| In | The in operator returns true if the left operand is a member of the right operand. The right operand MUST be either a comma-separated list of primitive values enclosed in parentheses or a single expression that resolves to a collection. |
Ends with (endswith) | The endswith function with string parameter values returns true if the first string ends with the second string. Otherwise, it returns false. String comparison is case-sensitive. Case-insensitive comparison can be achieved in combination with tolower or toupper. |
Starts with (startswith) | The startswith function with string parameter values returns true if the first string starts with the second string. Otherwise, it returns false. String comparison is case-sensitive. Case-insensitive comparison can be achieved in combination with tolower or toupper. |
For example, GET https://fluenceapi-prod.fluence.app/api/CustomerTenant/{API_Token}/v23085.1/odata/Consolidation?$filter=Date eq '2024 Dec'
This example retrieves all the records within the Consolidation client schema table for only where the Date field equals '2024 Dec'.
Operator Parameters
When utilizing the $filter and $orderby query parameters, use the operator precedence for supported operators. Equal precedence is given to operators in the same category.
| Group | Operator | Description |
| Grouping | ( ) | Precedence grouping |
| Unary | - | Negation |
| not | Logical Negation | |
| cast( ) | Type Casting | |
| Relational | gt | Greater Than |
| ge | Greater than or Equal | |
| lt | Less Than | |
| le | Less than or Equal | |
| isof | Type Testing | |
| Equality | eq | Equal |
| ne | Not Equal | |
| Conditional AND | and | Logical And |
| Conditional OR | or | Logical Or |
For example, GET https://fluenceapi-prod.fluence.app/api/CustomerTenant/{API_Token}/v2305.1/odata/Consolidation/$filter=(Entity_Name eq '120') and (Date_Name eq '2024 Dec') and (Scenario_Name eq 'Actual')
This example retrieves data within the Consolidation client schema table if the fields for Entity_Name equals '120', Date_Name equals '2024 Dec', and if Scenario_Name equals 'Actual'.
