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

24.05.2018
Disclaimer
08.05.2018
We apply OKR methodology in Neti since 2014. We started from a quarterly planning, but then understood that no ambitious goals can be achieved per quarter. So we switched to semi-annual intervals....
11.04.2018
As you know, Microsoft recently has launched Dynamics 365 Business Central. And we are proud to announce we have launched intracompany training for sales and development departments:Why do we need it...

Subscribe for blog updates

Get updated with our blog new articles via your email!


Subscribe now