Monday, 15 February 2016

DataSource filter the using below statement in Init in DS Method

Form Init method 
Based on If Condition Datasource will get filter the Data from Respective Table:

if(element.args().menuItemName() == menuitemDisplayStr(InventTransItemOnorder))
    {
        InventTrans_ds.query().dataSourceTable(tableNum(InventTrans)).addRange(fieldNum(InventTrans, StatusIssue)).value(queryValue(StatusIssue::OnOrder));
    }
    if(element.args().menuItemName() == menuitemDisplayStr(InventTransItemOnorderTotal))
    {        InventTrans_ds.query().dataSourceTable(tableNum(InventTrans)).addRange(fieldNum(InventTrans, StatusReceipt)).value(queryValue(StatusReceipt::Ordered));
    }