Thursday 26 November 2015

Query ,QueryBuildDataSource ,QueryBuildRnage in axapta

Query and QueryBuildDataSource

{
    Query q = new Query();
    QueryBuildDataSource ds;
    ;

        ds = q.addDataSource(TableNum(CustTable));
}

Add more than one DataSource

{
    Query q = new Query();
    QueryBuildDataSource ds ;
    QueryBuildDataSource ds1;
    ;

        ds = q.addDataSource(TableNum(CustTable));
        ds1 = ds.addDataSource(TableNum(CustTrans));
}
  

Add proper Range 

{
    Query q = new Query();
    QueryBuildDataSource ds ;
    QueryBuildDataSource ds1;
    ;

        ds = q.addDataSource(TableNum(CustTable));
        ds1 = ds.addDataSource(TableNum(CustTrans));
        ds1.relation(true)
        ds1.addrange(FieldNum(CustTrans,fieldnum)).value(noyes::yes);
}
  

No comments:

Post a Comment