CODEWITHSUNDEEP
microsoft-dynamicsdynamics-nav
Daniel St-Jean
Daniel St-Jean

Reputation: 117

Filters Syntax Explanation

I'm trying to reproduce the filters logic in csharp and was wondering what do the following filters mean?

As a start, I created a parsing tree having LogicalOperator Node, ComparisonOperator Node, Variable Node, Value Node.

The idea is that I could create a tree like this

             =
           /   \
COST_CENTRE      12456

I'm not sure how to interpret these theorical filters

8*..9*

8?..?12

>A*

>12?A*

Any ideas? Thank you,

Upvotes: 0

Views: 158

Answers (1)

Mak Sim
Mak Sim

Reputation: 2324

What is the problem Entering Criteria in Filters?

8*..9* result contains all records in which the field has values from (starting with digit 8) to (starting with digit 9), e.g. 8, 88, 838, 9, 91, 9034234 and so on.

8?..?12 result contains all records in which the field has values from (two-digit numbers starting with digit 8) to (three-digit numbers ending with digit 12), e.g. 80, 81, 89, 312, 412, 912 and so on.

>A* result contains all records in which the field has text values that is greater than A*, where A* is any string that starts with "A".

>12?A* result contains all records in which the field has text values that is greater than 12?A*, where 12?A* is any string that starts with "12" then it has any random symbol, then goes "A" and than any number of any symbols.

The most stupid filters I've ever seen!

Upvotes: 1

Related Questions