Share
Report
65Hi,
Is there a solution to have custom sort order in sysTableLookup if I want to set parmUseLookupValue(true)? It looks like query sorting is ignored in that case... If I set sysTableLookup.parmUseLookupValue(false) sorting works fine.
public void lookup()
{
Query query = new Query();
QueryBuildDataSource queryBuildDataSource;
SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(), this);
sysTableLookup.addLookupfield(fieldNum(Table1, DescriptionField), true);
sysTableLookup.addLookupfield(fieldNum(Table1, SortOrderField));
queryBuildDataSource = query.addDataSource(tableNum(Table1));
queryBuildDataSource.addSortField(fieldNum(Table1, SortOrderField), SortOrder::Ascending);
sysTableLookup.parmQuery(query);
sysTableLookup.parmUseLookupValue(true); //same as SysTableLookup::newParameters(tableNum(), this, true)
sysTableLookup.performFormLookup();
} 
All responses (
Answers (
