Thursday, 9 October 2014

Date Range query(From date ...Todate ) on MS Dynamics Ax using x++ code

 
    Query                   q;
    QueryBuildDataSource    qbd;
    QueryBuildRange         qbr,qbr1;

   // ret = super();

    q = new Query();
    qbd = q.addDataSource(TableNum( RateLine));
    qbr = qbd.addRange(FieldNum( RateLine, StartDate));
    qbr1 = qbd.addRange(FieldNum( RateLine, InflationTypeID));
    qbr1.value(InflationRate_Type.valueStr());
    qbr.value(strfmt('"%1".."%2"',FromDate.dateValue(), editEndDateRange.dateValue()));
    RateLine_ds.query(q);
    RateLine_ds.executeQuery();

No comments:

Post a Comment