Set a Filter with OR operator

Business Central/NAV Developers Forum
1

Hi, How can I set a Filter on a Table in 2 different fields with OR operator ? i.e. (Owner=User1) OR (Developer=User2) where Owner,Developer are fields in a Table. Thanks in advance

2

Hi Philip, Short answer: You can’t. Long answer: You need to write some code which examines all records and MARKs those you want to show. Then use MARKEDONLY. There is no simple filter expression for this.

3

This question has been answered countless times before. A recent answer can be found (using the SEARCH facility [;)]) here: http://www.navision.net/forum/topic.asp?TOPIC_ID=9142

4

thats incredible, no OR functionality

quote:

Originally posted by xorph
Hi Philip, Short answer: You can’t. Long answer: You need to write some code which examines all records and MARKs those you want to show. Then use MARKEDONLY. There is no simple filter expression for this.

5

quote:

Originally posted by dlombardozzi
thats incredible, no OR functionality

Perhaps it is - compared to e.g. Oracle and MS SQL. But Navision’s filter does have other advantages - one I use a lot is to change the filter on the fly while beiing “inside” the search/select-statement. If you in Oracle starts a select-where-statement you are stuck in that where-statement. On the other hand - if you have a tool, learn to use the tool; with one tool you will do it one way, with another tool you will do it another way. If you are good, you’ll solve any problem, regardless of the tool. [;)]