Displaying data from two tables in a grid

We are using the Cloud version of Mongoose.

I have two separate tables (IDO's) that are similar. One table is history data and one table is current data. The data changed between history and current - so I can't just have one table.

What I want to do is a Union of the tables. But it appears that I can't create a Union. It appears that IDO's only allow Joins - not Unions. Please let me know if there is a way to do a Union that I'm not aware of it.

What I'm doing is reading each table via the LoadCollectionRequestData in Form Script. Then combining the data from each table together. Then adding the combined data to the Primary Collection.

To add the data to the Primary Collection, I have this statement: ThisForm.PrimaryIDOCollection.New();
To add each field, I have this statement for each field: ThisForm.PrimaryIDOCollection.SetCurrentObjectProperty("RowPointer", row.RowPointer);

This works. But the grid row shows a star (*) next to the grid line number. Is there a way to not have the star appear?

Please let me know if you have any suggestions on the best way to handle this use case. Thanks for your help.

Find more posts tagged with

Accepted answers

kazuyuki-mochizuki

At the end of the script please try.

ThisForm.CurrentIDOCollection.SetObjectNew(1, false);
ThisForm.CurrentIDOCollection.SetObjectNew(0, false);
ThisForm.CurrentIDOCollection.SetObjectModified(0, false);
ThisForm.CurrentIDOCollection.SetObjectModified(1, false);

All comments

Legacy Contributor

I'm also curious if UNION is possible, although I don't have a specific use case. The star is indicating you're adding new rows into the collection (which will have a New state), no? It sounds like that's what you've got in your FormScript if I'm understanding correctly.

0712131256598360.doc

Yao Jiang

Try SetCurrentObjectPropertyPlusModifyRefresh()

There is more detail on it in the Infor doc

tdickens

@Yao

Adding the PlusModifyRefresh still puts the star next to the grid number. It appears there isn't a way to not show the star. But I wanted to check the forum to make sure.

IDF_Developer_Techniques_Tips_Tricks_EIUG2021.mp4

Yao Jiang

the blue star is the indicator of a new record.

You will have to do a save action after setting your row to get rid of it.

tdickens

This form is just for listing data. I don't want to do a save. And I'm moving the results from two different tables into the collection.

Sounds like there is no way around the star. And no way to do a Union.

Thanks for your help. I appreciate it.

kazuyuki-mochizuki

At the end of the script please try.

tdickens

@Kazuy

That worked. Thanks.

I have a foreach loop and put these two lines in in the loop.

ThisForm.CurrentIDOCollection.SetObjectNew(i, false);
ThisForm.CurrentIDOCollection.SetObjectModified(i, false);

Copyright © 2025 Infor. All rights reserved.