Filter based on Multiple Parameters

Goal: Understand how to filter based on multiple parameters.

Lets say we have multiple PO numbers each have multiple lines with different status such as open,filled,ordered and etc. Now when user select a PO number only show the lines that are pertinent to that PO number, this could expand when user select PO number and status only show the lines that match the requirement(PO number and status). For now when a user select a PO number it shows all the lines numbers.

Thank you so much!

Find more posts tagged with

Syteline Development

Accepted answers

Ryan Pukanski

Yes, you can do that. Bind your Line component and then add a list source of IDO collection and point it to IDO lines. Then add a filter with something like:

PoNum = FP(PoNum)

PoNum on the left is the PoNum from your IDO list collection. FP(PoNum) on the right is the PoNum from your form IDO collection.

Give that a try, hopefully it works. I haven't done this myself in awhile.

Ryan Pukanski

You can create an event handler to set the value of the component or property. And then set the event of "Data Change" on your component to run the event which would clear your value whenever the data changes on your PO number or line. Give that a try.

All comments

Ryan Pukanski

Give that a try, hopefully it works. I haven't done this myself in awhile.

Legacy Contributor

Thank you so much, your response has helped me get the Line number for the PO.

However for Change number i believe i need to filter based on PO change number and the line number, so how would you add two filters using AND ?

Ryan Pukanski

You got it. You can use an AND in the filter clause to filter more properties.

0712131256598360.doc

Legacy Contributor

Worked as expected, thanks for your time!

Copyright © 2025 Infor. All rights reserved.