1. Create 3 fields
for the table “FormTable” and add to form datasource.
2. First field with
relation in table level so automatically you will get the look up.
·
As FormTable.Fild1
3. Second field
with following lookup code, this look up filter with previous field.
·
As FormTable.Fild2
Public void lookup ()
{
Query query = new Query();
QueryBuildDataSource queryBuildDataSource;
QueryBuildRange queryBuildRange;
QueryBuildRange queryBuildRange1;
SysTableLookup sysTableLookup;
HRCCompGrid HRCCompGrid;
;
//Create
an instance of SysTableLookup with the form control passed in
sysTableLookup =
SysTableLookup::newParameters(tablenum(HRCCompRefPointSetupLine),
this);
//Add
the fields to be shown in the lookup form
sysTableLookup.addLookupfield(fieldnum(HRCCompRefPointSetupLine,
RefPointId));
sysTableLookup.addLookupfield(fieldnum(HRCCompRefPointSetupLine,
RefPointSetupId));
//create
the query datasource
queryBuildDataSource =
query.addDataSource(tablenum(HRCCompRefPointSetupLine));
//Only
show LocalEndpoints for the current company
queryBuildRange =
queryBuildDataSource.addRange(fieldnum(HRCCompRefPointSetupLine,
RefPointSetupId));
select
HRCCompGrid where HRCCompGrid.GridId
==SalaryAmend.GridId ;
//SalaryAmend.GridId is the FormTable.Fild1
queryBuildRange.value(HRCCompGrid.RefPointSetupId);
//this select query makes the queryBuildRange values from another table
for the datasource of another table
//Assign
the query to the lookup form
sysTableLookup.parmQuery(query);
//
Perform lookup
sysTableLookup.performFormLookup();
//
Don't call super()
//super()
}
4. Third field given a lookup with filtering on
based of above 2 fields.
·
As FormTable.Fild3
public void lookup()
{
Query query = new Query();
QueryBuildDataSource
queryBuildDataSource,qbds;
QueryBuildRange qbr1,qbr2;
SysTableLookup
sysTableLookup = SysTableLookup::newParameters(tableNum(HcmCompensationLevel),
this);
sysTableLookup.addLookupfield(fieldnum(HcmCompensationLevel,
CompensationLevelId));
sysTableLookup.addLookupfield(fieldnum(HRCComp,
RefPointId));
sysTableLookup.addLookupfield(fieldnum(HRCComp,
GridId));
queryBuildDataSource =
query.addDataSource(tableNum(HcmCompensationLevel));
qbds =
queryBuildDataSource.addDataSource(tableNum(HRCComp));
qbds.joinMode(JoinMode::ExistsJoin);
qbds.relations(true);
qbr1 = qbds.addRange(fieldNum(HRCComp,GridId));
qbr2 = qbds.addRange(fieldNum(HRCComp,RefPointId));
qbr1.value(SalaryAmend.GridId);
qbr2.value(SalaryAmend.RefPointId);
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
//super();HcmCompensationLevel
}
