Lookup of FieldName

Finance and Operations/AX Technical Forum
1

i am looking to get a lookup of the fieldnames in a form.The lookup should contain the fieldnames of the Form datasource that it is called from.

For eg : if on purchTable form , it shoud show a lookup of the fields from PurchTable.

Any Help is aprreciated

Thanks

2

Hi,

try this,

public void lookup()
{
Query query = new Query();
QueryBuildDataSource qbds;
QueryBuildRange queryBuildRange;
SysTableLookup sysTableLookup;

;

sysTableLookup = SysTableLookup::newParameters(tablenum(tablename), this);
sysTableLookup.addLookupfield(fieldnum(tablename, BranchName));

sysTableLookup.addLookupfield(fieldnum(tablename, BranchCode));

sysTableLookup.addLookupfield(fieldnum(tablename, RegionCode));

qbds = query.addDataSource(tablenum(tablename));
QueryBuildRange = qbds.addRange(fieldnum(tablename,RegionCode));
QueryBuildRange.value(RegionCode.valueStr()); // Make the auto declaration yes for that control and do it.
if(sysTableLookup)
{
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
}

}

3

Looking for a Lookup of “FieldNames” of a Table, i.e. listing all the fields available in the table.

4

Use SysTableFieldLookup class. Pass the form query to the constructor, save TableId to TmpSysTableField table (DictTableId field) and pass it to performLookupField().

5

static void Job1(Args _args)

{

int tableID;

str fieldName;

int fieldId;

tableID=global::tableName2Id(“PaymDay”);

fieldId=global::pickField(tableID);

fieldName=fieldid2name(tableID,fieldId);

info(fieldName);

}

6

I was looking for the same thing and this is what I got so far.

If you want the code just tell me this is what you are looking for.

2072.Sans titre.png
2072.Sans titre.png711×378 12.5 KB

7

simple code

at classDeclaration
SysTableFieldLookup tableFieldLookup; // function for lookup field
TmpSysTableField tmpSysTableField; // to catch selected lookup value

at lookup method:
Query query = new Query();
;
query.addDataSource(tableNum(SalesLine));
tableFieldLookup = new SysTableFieldLookup(query);
tmpSysTableField.DictTableId = tableNum(SalesLine);
tableFieldLookup.performLookupField(this, tmpSysTableField); // lookup display label description

at modified method after super
FieldId fieldIdNum;
fieldIdNum = tableFieldLookup.parmSelectedRecord().FieldId; // get the field id