Showing results for 
Search instead for 
Do you mean 
Reply

Query Builder: Find Items based on Revision status objects

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

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