Skip to main content

Posts

Showing posts with the label lookups

Expression Builder Lookup using X++

I was just wondering if there is any way of popping a lookup form during the program execution. We have seen many ways of creating lookups – EDT’s, relations, AutoLookup and through custom code [SysTableLookup] Let us consider an example: I have a select query whose behaviour should be dynamic based on the User input. We might have used query Framework classes many a times to do this. I was just going through the standard classes and found this code useful with minimum tweaking of code. Try out the below example: This example will help you to select the custAccount and based on the selected customer account it brings you the last invoiced sales order. Note: The columns in the form are built runtime using the AutoLookup fields. static void SR_expressionBuilderLookUp(Args _args) { CustTable custTable; ExtendedDataTypeName extendedDataType = extendedtypestr(custAccount); CustAccount custAccount; Object expressionBuilderLookup; Args args = new Args(forms...

Dialog formunda lookup metodu

void Fld1_1_Lookup() { SysTableLookup sysTableLookup; Query query = new Query(); QueryBuildDataSource qbds; ; control = dialog.formRun().controlCallingMethod(); sysTableLookup =SysTableLookup::newParameters(tableNum(LedgerJournalTrans), control); sysTableLookup.addLookupfield(fieldNum(LedgerJournalTrans, RecId)); sysTableLookup.addLookupfield(fieldNum(LedgerJournalTrans, JournalNum)); sysTableLookup.addLookupfield(fieldNum(LedgerJournalTrans, AccountType)); sysTableLookup.addLookupfield(fieldNum(LedgerJournalTrans, AccountNum)); sysTableLookup.addLookupfield(fieldNum(LedgerJournalTrans, txt)); qbds = query.addDataSource(tableNum(LedgerJournalTrans)); //isterseniz range ekleyebilirsiniz //qbds.addRange(fieldNum(LedgerJournalTrans,TransDate)).value(queryValue(dialogTransDate.value())); sysTableLookup.parmQuery(query); sysTableLookup.performFormLookup(); }

Create LookUps Using X++

public void lookup() { //super(); // Added by Vasanth Arivali // Declaration Query LookupQuery = new Query(); QueryBuildDataSource LookupQueryBuildDataSource; QueryBuildRange LookupQueryBuildRange; SysTableLookup CustomSysTableLookup = SysTableLookup::newParameters(tableNum(InventTable), this); ; // Add fields that you want in Lookups CustomSysTableLookup.addLookupField(fieldNum(InventTable, ItemId)); CustomSysTableLookup.addLookupField(fieldNum(InventTable,ItemName)); CustomSysTableLookup.addLookupField(fieldNum(InventTable,ItemGroupId)); CustomSysTableLookup.addLookupField(fieldNum(InventTable,NameAlias)); CustomSysTableLookup.addLookupField(fieldNum(InventTable,ItemType)); CustomSysTableLookup.addLookupField(fieldNum(InventTable,DimGroupId)); // Add DataSource, Range and Value LookupQueryBuildDataSource =LookupQuery.addDataSource(tableNum(InventTable)); LookupQueryBuildRange=LookupQueryBuildDataSource.addRange(fieldNum(InventTable,ItemVisibili...

Create LookUps Using X++

Lookups using X++ Code(without Ax Table or EDT relation). For that i override a String(Text) Control’ s lookup method. public void lookup() { //super(); // Added by Vasanth Arivali // Declaration Query LookupQuery = new Query(); QueryBuildDataSource LookupQueryBuildDataSource; QueryBuildRange LookupQueryBuildRange; SysTableLookup CustomSysTableLookup = SysTableLookup::newParameters(tableNum(InventTable), this); ; // Add fields that you want in Lookups CustomSysTableLookup.addLookupField(fieldNum(InventTable, ItemId)); CustomSysTableLookup.addLookupField(fieldNum(InventTable,ItemName)); CustomSysTableLookup.addLookupField(fieldNum(InventTable,ItemGroupId)); CustomSysTableLookup.addLookupField(fieldNum(InventTable,ItemType)); // Add DataSource, Range and Value LookupQueryBuildDataSource = LookupQuery.addDataSource(tableNum(InventTable)); LookupQueryBuildRange= LookupQueryBuildDataSource.addRange(fieldNum(InventTable,ItemVisibility)); LookupQueryBuildRan...