Hello Everyone,
I have a lookup method,
In this method I use group by and some range.
There are three lookup that works like hierarchical
When I first record entry it works well, but when I back to previos lookups on the grid it show the not groupped by version. And it is not acceptable for me.
I have written the same lookup code to modified and gotFocus methods but again It does not work.
How can I fix this?
Thanks
Erdem
Hi Erdem,
Can you share the code you have written for getting the lookup of the records.
public void lookup(FormControl _formControl, str _filterStr)
{
Query query = new Query();
QueryBuildDataSource queryBuildDataSource;
QueryBuildRange queryBuildRange;
SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(Int_smmLayer1), _formControl);
;
sysTableLookup.addLookupField(fieldNum(Int_smmLayer1, Layer1Id));
sysTableLookup.addLookupField(fieldNum(Int_smmLayer1, Description));
queryBuildDataSource = query.addDataSource(tableNum(Int_smmLayer1));
queryBuildDataSource.addGroupByField(fieldnum(Int_smmLayer1, Layer1Id));
queryBuildRange = queryBuildDataSource.addRange(fieldNum(Int_smmLayer1, CaseTypeId));
queryBuildRange.value(Int_smmCaseTrans.CaseTypeId);
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
}
Try
;
sysTableLookup.parmUseLookupValue(false);
Thank you so much Volodymyr
Best Regards
Erdem