RTC 3.x and complex queries
![](http://jazz.net/_images/myphoto/6cb9c0495bb3a0e721a6f3de9e7612e2.jpg)
I understand the query wizard does not yet support SQL-style complex queries. How about simple complex queries?
story1 -jb
--- task1A-jb
story2-ag
---task2A-jb
return all (my stories) OR (my tasks where parent.owner !=me)
story1
task2A
is this level of complex query support planned?
what's the advice for 3.x to get this sort of result up on a dashboard?
story1 -jb
--- task1A-jb
story2-ag
---task2A-jb
return all (my stories) OR (my tasks where parent.owner !=me)
story1
task2A
is this level of complex query support planned?
what's the advice for 3.x to get this sort of result up on a dashboard?
One answer
![](http://jazz.net/_images/myphoto/6cb9c0495bb3a0e721a6f3de9e7612e2.jpg)
Hi - Yes you can do that. First select a type and then create another and where the Parent\id = task2a's id or id's (just add a comma between them).
When you do this you are essentially creating a WHERE clause. In fact, whenever you come across a condition type with hiearchy you have the opportunity to create a complex queries.
When you do this you are essentially creating a WHERE clause. In fact, whenever you come across a condition type with hiearchy you have the opportunity to create a complex queries.