QueryBuildDataSource SortOrder

(0) Share

Report

Posted on by Community Member

Hello everyone,

I recently was using the query builder classes and wanted to see the sorting managed.

I found that when using the SortOrder static method there was no difference in direction when specifying Descending.

Does anyone know why in this block of code the sort order does not matter?

Here is a simple code sample you can run in a job.

static void Cyborg3QueryBuild2(Args _args)
{
    Query   query;
    QueryRun    qr;
    QueryBuildDataSource    qbds;
    QueryBuildRange qbr;
    VendTable   vendTable;
    
    query = new query();
    qbds = query.addDataSource(tableNum(vendTable));
    qbr =   qbds.addRange(fieldNum(vendTable, VendGroup));   
    qbr.value('10');

//here is the line where I thought I could control the sort direction

    qbds.addSortField(fieldNum(vendTable, AccountNum),SortOrder::Ascending);
    qr = new QueryRun(query);
    
    if(qr.prompt())
    {
      while(qr.next())  
        {
            vendTable = qr.get(tableNum(vendTable));
            info( vendTable.AccountNum);
        }
    }
    
    
}

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Sohaib Cheema 48,887 User Group Leader on at

Like (1)

Report
RE: QueryBuildDataSource SortOrder

Hi Keith,

This is because of syslastValue. it is always getting previously used query, which was saved in Last Value.

you can solve this by introducing one line of code, immediately after query run.

qr = new QueryRun(query); qr.saveUserSetup(false);//add this new line in your code.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: QueryBuildDataSource SortOrder

Thanks Sohaib. I did try to find this answer but wasn't lucky. As always I appreciate the response.

Was this reply helpful? Yes No