Add Filter to Items Form

I want to filter the items form so that it does not display Obsolete items. I noticed that the Permanent Filter Expression filter is set to V(FliterByQueryParmVar) on the SLItems collection for this form. When I look at this, it does not appear that anything is passed to this variable. If I try to just add "AND Stat <>'O' after this, I get an error that AND is not valid. Anyone know what drives this filter? I do not see anything in Form Script. I would like to understand before I just remove it and add the filter I want.

Find more posts tagged with

Syteline Development

Accepted answers

All comments

unknown

Filter is not even spelled right...it says Fliter

jennifer-foster

This is what is on the vendor default version of the form.

0712131256598360.doc

unknown

I'm pretty sure the variable is for using the query forms that a lot of forms have.

If you filter-in-place on the "Items" form then navigate to the menu bar Actions > Filter > By Query it'll open up the "Items Query" form where a user can create more complex queries against the Items IDO.

If the variable is removed, I suspect that functionality would break.

As for adding the filter you want. It seems like a bug or oversight to me. I would expect that you'd be able to append expressions.

You might be able to work around it with a filter on the IDO itself, but I'd be careful with that too because the Items IDO could be used in places other than the Items form and may get unintentionally filtered.

Carsten Steinhoefel

You could use the Optional Filters for the additional filter you are building.

Copyright © 2025 Infor. All rights reserved.