Dynamics Community Forum Thread Details

How to get the value from SysQueryForm's Criteria and Field fields

Hi all experts,

I have a customized form that called the SysQueryForm before initializing it to filter the result shown on the form. I have the following code,

void EInvoice_SysQueryForm()
{
SysQueryRun sysQueryRun = new SysQueryRun(ads_EInvoiceTable_ds.query());
if(!sysQueryRun.prompt())
{
element.close();
}

Query query = sysQueryRun.query();
QueryBuildDataSource qbds = query.dataSourceTable(tableNum(ads_EInvoiceTable));
QueryBuildRange range = SysQuery::findOrCreateRange(qbds, fieldNum(ads_EInvoiceTable, ads_SubmissionStatus));

if(!range.value())
{
range.value(SysQuery::value(ads_SubmissionStatus::Draft));
}
else
{
range.value(SysQuery::value(ads_SubmissionStatus::Submitted));
}

ads_EInvoiceTable_ds.query(query);
ads_EInvoiceTable_ds.queryRun();
}

public void init()
{
super();
_contract=element.args().parmObject() as ADS_MYeInvoiceDataContractWS;

if (_contract==null)
{
element.EInvoice_SysQueryForm();
}
else
{
_parmFromDate = _contract.parmFromDate();
_parmToDate = _contract.parmToDate();
_status=_contract.parmStatus();

qbr=ads_EInvoiceTable_ds.queryBuildDataSource().addRange(fieldNum(ads_EInvoiceTable,ads_SubmissionStatus));
qbr.value(queryValue(_status));

//qbr1=CustInvoiceJour_ds.queryBuildDataSource().addRange(fieldNum(CustInvoiceJour,InvoiceDate));
//qbr1.value(SysQuery::range(_parmFromDate,_parmToDate));

qbr1=ads_EInvoiceTable_ds.queryBuildDataSource().addRange(fieldNum(ads_EInvoiceTable,ads_InvoiceDate));
qbr1.value(SysQuery::range(_parmFromDate,_parmToDate));

ads_EInvoiceTable_ds.executeQuery();
//CustInvoiceJour_ds.executeQuery();
}

}

I would like to do if I have other value on the SysQueryForm, for example, /Submitted/, then the form will showed the /Submitted/ records, not a blank form.