how I can make filter in dialog ?

Finance and Operations/AX Developer Forum
1

hi

I have dialog in this dialog I make combobox user can choose record in this combobox but if they have 3000 record or more user make time to seach the record manually than I would like make search in dialog for this combobox ?

how I can do this ?

thank you

2

try overriding the lookup method for the combo box

public void lookup()

{

SysTableLookup sysTableLookup;

Query query;

QueryBuildDataSource queryBuildDataSource;

QueryBuildRange queryBuildRange;

;

query = new Query();

queryBuildDataSource = query.addDataSource(tableNum(YourTable));

// set the range etc

sysTableLookup = SysTableLookup::newParameters(tableNum(SalesTable), this);

sysTableLookup.addLookupfield(fieldNum(YourTable, Field1));

sysTableLookup.addLookupfield(fieldNum(YourTable, Field2));

sysTableLookup.parmQuery(query);

sysTableLookup.performFormLookup();

}

-abid

3

hi

I knonw that but this is a lookup in this lookup how I can make search ?

thank you

4

you mean “Find”?

-abid

5

hi

yes find in the lookup

thank you

6

this the override code for lookup method and it allows me to do the “find” function

#public void lookup()

#{

SysTableLookup sysTableLookup;

Query query;

QueryBuildDataSource queryBuildDataSource;

QueryBuildDataSource queryBuildDataSourceSalesLine;

QueryBuildRange OpenSalesRange;

;

query = new Query();

queryBuildDataSource = query.addDataSource(tableNum(SalesTable));

sysTableLookup = SysTableLookup::newParameters(tableNum(SalesTable), this);

#// AMahmood 20 April 2011 - HT_225_ProjPMStatusInquiryProductLin - BEGIN

if(dimProductLine)

{

queryBuildDataSourceSalesLine = queryBuildDataSource.addDataSource(tablenum(SalesLine));

queryBuildDataSourceSalesLine.joinMode(joinmode::ExistsJoin);

queryBuildDataSourceSalesLine.relations(true);

queryBuildDataSourceSalesLine.addRange(fieldid2ext(fieldnum(SalesLine, Dimension),2)).value(dimProductLine.text());

}

#// AMahmood 20 April 2011 - HT_225_ProjPMStatusInquiryProductLin - END

#// AMahmood 25 April 2011 - HT_225_ProjPMStatusInquiryProductLin - BEGIN

OpenSalesRange = queryBuildDataSource.addRange(fieldnum(SalesTable, SalesStatus));

OpenSalesRange.value(queryValue(SalesStatus::Backorder));

#// AMahmood 25 April 2011 - HT_225_ProjPMStatusInquiryProductLin - END

sysTableLookup.addLookupfield(fieldNum(SalesTable, SalesId));

sysTableLookup.addLookupfield(fieldNum(SalesTable, ProjId));

sysTableLookup.addLookupfield(fieldNum(SalesTable, SalesName));

sysTableLookup.addLookupfield(fieldNum(SalesTable, CustAccount));

sysTableLookup.parmQuery(query);

sysTableLookup.performFormLookup();

7

thank you