Biasanya kalo lookup table, kita bisa langsung menggunakan EDT, tapi bagaimana kalo yang mau di- lookup hanya data di table dengan kriteria tertentu saja. Untuk bisa melakukannya, kita bisa menggunakan script X++ di bawah ini :
{
Query query = new Query();
QueryBuildDataSource queryBuildDataSource;
QueryBuildRange queryBuildRange;
// Create an instance of SysTableLookup where 'this'
// is the current form control.
SysTableLookup sysTableLookup =
SysTableLookup::newParameters(tableNum(emplTable), this);
;
// Add fields to be shown in the lookup form.
sysTableLookup.addLookupField(fieldNum(emplTable, emplId));
//sysTableLookup.addLookupField(fieldNum(emplTable, Del_Name));
// Limit and arrange the data selection.
queryBuildDataSource = query.addDataSource(tableNum(emplTable));
queryBuildRange = queryBuildDataSource.addRange(
fieldNum(emplTable, Dimension));
queryBuildRange.value('070');
sysTableLookup.parmQuery(query);
// Perform the lookup.
sysTableLookup.performFormLookup();
//Don't call super() (commented out in the code).
// super()
}


