Peter Borsje - Thursday, November 6, 2014 6:53 AM:
In Aras we have three related items: System -> Document -> Transmittal
In the maingrid we would like to see information of all these 3 items and being able to use the filters (simple, aml and advanced)
Does anyone have experience or know how to achieve this and still have good performance with long lists?
Peter
DavidSpackman - Sunday, November 9, 2014 8:47 PM:
Hi Peter,
From my understanding of your problem,
Can you expose the Document itemtype on the main grid, and then use source_id/related_id foreign properties to show the information you require on the grid?
I use this to expose Part BOMs onto the grid - allows me to show part names and item numbers for both parent (source) and child (related) items.
Also use for to expose Part AML as well.
Dave.
Peter Borsje - Thursday, November 20, 2014 3:07 AM:
Hi David,
I also use the relationship itemtype in the grid and show information from related_id and source_id.
In my case I need to show information from 5 items that are related.
We tried it with a federated itemtype but the problems is that you cannot use (simple) filters on the maingrid.
You can not just get all the items, you need to be able to set a query with the grid filter.
By the way, did you also have performance issue (long delay before data comes) with Part BOM on the maingrid? It will help if you configure a permission on the relationship itemtype.
Peter
