Finance | Project Operations, Human Resources, ...

How to get Form details through Sql query from model DB in AX 2012 R3.

(0) Share

Report

Posted on by Community Member

Hi everyone, anyone can guide me how to get complete details of a form from _model database through SQL or any other simple way e.g. form name, form caption, form module(e.g Accounts payable).

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

ergun sahin 8,826 Moderator on at

Like (0)

Report
Copy link

Link copied!

Here we have a new API

dev.goshoom.net/.../

and we have old one

docs.microsoft.com/.../performing-reflection-with-the-treenode-class

and lastly you can use powershell

dynamicsuser.net/.../simple-metadata-query-in-powershell-d365fo-1195876320

Edit: Only second method work for ax 2012 (and of course we have other methods for 2012). For a second I think I was at d365 forum. I didn't want to delete it even after I realized I was on the ax 2012 forum.

Was this reply helpful? Yes No
Suggested answer

ergun sahin 8,826 Moderator on at

Like (0)

Report
Copy link

Link copied!

Here a second method. You will not get values from form but from menuItem

stackoverflow.com/.../how-can-i-get-access-path-of-form-in-ax2012

Was this reply helpful? Yes No
Harshal Nayak Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello M.Usman,

you can also check docs.microsoft.com/.../how-to-access-the-active-query-on-forms

Was this reply helpful? Yes No