CLM bound to a Primary IDO Collection Grid but want to use the filters

here is my issue:

I have written a custom load method to load results to the OrdersGrid for the Pick Workbench so I can get the records I want. This works - but the end user wants to further be able to filter the results using the standard filter options with the grid columns. For example, if they enter "Part1" in the Item column and filter, they want the results to still use the results from the CLM but only show records for "Part1". Does anyone know how to capture this filter? I tried something like this and I cannot seem to capture the filter:

Sub GetFilter()
Dim f as String
f = ThisForm.PrimaryIDOCollection.Filter
ThisForm.Variables("vPIFilter").Value = f
End Sub

Any examples or suggestions welcomed!

Find more posts tagged with

Accepted answers

nfelicioni

Jennifer,

I would suggest looking at the Planning Detail form. It uses a CLM where they pass the filter. It looks like there is some manipulation you may have to do to make the filter usable.

All comments

kazuyuki mochizuki

Hi Jennifer,

I think, if you can store the grid results after the custom load to a temp IDO (loop in formscript and insert) then the filter in place function will work. you may need a second grid binded to the temp IDO.

Second option I see is a workaround.. drop a textbox and button.. the button will remove the items on the grid if grid.items <> textbox (formscript loop then removeentries).

Im curious if this can be done via AES or IDO Load Save overrides.

Regards,

Kaz

jennifer-foster

Kaz - Hey there! Thanks for the suggestions. What I was hoping to do was to capture the filter and then just pass it as a variable to my CLM. Then update the CLM to say if the filter variable <> null then to further filter the results by whatever is in it. Does this make sense?

nfelicioni

Jennifer,

I would suggest looking at the Planning Detail form. It uses a CLM where they pass the filter. It looks like there is some manipulation you may have to do to make the filter usable.

jennifer-foster

Using the Planning Detail form as an example as suggested by @nfelicioni, I was able to get this to work. Thank you all for your help!

Copyright © 2025 Infor. All rights reserved.