It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,856

question asked: Mar 31 '09, 5:37 a.m.
question was seen: 6,480 times
last updated: Mar 31 '09, 5:37 a.m.

Related questions

how to I create a query with both AND and OR?

0
Clement Liu (31●7●2) | asked Mar 31 '09, 5:37 a.m.
for example, I want to create a query like this:

( created by me OR subscribed by me ) AND status is resolved

4 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Jakub Jurkiewicz (596●3●2) | answered Mar 31 '09, 6:02 a.m.
for example, I want to create a query like this:

( created by me OR subscribed by me ) AND status is resolved


1. Create new query
2. Choose AND condition for the query
3. Add condition for the status is resolved
4. In the box for the status click the menu button near the plus button and choose 'OR group'
5. In the new box click the plus button and add the conditions for created by and for subscribed by.

Does it work for you?

kind regards,
Jakub
0
permanent link
Clement Liu (31●7●2) | answered Mar 31 '09, 11:29 a.m.
Can you past a screen shot for step 4 and 5? Thanks. ;)


for example, I want to create a query like this:

( created by me OR subscribed by me ) AND status is resolved


1. Create new query
2. Choose AND condition for the query
3. Add condition for the status is resolved
4. In the box for the status click the menu button near the plus button and choose 'OR group'
5. In the new box click the plus button and add the conditions for created by and for subscribed by.

Does it work for you?

kind regards,
Jakub
0
permanent link
Blazej Kroll (46●2●1) | answered Mar 31 '09, 11:52 a.m.
Hello!
See the screenshots below:

http://etacar.put.poznan.pl:8443/blazej.kroll/jazz/QueryWithANDandOR/Export011.jpg

http://etacar.put.poznan.pl:8443/blazej.kroll/jazz/QueryWithANDandOR/Export018.jpg

So the example that you have give should look like this:

http://etacar.put.poznan.pl:8443/blazej.kroll/jazz/QueryWithANDandOR/Example1.jpg

Hope this helps.

Regards,
Blazej
0
permanent link
Clement Liu (31●7●2) | answered Mar 31 '09, 12:14 p.m.
Got them. It works. Thanks.

Hello!
See the screenshots below:

http://etacar.put.poznan.pl:8443/blazej.kroll/jazz/QueryWithANDandOR/Export011.jpg

http://etacar.put.poznan.pl:8443/blazej.kroll/jazz/QueryWithANDandOR/Export018.jpg

So the example that you have give should look like this:

http://etacar.put.poznan.pl:8443/blazej.kroll/jazz/QueryWithANDandOR/Example1.jpg

Hope this helps.

Regards,
Blazej

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.