How does one filter for multiple criteria within the same column of a list view?

During our meeting on Monday, I learned of using the semicolon (;) to filter for multiple conditions in the same column of a list view, which is great! To me, this functions like an OR condition.

Is there an equivalent to an AND condition?

For example, if I am filtering on a Description column with the CONTAINS operator [A]:

This will return any items that contain "cath", "coude", or "18", which could be quite a long list. I would like to filter for items which only contain all three variables somewhere in the description.

Thank you for any guidance anyone can offer!

Find more posts tagged with

Accepted answers

All comments

Dr. Awesome

You are right that any multi-value searching will do an "OR". We thought that more useful overall as a default over "ANDing". At the moment there is no secret-sauce to get "AND" but it's something we could look into adding somehow.

Were you just playing around here or do you think you have a bunch legit use-cases and would use this alot? Just curious.

ryan-schumacher

Secret-sauce would be superb! I can understand why OR was chosen as the default over AND, though I can confirm that having the ability to AND would be extremely helpful for our team -- and I imagine for others, as well.

In the example above, a Supply Chain staff member may receive a call from nursing staff asking for a specific catheter to be delivered to a floor. We have a lot of catheters and the nurse doesn't know the item number or the manufacturer number. So, being able to use multiple keywords within the description field allows us to quickly find the specific item being requested and the location in our inventory in which it is kept. (This is just one case, but there are many like this.)

In V10, that type of search might look like this if a nurse was looking for an 18FR coude tip catheter:

It's not really an issue with single-value fields. For example, with the Item field, one could change the "Contains [A]" to "Equals [=]" and then search for three values "111;222;333" to return all three of those records within the list view, thereby "mimicking" the AND condition. Of course this doesn't work for something like the Description -- unless perhaps wildcards were useable. It's not the best option, but it could be possible, for example, to do the same search as above in FSM list view with Equals [=] " *cath*;*coude*;*18* ", but wildcard use with Equals does not seem to produce the result.

In another system we use, multi-value searches are surrounded by parentheses and looks like this:

(*cath*&*coude*&*18*)

(*cath*|*coude*|*18*)

Ampersand (&) being for AND and pipe (|) being for OR. Neither of these is particularly user friendly, but they work.

I love how informative and flexible filtering list views can be in FSM. Having the ability to create this AND type of operator would elevate them even more, and if you would prefer I submit an enhancement request regarding such I would gladly do so. Regardless, I thank you for the reply and consideration.

Dr. Awesome

Awesome intel. Thanks for getting back @ryan-schumacher . I'll add a story to our backlog to see what we can do here. I'm betting ; or | can be ORs and & could be ANDs.

One complication, in full transparency was when ; or | or , or & (etc, etc) are actually part of the search term itself (it's why we don't use commas to delimit the search values. Too common in data). In these cases I believe we coded to require wrapping vals in "" so I think we are covered.

0911060553270289.pdf

Dr. Awesome

For my own notes - JR-3336067

Copyright © 2025 Infor. All rights reserved.