News and Announcements icon

Dynamics 365 CommunityForums Customer experience | Sales, Customer Insights,... FILTERS/QUERY: cannot ...

Customer experience | Sales, Customer Insights,...

Answered

FILTERS/QUERY: cannot change from AND to OR

(0) Share

Report

Report

Posted on by Wolverine

565

I need to create a query with 2 groups. The first group will find records on or after X date AND on or before another date. The second group will also search on a date field, and this will also be an 'on or after' AND 'on or before'. I want to find records if either of these groups matches the query. However, when you open the Filter dialog, the AND is grayed out and can't be changed to an OR?!

1) Does anyone know why you can't change this to an OR?

2) Is there a way to change this to an OR?

If not, how can I get into the Old Query Designer, so that I can build my Query?

All responses Img

All responses (2)

Answers Img

Answers (1)

Wolverine 565 on at

Like (0)

Report

FILTERS/QUERY: cannot change from AND to OR

Thanks. That is very helpful. Cheers.

It's a pity that the NEW interface is more time-consuming/takes longer than the old way. Not sure Microsoft understands what constitutes and improvement!
Verified answer

Dengliang Li Microsoft Employee on at

Like (1)

Report

FILTERS/QUERY: cannot change from AND to OR

Hi,

You can follow the steps below to set up the filter query.

If my answer was helpful, please click Like, and if it solved your problem, please mark it as verified to help other community members find more.
If you have further questions, please feel free to contact me .

Best Regards,
Dengliang Li

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans