cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

query builder report - family tables with instances not at same revision as generic

Alexandrite

query builder report - family tables with instances not at same revision as generic

Recently I had to find all family tables in our system in which any instance did not match the generic.  This .qml does not have a criteria to find this, but finds all needed info and I was able to filter in Excel using text functions.  Provided just in case anyone else can make use of it.

The attached file is named for a tech support case.

I'd still be interested if anyone can come up with a way to filter for revision of instance not equal to revision of generic.  Didn't work very hard on this - I'm a wizard for these things in Excel.

7 REPLIES 7

Re: query builder report - family tables with instances not at same revision as generic

Try with attached QML.

Hope it helps !!!

Thanks

Shreyas

Re: query builder report - family tables with instances not at same revision as generic

I don't see any difference.  note: Improved a bit since posting, but still getting results that are not latest Rev for some instances.  Latest that I have attached.

Re: query builder report - family tables with instances not at same revision as generic

Report works for me as expected see below screenshot.

FTREV.png

Re: query builder report - family tables with instances not at same revision as generic

There some problem with sub select. You don’t have criteria

FTINst.png

Re: query builder report - family tables with instances not at same revision as generic

You only get Sub-Select when you are site admin.

Re: query builder report - family tables with instances not at same revision as generic

Got it working - see attached

Re: query builder report - family tables with instances not at same revision as generic

Got it working - see attached