Query Clear ranges and QBRS


Here we need to build the query and need pass the new value by clearing the old filtered data based on query ranges.

month = MonthYear_args.selection();

qbds = MZK_PayrollProcessed_ds.query().dataSourceTable(tablenum(MZK_PayrollProcessed));


or qbds.clearRange(fieldNum(MZK_PayrollProcessed,MZK_MonthYear)); //alternative way of clearing ranges

queryBuildRange = qbds.addRange(fieldnum(MZK_PayrollProcessed, MZK_MonthYear));

queryBuildRange. Value(int2str(any2int(month)));



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 )

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s