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

(1) Share

Report

Posted on by Paul V

166

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

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Frank Hamelly | MVP... 46,627 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

Was this reply helpful? Yes No
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/

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 303,730 Super User 2026 Season 1 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.

Was this reply helpful? Yes No
Paul V 166 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

Was this reply helpful? Yes No