Hi All,
I am going to use the Add SubSet Filter in my OData REST API method, but I always got error when I tried standard SQL WHERE clauses with OR/AND etc. Can anyone share more information regarding the details of SubSet Filter?
Here is the introduction from Infor online help:
Subset Filter - A subset filter functions similarly to a WHERE clause in SQL, enabling users to filter data based on specified criteria and retrieve only the matching records during a read action. This helps prevent the exposure of irrelevant data. For example, when reading the current parameters from the Generic Parameters (tcgen000) table, the revision records of previous changes are not relevant. In this scenario, the subset filter (tcgen000.indt = 0) is applied to exclude such records.
