Seeking "Finance and Operations query syntax" examples from "Advanced filter or sort"

(1) Share

Report

Posted on by Paul V

168

Hi All:

I'm looking to create a view where the Financial Dimension Vendor is not = to the Vendor on the released product:

The Microsoft document for Advanced Sort and Query only provides 1 example

First, I'm looking for the correct syntax for above /query/, but would also like to find a document with many syntax examples of the Finance and Operations query

Thanks!

Paul

All responses (5)

Answers (1)

Sort by

Suggested answer

Frank Hamelly | MVP... 46,633 Moderator on at

Like (0)

Report
Copy link

Link copied!

Exclamation point (!) is the character representing 'not equal to' in a filter query. Here's the list of special characters for AX and F&O - Advanced filtering and query options | Microsoft Learn
Suggested answer

Mohit Rampal 12,573 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Paul, In addition you can check this article. As Frank mentioned, ! is used for Not equal to.

https://dynamics-tips.com/how-to-use-advanced-filter-d365-finance-and-operations/
Verified answer

André Arnaud de Cal... 307,101 Super User 2026 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hi Paul,

Your requirement is not possible to achieve using the advanced query syntax. The dimension fields are virtual fields for the query, but the syntax is not aware of it. It would require a customization to achieve it.
Paul V 168 on at

Like (0)

Report
Copy link

Link copied!

Thanks Andre, OK, so no way to do this with out a developer.

Does anyone have examples of syntax for what I have highlighted above?

I have the advanced sort/filter documents, but they do not have "Type a Query as a SQL statement):

((Accountnum LIKE "US*") && (DirPartyTable.name LIKE "Cont*" ) is the ONLY example
Suggested answer

Eugen Glasow 6,363 on at

Like (0)

Report
Copy link

Link copied!

The Microsoft's example does not really work, because it needs a “_1” counter after the system table name. I have another example for you, in a 3-join of Customers ← Parties ← Addresses and a query across:

((((LogisticsPostalAddress_1.CountryRegionId = "REU") || (LogisticsPostalAddress_1.CountryRegionId = "GLP")) && (CustTable_1.CustGroup LIKE "C-EX-NOEU*")) || (CustTable_1.CustGroup LIKE "*DO*"))

It is like “take all customers with a DOmestic group, but also the NOEU group customers, but only if these are from Reunion or Guadeloupe”.