Showing results for 
Search instead for 
Do you mean 
Reply
Solved! Go to solution

Query builder: Find datasets where release status differs from ItemRevision

Hello,

 

experiencing a bug that some datasets are not revised correctly regarding their status I would like to find all datasets where release status (status: 62) is not equal to the release status of the ItemRevision (status: 90).

 

Has anyone an idea what attribute has to be used?

I tried to use the revisionAnchor and rev_chain_anchor as well as the itemtag but it did not deliver the desired result.

 

Any help is highly appreciated.

 

Best regards

Julian

 

1 REPLY
Solution
Solution
Accepted by topic author Jul1an
‎01-05-2016 10:19 AM

Re: Query builder: Find datasets where release status differs from ItemRevision

alright, I have found a solution. Maybe it will come in handy for someone else:

 

In the Query builder select base class: Item Revision 

 

To look for item revisions with a specific release status:

  • release_status_list.name

To look for datasets with a specific release status simply add:

  • dataset.IMAN_manifestation.release_status_list.name

> the IMAN_manifestation was in my case the relation how item revisions and datasets are linked.

 

> Make sure "all attributes" and "real names" are selected in "preferences".

 

kr 

Julian