Introducing Filters
I was working a project recently that required me to filter records by a date range. This represented a rare case where my use of DataMgr seemed to make my life more difficult rather than easier.
I was working a project recently that required me to filter records by a date range. This represented a rare case where my use of DataMgr seemed to make my life more difficult rather than easier.
how can i specify logic operators, i.e. AND OR etc, for more than 1 condition in a filter?
regards
salvatore
Good question. I should have specified that the filters (like the data arguments) are all "AND" clauses. The problem with allowing "OR" as well is that it would then require an indication of precedence - something parenthesis handle quite well in SQL.
I would recommend using the "advsql" argument for that.
All of that having been said, I would certainly be open to suggestions for a syntax that handle that.
you can surely add in the array element of the filter another param corrisponding to the logic operator; another: can you give me a little esplanation aboutadvsql use or
suggest an article about this?
regards
salvatore
Adding an "AND/OR" choice to the filter would be easy. Once you have the ability to mix operators, however, assigning precedence order becomes essential (for which parenthesis are used in SQL). I can't think of a syntax for that in filters that would be as easy.
Here is an entry on advsql:
http://www.bryantwebconsulting.com/blog/index.cfm/...
If you have any more thoughts or questions, let me know.
i've read again this post and i'd ask if is it possible to add the IN operator in filters.
we often have a form with a lot of checkbox to select items, so the IN operator can be very usefull.
regards
It looks like I left them out of the list here (maybe I hadn't added them in the Alpha), but IN operators are supported as of DataMgr 2.2.
http://www.bryantwebconsulting.com/docs/datamgr/fi...
Sorry for any confusion.