Finance | Project Operations, Human Resources, ...

List all the data sources under the customized forms (AX 201) using query

(0) Share

Report

Posted on by Community Member

Hello Every One,

I have requirement to pull all the data sources of forms which are customized. I was able to pull the customized info like table fields and other info.

Kindly help me as quick as possible .

Thanks in advance,

Phani

I have the same question (0)

All responses (14)

Answers (0)

Danial47 142 on at

Like (0)

Report

Hi Phani

For that, you can use outerjoin in query of form to pull all data.

Afterwards, it is possible to write new class to insert them into temp table.

BR.

Danial

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Danial,

select *

FROM [dbo].ModelElementData a join
[dbo].[ModelElement]b on a.ElementHandle = b.ElementHandle join
[dbo].[Elementtypes]d on d.ElementType = b.ElementType

where a.LayerId != (select id from Layer where name = 'SYS')

I have been using the above query to take all the customization done into user level. And can you suggest me, how can I pull form data sources? . I have been using model store tables to pull info.

Thanks,

Phani

Was this reply helpful? Yes No
WillWU 22,361 on at

Like (1)

Report

Hi Phani Ax2012,

This requirement sounds strange, and what business problem are you trying to solve by this solution?

You could see the blog to find modified objects from current layer:

community.dynamics.com/.../list-all-modified-objects-from-current-layer

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Will ,

Thanks for your reply. I have requirement like migrating from Ax2012 to D365FO. So i need the all the objects modified in usr layer and moreover i am not able get delete actions under tables.

Kindly help me.

Thanks,

Phani

Was this reply helpful? Yes No
Martin Dráb 237,959 Most Valuable Professional on at

Like (0)

Report

Why don't you follow the standard upgrade process? You seem to be making everything much more complicated for yourself.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Martin,

First i would like to visualize the objects in UI that are customized . So i need them

Thanks,

Phani

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

I think you will get this info directly from the upgrade analysis report that LCS code upgrade tool creates for you.

If you don't want to use this tool that exists for the very purpose of analyzing your code before upgrade, then please consider following approach.

A quick - even though manual - process could be creating a project from model (Tools - Model management - Create project from model).

Then go through all Microsoft forms on this project. Let's imagine you have customized 20 forms in the standard system.

Then compare those 20 forms with the compare tool (USR vs SYP/SYS) and check if there are changes on data source level.

Of course if you have customized hundreds of forms this is not feasible. But otherwise it should take 5-30 minutes to get the list. Since it's a one time requirement for this upgrade project, I think this kind of manual approach could be the cheapest solution.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Nikolaos,

Thanks for you reply on this.

I would like show what AOT objects are customized in USR layer. I know we can compare between layers but how can i export that difference output to xpo or csv file. And more over delete actions under table are not getting listed which are customized.

Kindly help to get out this problem

Thanks,

Phani

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

When you create the compare project, you can export it by right click -> Export. In the export dialog, click the "Application object layer" to export only the USR layer elements.

I assume you have checked the code upgrade tool in LCS. Was there some info missing from the resulting reports? Knowing what exact info you need could help us pinpoint you a solution.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Nikolaos,

I have created a compare project but it was listing existing fields too . I just want to export only customized fields or methods or delete actions under tables.

Thanks,

Phani

Was this reply helpful? Yes No