Multiple Item Secondary Collection

Hi I am trying to add a second collection that should return multiple items (rows) back, and only the first row is being displayed. I made sure distinct is off but that has had no effect.

I also tested the Second Collection, and it is returning multiple items based on my filter. So I am not sure where to look next!

Thanks,

Isaac Hartzell

Find more posts tagged with

Accepted answers

All comments

Caitlin Porter

If it were me, I would put the filter in a variable so I can see it first. Secondly, did you try forcing a refresh on the secondary collection?

Legacy Contributor

I thought about that, but it make more sense to leave it a Property Value because the secondary collection is actually used for each item in the primary collection. I did not try and force a refresh on the secondary collection, I am not sure where to put the event, I mean MainFlexLayout -> DataChange -> ? I am assuming StdObjectNext, I will test now.

Legacy Contributor

The best way to relate parent-child collections is to use a Subcollection property on the parent IDO. The following link provides documentation for Subcollections and how to use them:

Understanding forms with subcollections (infor.com)

Subcollections are a better approach because:

There are form tools to directly bind subcollection properties without having to setup secondary collections and refresh events
The constraint relationships are maintained between the two collections - deleting the parent will delete the child objects (if so configured)
Subcollections don't incur the same performance penalty that adding multiple collections to a form does

Legacy Contributor

Sorry, English link below:

Understanding forms with subcollections (infor.com)

Legacy Contributor

So I have the extended IDO with the sub collection property, however, when I try and bind the properties there is no data. I think this is caused because I am trying to extend an IDO with a custom load method. So would I just create an event to fill the sub collection property? or rely on the "link by" on the property itself?

Legacy Contributor

An important distinction to make for others to provide advice... In that case, the data isn't coming from the IDO, the IDO is just providing a data model that is filled in by the CLM. The join for this other collection should be in the CLM logic, with placeholder IDO Properties in the IDO that get filled in by the CLM when it executes. You can't join other collections on a form to a primary collection that is a CLM.

Copyright © 2025 Infor. All rights reserved.