web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... Logical Operators (Ord...

Microsoft Dynamics 365 | Integration, Dataverse...

Suggested Answer

Logical Operators (Order of Precedence)

(0) Share

Report

Report

Posted on by RoyalOne

15

I am trying to assist a colleague with a query.

Pgm = SAIL

OR

AND

Status Equal Active

Start Date On Or Before 1/31/2023

AND

End Date On Or Before 1/31/2023

AND

Start Date On Or Before 1/31/2023

End Date On or After 2/1/2023

Which order are the 'AND' Clauses resolved? Top to Bottom?

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Eiken Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

In your query, there are three And groups in a Or group.

The result will satisfy all conditions in any “And Group”.

So the order about 'AND' Clauses resolved doesn’t really matter, And means all conditions in this group should be satisfied.

Was this reply helpful? Yes No
Suggested answer

Eiken Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

Did my answer help you?

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1

André Arnaud de Cal... 69 Super User 2026 Season 1

#2

BillurSamdancioglu 55 Most Valuable Professional

#2

Abhilash Warrier 55 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Welcome to the Microsoft Dynamics 365 forum!

Identifying an Org as CDS or Dynamics

Get batch job history log from D365 FO to Power Automate

Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans