I'm using "../Solutions/PLM/scripts/ReverseItemsGrid.html" on a version ItemType
I have a itemType "A" that is in Rev-A Gen-1. If I open ItemType "B" and add relationship from (ItemType-A, Rev-A, Gen-1) the "ReverseItemsGrid.html" in itemType "A" works fine, but if I make changes to ItemType "A" and change its Rev to "B", I lose the "ReverseItemsGrid.html" because it still linked to "Rev-A,Gen-1".
How can I get ReverseItemsGrid.html to point to "Is_current". I think now it's pointing to the ID.
Hi Dominic,
There are a few different ways to accomplish this.
Change the behavior of the relationship to "Float" rather than "Fixed"
This will force the relationships to always point to the newest version of an item
NOTE: this will also change the data you are storing which may not be desired
Manually edit the reverse items grid
You can find this under \Innovator\Client\Solutions\PLM\scripts\ReverseItemsGrid.html in your codetree
You would want to update the query near line 218 to use the config_id rather than the id
NOTE: Rather than editing the existing ReverseItemsGrid.html, I would recommend creating a copy of the file called "CurrentReverseItemsGrid.html" that you can make your changes to
If you are using 11.0 SP10 or greater, use the new Query Builder/Tree Grid View functionality
Using these new tools, you can easily create a reverse lookup query and display the grid anywhere you want
Hi Dominic,
There are a few different ways to accomplish this.
Change the behavior of the relationship to "Float" rather than "Fixed"
This will force the relationships to always point to the newest version of an item
NOTE: this will also change the data you are storing which may not be desired
Manually edit the reverse items grid
You can find this under \Innovator\Client\Solutions\PLM\scripts\ReverseItemsGrid.html in your codetree
You would want to update the query near line 218 to use the config_id rather than the id
NOTE: Rather than editing the existing ReverseItemsGrid.html, I would recommend creating a copy of the file called "CurrentReverseItemsGrid.html" that you can make your changes to
If you are using 11.0 SP10 or greater, use the new Query Builder/Tree Grid View functionality
Using these new tools, you can easily create a reverse lookup query and display the grid anywhere you want