Cancel
Showing results for 
Search instead for 
Did you mean: 

Query Builder: Find Items based on Revision status objects

Genius
Genius

I've scenario

 Item1

   |_Rev0 (status 40)

   |_ Rev1 (status 60)

 

Item2

   |_Rev0 (status 60)

   |_ Rev1 (No status)

 

I want to find all Items which doesnt have revision with status40. In above case i want find Items like Item2. 

Is this possible through query builder. Pls help me to build query.

1 REPLY

Re: Query Builder: Find Items based on Revision status objects

Legend
Legend

You can't build such a query using query builder, you will either have to user exit query or write a custom ITK program.

---

Thanks and Regards

Yogesh Fegade