How do I get the list source for a specific row of a grid column using a form script?

I need to determine if a value is contained in the list source of a grid column row. Rows can have different lists so Thisform.Components("SerialNumberGridCol").List is not accurate for every row.

The actual list source is:

STDOLE SLSerials( PROPERTIES(SerNum, Loc, Lot) DISPLAY(1)FILTER(Item=FC(ItemGridCol) AND Loc=FC(LocationGridCol) AND Lot = FC(LotGridCol) AND RsvdNum = '' AND AssignedToBePicked = 0))

Find more posts tagged with

Accepted answers

Legacy Contributor

You are getting the list values from an IDO Collection, so why not just do a load collection to get the values directly from the IDO, passing in the same filter values?

All comments

Legacy Contributor

You are getting the list values from an IDO Collection, so why not just do a load collection to get the values directly from the IDO, passing in the same filter values?

Legacy Contributor

I thought there might be a way to access the list source property directly but if not I will recreate it.

Then my question becomes is there a way to get a list or array of values for the SerNum property without iterating through the filtered collection.

Legacy Contributor

Components are just viewers for the data in the collections. Ultimately you have to access the collection directly to get at the data. You can do comparisons against the currently selected value, as that is the only value it stores in the component on the active form, but that is about it.

Copyright © 2025 Infor. All rights reserved.