- When setting up filters on D365, users can include conditions to their search for more (or less) results.
- The basic “language” for filtering is as follows:
Source: https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/user-interface/filtering
- Based on the above, example searches are shown below:
|
Description |
Filter Operator |
Filter Example |
|
To filter everything that is not MC |
! |
!MC |
|
To filter multiple values from MC, CH, CB |
, |
MC,CH,CB |
|
To filter all that contains MC |
* |
*MC* |
|
To filter all that does not contain MC |
!* |
!*MC* |
|
To filter value begins with MC |
* |
MC* |
|
To filter value greater than 100 |
> |
>100 |
|
To filter value greater than or equal to 100 |
.. |
100.. |
|
To filter value lesser than 100 |
< |
<100 |
|
To filter value lesser than or equal to 100 |
.. |
..100 |
|
To filter value between 100 and 200 |
.. |
100..200 |
Comments
0 comments
Please sign in to leave a comment.