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.
