query builder report - family tables with instances not at same revision as generic
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
-
Other
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Try with attached QML.
Hope it helps !!!
Thanks
Shreyas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Report works for me as expected see below screenshot.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
There some problem with sub select. You don’t have criteria
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You only get Sub-Select when you are site admin.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Got it working - see attached
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Got it working - see attached
