Differnt types of Range value formats

Usually in forms we filter date as per the given ranges.We specify the Ranges using queryBuildrange class.

Here is a collection of different range formats.

Range in String format

1) if(element.args().dataset() == tableNum(CustTable)
{

adrTableid.value(strfmt('%1', CustTable.TableId));
adrRecid.value(strfmt('%1', CustTable.RecId));
}

2)this.query().dataSourceNo(1).addRange(fieldnum(COSCalcTrans, RecId)).value('!' + queryValue(COSCalcTrans.RecId));


3) case DM_AllWOStatus::All :

qbrStatus.value(queryvalue(WOStatus::Openorder) + ","

+ queryvalue(WOStatus::WIP) + ","

+ queryvalue(WOStatus::Completed) +","

*

queryvalue(WOStatus::Invoice ));


4)this.query().dataSourceTable(tablenum(LedgerJournalTrans)).range(1).value(strfmt('((%1 == "%3") || (%2 == "%3"))',
fieldstr(LedgerJournalTrans,AccountNum),
fieldstr(LedgerJournalTrans,OffsetAccount),
ledgerTable.AccountNum));


Date Range

1)criteriaBOMToDate1.value(queryRange(fromDate,dateMax())); fromdate = some specific date

2)reconciledDate.value('>' + date2StrXpp(dateNull()));

3)criteriaBOmToDate2.value(queryValue(dateNull()));

4)criteriaBOMFromDate.value('');

Enum as Range

1)qbrStatus.value(queryvalue(DM_WOStatus::Invoice));

2)criteriaOpen.value('0..1');


Form Control value as Range

1)typeRange.value(ctrlTypeRange.text() ? ctrlTypeRange.text() : SysQuery::valueUnlimited());