The code below is what I used in my lookup on a StringEdit control named “SONum”. I just want to get the value of the column name “ItemId” that I selected in the dropdown list and pass it in a variable so that I can used the variable in my where statement of SQL. Can you help me how to get the value I selected in “ItemId” column.
public void lookup()
{
SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(CustPackingSlipTrans), this);
QueryBuildDataSource qb;
Query q=new Query();
;
sysTableLookup.addLookupField(fieldNum(CustPackingSlipTrans, SalesId),true);
sysTableLookup.addLookupField(fieldNum(CustPackingSlipTrans, PackingSlipId));
sysTableLookup.addLookupField(fieldNum(CustPackingSlipTrans, DeliveryDate));
sysTableLookup.addLookupField(fieldNum(CustPackingSlipTrans, ItemId));
sysTableLookup.addLookupField(fieldNum(CustPackingSlipTrans, Name));
sysTableLookup.addLookupField(fieldNum(CustPackingSlipTrans, Qty));
sysTableLookup.addLookupField(fieldNum(CustPackingSlipTrans, SalesUnit));
sysTableLookup.addLookupField(fieldNum(CustPackingSlipTrans, SalesGroup));
sysTableLookup.addLookupField(fieldNum(CustPackingSlipTrans, createdDateTime));
qb = q.addDataSource(tableNum(CustPackingSlipTrans));
q.allowCrossCompany(true);
q.addCompanyRange(“A”);
q.addCompanyRange(“B”);
q.addCompanyRange(“C”);
q.addCompanyRange(“D”);
q.addCompanyRange(“E”);
q.addCompanyRange(“F”);
qb.addGroupByField(fieldnum(CustPackingSlipTrans,PackingSlipId));
qb.addGroupByField(fieldnum(CustPackingSlipTrans,SalesId));
qb.addGroupByField(fieldnum(CustPackingSlipTrans,DeliveryDate));
qb.addGroupByField(fieldnum(CustPackingSlipTrans,ItemId));
qb.addGroupByField(fieldnum(CustPackingSlipTrans,Name));
qb.addGroupByField(fieldnum(CustPackingSlipTrans,Qty));
qb.addGroupByField(fieldnum(CustPackingSlipTrans,SalesUnit));
qb.addGroupByField(fieldnum(CustPackingSlipTrans,SalesGroup));
qb.addGroupByField(fieldnum(CustPackingSlipTrans,createdDateTime));
qb.addOrderByField(fieldnum(CustPackingSlipTrans,DeliveryDate),1);
qb.addRange(fieldnum(CustPackingSlipTrans,DeliveryDate)).value(datetime2Str(CurrentDate.dateTimeValue()));
sysTableLookup.parmQuery(q);
sysTableLookup.performFormLookup();
}
Thanks,
Jeremy