2 Nov’15

Dynamics AXFilters available in AX 2012

Filters plays a very important role in getting the data in a fast and easy manner. AX is designed in such a way that the filters can be used on all the forms. The user can filter the data by providing syntax in the filter field available on the form or by clicking Ctrl+ G. When the user clicks Ctrl+G, a new row is created below the column header of the grid.

The following filtering and query options are available when you use embedded filters or queries.

  1. Syntax – Value
    Character Description – Equal to the value entered
    Description – Type the value to find.
    Example – Alex finds “Alex”.
    1

     

  2. Syntax – !Value
    Character Description –  Not Equal to the value entered
    Description – Type an exclamation mark in front of the value to exclude.
    Example –!Alex finds all values except “Alex”
    2

     

  3. Syntax – From-value..To-value
    Character Description –  Between the two values entered separated by double periods. Description – Type the From value, then two periods, and then the To value.
    Example – 10..30 finds all values from 10 to 30.
    3

     

  4. Syntax – ..value
    Character Description –  Less than or equal to the value entered
    Description – Type the two periods and then the value.
    Example – ..50 finds any number less than or equal to 50.
    4

     

  5. Syntax – ..
    Character Description –  Greater than or equal to the value entered.
    Description – Type the value and then the two periods
    Example – 50.. finds any number greater than or equal to 50.
    5

     

  6. Syntax – >value
    Character Description –  Greater than the value entered.
    Description – Type a greater than sign (>) and then the value.
    Example – >20finds any number greater than 20
    6

     

  7. Syntax – <value
    Character Description –  Less than the value entered.
    Description – Type a less than sign (<) and then the value.
    Example – <50 finds any number less than 50
    7

     

  8. Syntax – value*
    Character Description –  Starting with the value entered.
    Description – Type the starting value and then an asterisk.
    Example – S* finds any string that starts with S
    8

     

  9. Syntax – *value
    Character Description –  Ending with the value entered.
    Description – Type an asterisk and then the ending value.
    Example – *ltd finds any string that ends with ltd.
    9

     

  10. Syntax – *value*
    Character Description –  Contains the value entered.
    Description – Type an asterisk, then a value, and then another asterisk.
    Example – *pvt* finds any string that contains pvt.
    10

     

  11. Syntax – ?
    Character Description –  Having one or more unknown characters.
    Description – Type a question mark at the position of the unknown character in the value.
    Example – Sa??abh finds “Saurabh”
    11

     

  12. Syntax – value,value
    Character Description –  Matching the values entered separated by commas.
    Description – Type all your criteria separated by commas.
    Example – 30,80 finds exactly “30” and “80”.
    12

     

  13. Syntax – T
    Character Description –  Today’s date
    Description – Type “T”
    Example – Enter T and click Tab/Enter, it will bring todays date.
    13

    The above provided syntax are very useful in day to day activities in AX. User can use the syntax in combination also, by using “&” syntax.

     

    Written by

    Team Member

    CloudFronts

One thought on “Filters available in AX 2012”

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload the CAPTCHA.

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • Reading more then 10K records in D3FOE OData API

    11 July’ 2018

    Introduction: We all know Dynamics 365 Finance and Operations has limitation of 10K records to be fetched at a time usi...

    Read more
  • Paging in D365 Customer Engagement v9.0

    10 July’ 2018

    Introduction: The Xrm.retrieveMultipleRecords method is used to retrieve a collection of records in Dynamics 365 Custom...

    Read more
  • Set up Dynamics 365 connection in Microsoft Social Engagement

    10 July’ 2018

    Introduction: This blog explains how to Set up Dynamics 365 connection in Microsoft Social Engagement. Steps to be follo...

    Read more
  • Voice of the Customer failed to install

    10 July’ 2018

    Introduction: Many people face issues in installing Voice of Customer solution on v9 environment and trying repeatedly ...

    Read more
  • Scribe Insight AX as a Web Service Find Block issue

    10 July’ 2018

    Introduction: If we need to look up for any value from AX then we do it by using a Find Block in Scribe Insight Eg: Basi...

    Read more