Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) adding > to query ...

adding > to query range

(0) Share

Report

Posted on by Community Member Microsoft Employee

hi guys,

i have a table called TestTable which contains 2 fields qty1 and qty2 i need to add a queryrange like(where qty1 >= qty2)

    query q;
    TestTable test;
    QueryBuildDataSource    queryBuildDataSource;
    QueryBuildRange         queryBuildRange;
    queryrun qr;
    ;

    q = new query();
    queryBuildDataSource = q.addDataSource(tablenum(TestTable),tablestr(TestTable));
    queryBuildRange = queryBuildDataSource.addRange(fieldnum(TestTable,qty1));
    queryBuildRange.value(strfmt('> TestTable.qty2'));
    //queryBuildRange.value('TestTable.qty1 <= TestTable.qty2');
    info(queryBuildRange.toString());
    qr = new queryrun(q);
    while(qr.next())
    {
        test =qr.get(TableNum(TestTable));
        info(strfmt('%1 > %2',int2str(test.qty1),int2str(test.qty2)));
    }

but its not working can anyone help

*This post is locked for comments

All responses (3)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

Re: Re: Re: adding > to query range

Both of your above codes worked :). thanks Toporjinschi
Toporjinschi Sergiu 205 on at

Like (0)

Report

Re: Re: adding > to query range

or
queryBuildRange.value(strfmt(' ( TestTable.qty1 >= TestTable.qty2 ) '));
Toporjinschi Sergiu 205 on at

Like (0)

Report

Re: adding > to query range

hello!!
this will work
     queryBuildRange.value(strfmt('(%1.%2 >= %1.%3)',
                                       tableid2name(queryBuildRange.table()),
                                       fieldstr(TestTable,qty2),fieldstr(TestTable,qty1)
                                      );