LOOKUP FILTERS

Hello Pioneers,

I need to show the production Id in lookup in InventTransTable form, whose ProdStatus is : “CostEstimated”.

Please Guide me

Hi,

This might help you.

public void lookup(FormControl _formControl, str _filterStr)

{

Query query = new Query();

QueryBuildDataSource queryDataSourceCode;

QueryBuildRange queryBuildRange;

SysTableLookup sysTableLookup;

;

sysTableLookup=SysTableLookup::newParameters(tableNum(prodtable),_formControl);

sysTableLookup.addLookupField(fieldNum(prodtable, prodid));

queryDataSourceCode = query.addDataSource(tableNum(prodtable));

queryBuildRange = queryDataSourceCode.addRange(fieldNum(prodtable, prodstatus));

queryBuildRange.value(enum2str(prodstatus::costestimated));

sysTableLookup.parmQuery(query);

sysTableLookup.performFormLookup();

}

writ this in the inventtrans datasource prod id field lookup() method in inventtrans form…

Dear Chaitanya sir,

I am getting an error message "an overloaded function has an incorrect number of parameters "

Hi,

where you are writing this code…

and which line you are facing the error in the code…

Problem Resolved Sir…Thanks A Ton !!!