8,165
Like
Share
ReportIn this article, I'm going to show you how to apply different types of ranges to AOT queries. We'll go through simple and complex ranges.
- Let's first create a simple query that has "CustTable" inner joined with "CustGroup"
- If we want the query to return values where the enum "Blocked" field value is Never, then it's either we type the value Never directly or type CustVendorBlocked::Never
** It's not recommended to filter on the enum integer value
- If we want the query to return values where AccountNum value is "US-001", we can add the string value US-001 directly
- Now what if you want to filter on AccountNum "US-001" OR "US-002", you can do it in two ways:
*This post is locked for comments