Skip to main content

Posts

Showing posts with the label query build range in ax

Use multiple table link through code in Axapta report

By
public boolean fetch() { str 50 tmpregno; QueryBuildDataSource qbds,qbds1,qbds2; QueryBuildRange queryBuildRange; QueryBuildRange rangeTransDate; QueryRun qr1; QueryBuildLink QueryBuildLink_1; query q = new Query(); query q1 = new Query(); ; // frmdt = str2date("01/05/2010",123); // todt = str2date("30/05/2010",123); q = this.query(); q1 = this.query(); qbds2 = q.addDataSource(tablenum(_Registration)); qbds1 = qbds2.addDataSource(tablenum(_RegistrationDetails)); qbds = qbds1.addDataSource(tablenum(_Register4)); qbds.joinMode(JoinMode::InnerJoin); QueryBuildLink_1 = qbds.addLink(fieldNum(_RegistrationDetails, _RegistrationNo), fieldNum(_Register4, RegistrationNo)); qbds.relations(true); queryBuildRange = qbds.addRange(fieldNum(_Register4, ProcessDate)); rangeTransDate = qbds.findRange(fieldnum(_Register4,ProcessDate)); /* if(!rangeTransDate.value()) { rangeTransDate.value(queryRange(dateMin,dateMax)); if (dateMin ==str2date(...
Read more