Finance | Project Operations, Human Resources, ...

Answered

F&O Grid Advanced Filter or Sort: Combine terms to do a logical AND search on item description?

(0) Share

Report

Posted on by jt1024

185

Hello,

I hope this is the correct forum under which to post this question, please direct me to another MS D365 F&O forum if this is not the correct place.

My question:

We have the dimension "Product name" that contains item descriptions.

How do I combine two text search terms?

For example:

I want to search on 'ice cream*' (Starts with ice cream)

AND

I want to limit that search to contain "rocky road"

How do I do that?

Currently I have tried using the Advanced filter or sort Page Option in the Released Product Variants page. From there I can set an inquiry with distinct rows that offer:

Table | Derived table | Field | Criteria

When I enter 2 criteria rows for Field: Product Name and Criteria, the result is a logical OR search of anything containing criteria 1 OR criteria 2.

I must be using the interface incorrectly or the function I am seeking does not exist? Though I'm thinking it's my usage not a deficiency in D365 F&O

I am using https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/fin-ops/get-started/advanced-filtering-query-options?context=%2Fdynamics365%2Fcontext%2Fcommerce and

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/user-interface/filtering as a reference so far.

Thanks to any and all for any help you can provide to this basic question.

All responses (3)

Answers (1)

jt1024 185 on at

Like (0)

Report

RE: F&O Grid Advanced Filter or Sort: Combine terms to do a logical AND search on item description?

Excellent! That works, and taught me a new way to think of using wildcards! Much appreciated.

- Jim
Verified answer

André Arnaud de Cal... 291,703 Super User 2024 Season 2 on at

Like (0)

Report

RE: F&O Grid Advanced Filter or Sort: Combine terms to do a logical AND search on item description?

Hi Jim,

When you mention that the product name should start with "Ice cream", I do assume that "rocky road" is not the first part of the dimension value. In that case, you can do the filtering with one query value: "Ice cream*rocky road*". This will tell that the value should start with the first part and it should contain the second part which is surrounded by the wildcard character.
jt1024 185 on at

Like (0)

Report

RE: F&O Grid Advanced Filter or Sort: Combine terms to do a logical AND search on item description?

I found this:

"(Finance and operations query) (finance and operations query between parentheses) ... Type a query as an SQL statement between parentheses using the finance and operations query language.

((AccountNum LIKE "US*") && (DirPartyTable.Name LIKE "Cont*"))

as an example of syntax for a filter condition on a field from the root datasource as well as a field from a different datasource (for the All customers page)"

But I can't find more on "Finance and Operations Query Language, and that requires knowing the data table field name and not the user interface display name for the field by the looks of it.

F&O Grid Advanced Filter or Sort: Combine terms to do a logical AND search on item description?

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Meet the Top 10 leaders for December

Start Your Super User Journey

Leaderboard

Featured topics

Product updates

F&O Grid Advanced Filter or Sort: Combine terms to do a logical AND search on item description?

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Meet the Top 10 leaders for December

Start Your Super User Journey

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates