Hi there,
I'm currently fumbling around with SP12 and am trying to get a tree grid view to display on the main grid instead of a relationship grid. For instance, I'd want to display all my Part BOMs in the main grid to allow users to manually browse through them. A next step would be to show both Part BOMs and Part Documents so users can navigate through the Part structure to find the Document item they want to work on/review etc.
I manage to get the grid up and running in relationship grids using the Tree Grid View and Query builder but can't seem to get it to work in the main grid.
To make things easier, our Part items have an "is_top" property to define whether or not the item is the top item in its respective Part BOM, so to gather the top elements for each Part BOM one just has to look for elements where the "is_top" property is set to 1. From there, the rest of each tree can be added.
Dear Chris,
The form now works as desired, thank you so much for your help!
For now I've tried it with a different query, which seems to function as expected. I'll just rebuild the query step by step so I can easily see where I go wrong.
Are there any easy ways to query for an entire tree rather than expand the query layer by layer? I.e. in the Part BOM scenario, is it possible to easily query for the entire Part - Part BOM - Part tree instead of building a large enough Part - Part BOM - Part - Part BOM - Part - Part BOM - Part structured query?
Dear Chris,
The form now works as desired, thank you so much for your help!
For now I've tried it with a different query, which seems to function as expected. I'll just rebuild the query step by step so I can easily see where I go wrong.
Are there any easy ways to query for an entire tree rather than expand the query layer by layer? I.e. in the Part BOM scenario, is it possible to easily query for the entire Part - Part BOM - Part tree instead of building a large enough Part - Part BOM - Part - Part BOM - Part - Part BOM - Part structured query?
