Dynamics AX 2012 introduces built-in support for resolving and looking up linked records based on reference record IDs.<\/p>\n
When adding a reference record ID field to a form, AX will add a reference group control instead of the reference record ID, and will show a selected set of fields from the referenced table. \u00a0See the posts about tree lookups<\/a> for an example.<\/p>\n The reference group control also does lookups into the referenced table for selecting a new value. \u00a0However, by default this lookup is not filtered and will show all records in the referenced table. \u00a0Adding filtering is quite easy to do and it follows a similar pattern as regular table lookups.<\/p>\n <\/p>\n To add a custom lookup, you’ll need to override the lookupReference() method on the reference group control, not lookup() which is used for regular lookups.<\/p>\n lookupReference() is different in that it returns a record buffer, which will be used to populate the individual fields in the reference group. \u00a0Good, so we just need to return a record buffer, but how to select one from a filtered list? \u00a0That’s where the SysReferenceTableLookup class comes into play.<\/p>\n This class provides an API which is almost identical to SysTableLookup, so if you are used to that class, this should all look and feel quite similar.<\/p>\n We create a SysReferenceTableLookup object and point it to the table we want to reference. \u00a0(Replace ReferencedTable, OtherTable and their field names with the relevant table and field names from your application)<\/p>\n Next, we create a query object and add a data source for the same table. \u00a0(You could of course create a query object from an AOT query, as well)<\/p>\n We add one or more ranges to restrict the rows that will be shown in the lookup.<\/p>\n We tell the lookup object which query to use and which field(s) to show.<\/p>\n And finally, we call performFormLookup() to show the actual lookup. \u00a0In SysReferenceTableLookup this method returns a record buffer, which we pass to the return statement.<\/p>\n The full method would look like this:<\/p>\n Dynamics AX 2012 introduces built-in support for resolving and looking up linked records based on reference record IDs. When adding a reference record ID field to a form, AX will add a reference group control instead of the reference record ID, and will show a selected set of fields from the referenced table. \u00a0See the … Continue reading “Filtered form reference group lookup”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,1],"tags":[2,3,5],"class_list":["post-374","post","type-post","status-publish","format-standard","hentry","category-dynamics-ax","category-uncategorized","tag-ax2012r3","tag-dynamics-ax","tag-user-interface"],"_links":{"self":[{"href":"https:\/\/www.bakke.online\/index.php\/wp-json\/wp\/v2\/posts\/374","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bakke.online\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bakke.online\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bakke.online\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bakke.online\/index.php\/wp-json\/wp\/v2\/comments?post=374"}],"version-history":[{"count":1,"href":"https:\/\/www.bakke.online\/index.php\/wp-json\/wp\/v2\/posts\/374\/revisions"}],"predecessor-version":[{"id":1332,"href":"https:\/\/www.bakke.online\/index.php\/wp-json\/wp\/v2\/posts\/374\/revisions\/1332"}],"wp:attachment":[{"href":"https:\/\/www.bakke.online\/index.php\/wp-json\/wp\/v2\/media?parent=374"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bakke.online\/index.php\/wp-json\/wp\/v2\/categories?post=374"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bakke.online\/index.php\/wp-json\/wp\/v2\/tags?post=374"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}The lookupReference() method<\/h3>\n
public<\/strong> <\/span>Common lookupReference(FormReferenceControl _formReferenceControl)\n{<\/pre>\nThe SysReferenceTableLookup class<\/h3>\n
SysReferenceTableLookup lookup = SysReferenceTableLookup::newParameters( tableNum<\/strong><\/span>( ReferencedTable ), _formReferenceControl );<\/pre>\nQuery q = new<\/strong> <\/span>Query();\nQueryBuildDataSource qbds = q.addDataSource( tableNum<\/strong><\/span>( ReferencedTable) );<\/pre>\nqbds.addRange( fieldnum<\/strong><\/span>( ReferencedTable, FieldToFilterOn ) ).value( queryValue( OtherTable.FilterValueField ) );<\/pre>\nlookup.parmQuery( q );\nlookup.addLookupfield( fieldNum<\/strong><\/span>( ReferencedTable, ID ) );\nlookup.addLookupfield( fieldNum<\/strong><\/span>( ReferencedTable, Description ) );<\/pre>\n return<\/strong> <\/span>lookup.performFormLookup();\n}<\/pre>\npublic<\/strong> <\/span>Common lookupReference(FormReferenceControl _formReferenceControl)\n{\n SysReferenceTableLookup lookup = SysReferenceTableLookup::newParameters( tableNum<\/strong><\/span>( ReferencedTable ), _formReferenceControl );\n Query q = new<\/strong> <\/span>Query();\n QueryBuildDataSource qbds = q.addDataSource( tableNum<\/strong><\/span>( ReferencedTable) );\n\n qbds.addRange( fieldnum<\/strong><\/span>( ReferencedTable, FieldToFilterOn ) ).value( queryValue( OtherTable.FilterValueField ) );\n\n lookup.parmQuery( q );\n lookup.addLookupfield( fieldNum<\/strong><\/span>( ReferencedTable, ID ) );\n lookup.addLookupfield( fieldNum<\/strong><\/span>( ReferencedTable, Description ) );\n\n return<\/strong> <\/span>lookup.performFormLookup();\n}<\/pre>\n","protected":false},"excerpt":{"rendered":"