Table filters
Less than to read
You can define table filters for a node in the Node bindings function (GESANODEB).
The Node binding dictionary defines how nodes are bound to Sage X3 Tables, Windows, Subprogs, Import templates, etc.
When a data model referring to a node is created, a Node binding record is automatically created (GESANODEB).
Data is generated or overwritten in the Binding dictionary (GESAPINOD) whenever Sage X3 metadata is defined.
The Table filter field is used to add a filter to a node.
In the following example, the SORDER table is filtered to exclude open orders from the regular orders node:
The Table filter field contains a GraphQL filter expression that uses operators such as _gt, _in or _nin. In the above example, records that have the category property set to openOrder are excluded.