Share
ReportI want to override my itemId lookup and have only items that contain /a/ alphabet in string of itemGroupId. please suggest any solution for this.
You’re offline. This is a read only version of the page.
51
All responses (
Answers (
Query query = new Query();
QueryBuildDataSource queryBuildDataSource;
SysTableLookup sysTableLookup = sysTableLookup::newParameters(tableNum(InventTable), this);
;
sysTableLookup.addLookupfield(fieldNum(InventTable, ItemId));
sysTableLookup.addLookupfield(fieldNum(InventTable, itemGroupId));
queryBuildDataSource = query.addDataSource(tableNum(InventTable));
queryBuildDataSource.addRange(fieldNum(InventTable, itemGroupId))
.value(SysQuery::valueLike('a'));
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156