Open a query window before opening form using X++ in D365FO

Question

Accepted Answer

We need to override the run method of the form. 


public void run()
{
Query query;
QueryRun queryRun;

    query   = new Query();
    query.addDataSource(tableNum(ItemMasterView));
 
    query.dataSourceTable(tableNum(ItemMasterView)).addRange(fieldNum(ItemMasterView, ItemId));
    query.dataSourceTable(tableNum(ItemMasterView)).addRange(fieldNum(ItemMasterView, itemBarCode));
    query.dataSourceTable(tableNum(ItemMasterView)).addRange(fieldNum(ItemMasterView, InventLocationId));
 
    queryRun = new QueryRun(query);
 
    if (queryRun.prompt())
    {
 
        super();
 
        ItemMasterView_ds.query(queryRun.query());
        ItemMasterView_ds.executeQuery();
    }
}



 Figure: 1 Open a query window before opening form using X++ in D365FO 

 Figure: 2 Open a query window before opening form using X++ in D365FO

Open a query window before opening form using X++ in D365FO

Answer with Explanation