Hi, could some one help me to design oql query?
Here is the region structure as Region <String,PdxInstance> Key1 -> [*index=100*,maturity=*200*] Key2 -> [index=100,*maturity=100*] I am trying to design a query to *get index based on maturity...* select i.index from /data i where i.maturity=200 and *not* (i.index in set (select i1.maturity from /data i2)) [This works well for step1 and filters result for step2 but does not give answer for step2] 1. Get maturity based on index [Simple rule] 2. But if step1 gives index which itself is maturity anywhere, then simply output incoming maturity as it is [So in this case 200] Thanks, - Dharam Thacker
