hi help me

Finance and Operations/AX Developer Forum
1

hi anyone pls teach me how to write a code for look up method…

2

Hi,

The sample code for lookup is as follows

void lookupAdapterNames(FormControl control)

{

Query query = new Query();

QueryBuildDataSource queryBuildDataSource;

QueryBuildRange queryBuildRange;

SysTableLookup sysTableLookup;

;

//Create an instance of SysTableLookup with the form control passed in

sysTableLookup = SysTableLookup::newParameters(tablenum(AifAdapter), control);

//Add the fields to be shown in the lookup form

sysTableLookup.addLookupfield(fieldnum(AifAdapter, Name), true);

sysTableLookup.addLookupfield(fieldnum(AifAdapter, Type), false);

//create the query datasource

queryBuildDataSource = query.addDataSource(tablenum(AifAdapter));

queryBuildRange = queryBuildDataSource.addRange(fieldnum(AifAdapter, Enabled));

queryBuildRange.value(enum2str(NoYes::Yes));

//add the query to the lookup form

sysTableLookup.parmQuery(query);

// Perform lookup

sysTableLookup.performFormLookup();

}

Call the above method in the lookup()

3

hi, recently i wrote a lookup and it is working fine. i hope it may be helps you…

public void lookup()
{

SysTableLookup sysTableLookup = SysTableLookup::newParameters(tablenum(smmBusRelSubSegmentGroup),this);
Query query = new Query();
QueryBuildDataSource queryBuildDataSource;
QueryBuildRange qbr;

;

sysTableLookup.addLookupfield(fieldnum(smmBusRelSubSegmentGroup, SubSegmentId), true);
sysTableLookup.addLookupfield(fieldnum(smmBusRelSubSegmentGroup, SegmentId));
sysTableLookup.addLookupfield(fieldnum(smmBusRelSubSegmentGroup, SubSegmentDescription));

query.dataSourceTable(tablenum(smmBusRelSubSegmentGroup));

queryBuildDataSource = query.addDataSource(tablenum(smmBusRelSubSegmentGroup));

qbr = queryBuildDataSource.addRange(fieldnum(smmBusRelSubSegmentGroup, SegmentId));

qbr.value(queryvalue( Te_BankGuarantee.SegmentId));

sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
}

4

thanx all…its working