New relations don't appear in the standard Dynamics AX Query Designer (reports, advanced filters)

Updated: 29.08.2014

After creation of new relations in the tables, it happens that these new relations don't appear in the standard Query Designer (reports, advanced filters). Even recompiling and rebuilding cross-references don't help.

To solve this problem you can use this Job:

static void Neti_UpdateRelation(Args _args)

{

xRefTableRelation::updateTableId(DictTable::construct(tableStr(Neti_XML_objectAttr)).id()); xRefTableRelation::updateTableId(DictTable::construct(tableStr(Neti_XML_objectFilterKey)).id()); xRefTableRelation::updateTableId(DictTable::construct(tableStr(Neti_XML_objectTab)).id()); xRefTableRelation::updateTableId(DictTable::construct(tableStr(Neti_XML_objectTabAttr)).id()); xRefTableRelation::updateTableId(DictTable::construct(tableStr(Neti_XML_object)).id());

// Instead of Neti_XML_ .. you need to specify necessary tables.

}

You can use this job just after creating relations in the tables. You don't need to rebuild cross-references etc.

 

Other blog posts

11.01.2018
How small business shall work with major contracts. Opinion of Ruslan Kafiatullin from Neti Projects from scratch are always riskyAs a rule, implementation projects from scratch are always...
14.11.2017
Why outsourcing company is more effective than In-house IT-specialists There are situations when in-house specialists spend most of their time awaiting requests or they cannot get their work...
26.09.2017
Microsoft Dynamics AX program decisions are constantly improving. At first, innovations come to European companies, and only after that to Russian enterprises.We aspire to be one step ahead in this...

Subscribe for blog updates

Get updated with our blog new articles via your email!


Subscribe now