Sign in
Microsoft.com
United States (English)
Brasil (Português)
Česká republika (Čeština)
Deutschland (Deutsch)
España (Español)
France (Français)
Italia (Italiano)
Россия (Русский)
대한민국 (한국어)
中华人民共和国 (中文)
台灣 (中文)
日本 (日本語)
香港特别行政區 (中文)
Resources for IT Professionals
Home
Resources for IT Professionals
>
Dynamics Forums
>
CRM
>
Filtering conditions
Ask a question
Search Forums:
Search CRM Forum
Search All Dynamics Forums
Search All Microsoft Forums
Filtering conditions
Wednesday, November 04, 2009 4:00 AM
Craig R
0
Sign In to Vote
Hi,
Is it possible to put in the Filter XML 2 OR conditions and a AND condition...
e.g.
I want (A OR B) AND C as the filter setup.
Thanks,
Craig
Reply
Quote
Answers
Wednesday, November 04, 2009 7:59 AM
Andriy a33ik Butenko
0
Sign In to Vote
Hi, Craig.
Following screenshots show how to do it:
Create two conditions:
http://lh6.ggpht.com/_73OmG38HHME/SvEzyT6TmGI/AAAAAAAAAX4/KP-GhAldS8I/s640/af1.jpg
Select both rows:
http://lh3.ggpht.com/_73OmG38HHME/SvEzydbQO_I/AAAAAAAAAX8/G_lqMsD77HM/s640/af2.jpg
Group conditions with OR:
http://lh3.ggpht.com/_73OmG38HHME/SvEzydBsVoI/AAAAAAAAAYA/_dUWoegugiA/s640/af3.jpg
Add third condition:
http://lh3.ggpht.com/_73OmG38HHME/SvEzySMguHI/AAAAAAAAAYE/BA4ZJVHja9w/s640/af4.jpg
I hope this will help you.
Truth is opened the prepared mind My blog -
http://a33ik.blogspot.com
Marked As Answer by
Craig R
Wednesday, November 04, 2009 8:41 PM
Reply
Quote
All Replies
Wednesday, November 04, 2009 7:59 AM
Andriy a33ik Butenko
0
Sign In to Vote
Hi, Craig.
Following screenshots show how to do it:
Create two conditions:
http://lh6.ggpht.com/_73OmG38HHME/SvEzyT6TmGI/AAAAAAAAAX4/KP-GhAldS8I/s640/af1.jpg
Select both rows:
http://lh3.ggpht.com/_73OmG38HHME/SvEzydbQO_I/AAAAAAAAAX8/G_lqMsD77HM/s640/af2.jpg
Group conditions with OR:
http://lh3.ggpht.com/_73OmG38HHME/SvEzydBsVoI/AAAAAAAAAYA/_dUWoegugiA/s640/af3.jpg
Add third condition:
http://lh3.ggpht.com/_73OmG38HHME/SvEzySMguHI/AAAAAAAAAYE/BA4ZJVHja9w/s640/af4.jpg
I hope this will help you.
Truth is opened the prepared mind My blog -
http://a33ik.blogspot.com
Marked As Answer by
Craig R
Wednesday, November 04, 2009 8:41 PM
Reply
Quote
Wednesday, November 04, 2009 8:43 PM
Craig R
0
Sign In to Vote
Hey wow, thanks for that. I didn't know you could do that in the UI screen. I've marked this answer correct even though I was looking at the XML format for it. In the end I figured it out by just adding another filter...
E.g.
...<filter type='or'><condition.../><condition .../></filter><filter type='and'><condition .../>...
Reply
Quote
Need Help with Forums? (FAQ)
© 2009 Microsoft Corporation. All rights reserved.
Terms of Use
|
Trademarks
|
Privacy Statement