Showing posts with label Filtering the data(record) based on selected Input ax 2012. Show all posts
Showing posts with label Filtering the data(record) based on selected Input ax 2012. Show all posts

Wednesday, 9 December 2015

Filtering the data(record) based on selected Input in Ax

For filtering a particular record    :


1.First create a table  i.e TableName   with fields name , Ids(Base enum) ,  Phno , Age

2.Create a form and drag the table 
TableName into data source.
in design take a grid and a combo box   give enum type as baseenum 

3.In class:
       public class FormRun extends ObjectRun
       {
             QueryBuildRange qbr2;  //  declartion of range variable
       }
4.In Data source level . Override a method init()
  1. public void init()
    {
          super();
         qbr2 = this.query().dataSourceName(“Datasourcename”).addRange(fieldNum(TableName, BaseEnum1));
    }
5.in combo box – in methods override a selectionchange method()
        public int selectionChange()
        {
               int ret;
               ret = super();
               
datasourcename_ds.executeQuery();
               return ret;
        }
6.Create a range by  overriding method executequery() in data source level: 
       public void executeQuery()
       {
           qbr2.value(comboboxName.valueStr());
           super();
       }
Note
     Set Auto Declaration :Yes for Combo box