14 September 2013

Display all AOT Table in lookup / get all table ids in lookup / List of table ids in lookup

static void lookupAOTTables(FormStringControl _ctrl)
{
SysTableLookup sysTableLookup = SysTableLookup::newParameters(tablenum(UtilidElements), _ctrl);
Query query = new Query();
QueryBuildDataSource queryBuildDataSource;
QueryBuildRange nameQBR, typeQBR;
;
sysTableLookup.addLookupfield(fieldnum(UtilidElements, Id));
sysTableLookup.addLookupfield(fieldnum(UtilidElements, Name));

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


//nameQBR = queryBuildDataSource.addRange(fieldnum(UtilidElements, name));
//nameQBR.value('Cust*');


typeQBR = queryBuildDataSource.addRange(fieldnum(UtilidElements, recordType));
typeQBR.value(SysQuery::value(UtilElementType::Table));


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

1 comment:

  1. How to get all tables from query when i select one query from drop down

    ReplyDelete

Give me the commetns and solutions

Ledger Voucher creation Framework and x++ code to create ledger voucher

 Please click her for MS reference file Below is the out of the box example reference and code. SalesInvoiceJournalPostSubBill_Extension-...