Add Prompt window to form for grid filtering in Ax 2009

QueryPrompt

public class FormRun extends ObjectRun
{
QueryRun queryRun;
QueryBuildRange range;

}

public void init()
{
super();

range = SysQuery::findOrCreateRange(this.query().dataSourceTable(tablenum(Bill_Table)), fieldnum(Bill_Table, ItemName));
range = SysQuery::findOrCreateRange(this.query().dataSourceTable(tablenum(Bill_Table)), fieldnum(Bill_Table, CustName));
queryRun = new QueryRun(Bill_Table_ds.query());

if (queryRun.prompt())
{

Bill_Table_ds.query(queryRun.query());
Bill_Table_ds.executeQuery();
}

}

Prompt window                                Before After

prompt         b4after

Advertisements

Simple filter on form grid in Ax 2009

simplefilter

CODE

public boolean modified()
{
boolean ret;

ret = super();

JumpRefTest_ds.filter(fieldnum(JumpRefTest,AccountNum),StringEdit.valueStr());

return ret;
}