Finance | Project Operations, Human Resources, ...

sql query/x++ code to list out the metadata properties of table fields like the name, Label, mandatory, editable.........

(0) Share

Report

Posted on by SKO

385

Hello

Is there a way we can read the metadata properties of table fields like the name, Label, mandatory, editable....etc of a specific table as a parameter?

Thanks

Srikanth

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Satish Panwar 14,671 Moderator on at

Like (0)

Report

Hi Srikanth,

Please try like mentioned in link below:

community.dynamics.com/.../read-properties-of-table-fields-using-x-code

Was this reply helpful? Yes No
MATTGUO 22,349 Moderator on at

Like (0)

Report

Hi Srikanth,

Please refer to the following link and you can ergodic properties of the fields:

www.fatihdemirci.net/.../.

And if you want to set the properties of the field, TreeNode.AOSsetProperty() is what you need:

#Properties

TreeNode fieldNode = TreeNode::findNode(@"\Data Dictionary\Tables\Address\Fields\Name");

fieldNode.AOTsetProperty(#PropertyMandatory, enum2str(NoYes::Yes));

Was this reply helpful? Yes No
André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

Hi Srikanth,

Both replies above contains good examples. As you posted the question in the Dynamics 365 for Finance forum, I want to make one correction on the reply from MattGuo. In Microsoft Dynamics 365, the AOTsetProperty() and other AOT...() methods are not working anymore. This is because there is a split between the client and development environment.

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

I would use the new metadata API instead of the old ways.

Was this reply helpful? Yes No