FSM List View / Report - In List operator

Does anyone know a way to do an in list type operator for filters on list views or list view reports in FSM/GHR? We have some reports we're trying to create that were using these functions in a different tool and haven't come up with a good way to do it yet (i.e. not creating a bunch of single 'or' statements).

Find more posts tagged with

Comments

andy

Can you provide and example of what you're trying to accomplish?

robert-canham

something like

Item in list ('201200','201202','305880')

Sandeep Chandak

You can add a filter like this:
(Item = "201200" or Item = "201202" or Item = "305880")

robert-canham

Yeah, I used the 3 list as an example, but I'm told by one of our report developers that it can be quite a few list items (>100) which would make all the or statements cumbersome.

andy

Thanks. It sounds like you're wanting to leverage list filter multi-value selector in a report LPL filter. Unfortunately I don't believe that's possible and the only alternative is a list of or conditions. However, if you look at the web request when a applying a list of semi-colon delimited values in a list field filter, you'll see that it is just parsed as a list of or conditions.

Alternatively, if you have a large list of items to add to an LPL filter, using a text editor with multiline cursor functionality will make building the filter much easier.

robert-canham

Thanks for pointing out the list filter, I completely missed that.

Copyright © 2025 Infor. All rights reserved.