OR Condition through Query Framework

In recent times many of my colleagues have come to me asking for having an OR condition in query framework here is a small example to achieve the same.
 
static void queryORCondtion(Args _args)
{
    Query           q;
    Queryrun        qr;
    CustTable       ct;
   
    str range;
    ;
   
    q = new query();
    q.addDataSource(tablenum(CustTable));
   
    range = strfmt(‘((%1 == "4000") || (%2 == "20"))’, fieldstr(CustTable, AccountNum), fieldstr(CustTable, CustGroup));
    q.dataSourceNo(1).addRange(fieldNum(CustTable, AccountNum)).value(range);
   
    qr = new QueryRun(q);
    while (qr.next())
    {
         ct = qr.getNo(1);
         info(ct.AccountNum);
    }
   
    info (qr.query().dataSourceNo(1).toString());
}

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s