Finance | Project Operations, Human Resources, ...

how to get field Name from fieldNum?

(0) Share

Report

Posted on by BASMA

932

Hello,

I have this tabel that contains TableNum and fienNum :

I want to get the field Name But I don't which table that contains the fieldId and the fieldName

Have you any idea how to get the field name?

Thanks

I have the same question (0)

All responses (25)

Answers (0)

Suggested answer

Mohit Rampal 12,565 Moderator on at

Like (0)

Report

Hi, You can use global function FieldId2Name. Please check this article

yasirnedian.blogspot.com/

Was this reply helpful? Yes No
Suggested answer

Abhi 120 on at

Like (0)

Report

Hi BASMA,

can you check the SQLDICTIONARY table, TABLEFIELDIDTABLE table and TABLEIDTABLE table in SSMS.

Thanks,

Was this reply helpful? Yes No
Suggested answer

GirishS 27,827 Moderator on at

Like (0)

Report

Hi Basma,

In addition to the above suggestions, you can check the below blog also.

https://d365technext.blogspot.com/2018/07/get-field-label-type-and-name-using-x.html

Thanks,

Girish S.

Was this reply helpful? Yes No
BASMA 932 on at

Like (0)

Report

thanks for reply ,

I find the tableNum but the fieldNum isn't the same in the 2 tables how can I add the relation :

select * from SQLDICTIONARY where SQLDICTIONARY.TABLEID='8246'

Was this reply helpful? Yes No
BASMA 932 on at

Like (0)

Report

the problem is I haven't the name of field to use FieldId2Name

I have only the fieldLabel fieldNume and the name of table

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (0)

Report

Dont compare FieldId with FieldNum in your table. Use Name and SQLName field as relation and check.

I mean YourTableName.FieldLabel == SqlDictionary.Name.

Thanks,

Girish S.

Was this reply helpful? Yes No
BASMA 932 on at

Like (0)

Report

it doesn't the same : fieldLabel and Name

Was this reply helpful? Yes No
Mohit Rampal 12,565 Moderator on at

Like (0)

Report

May I know how you are populating data in your custom table.

Also regarding this your below comment, I think you don't need Name field as you already have tableId and fieldNum. You can try creating a Display method for 'Name' in your custom table instea dof field.

'the problem is I haven't the name of field to use FieldId2Name

I have only the fieldLabel fieldNume and the name of table'

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (0)

Report

In that case you need to use DictTable class to get the table related details.

https://community.dynamics.com/365/financeandoperations/b/dynamicsofax/posts/read-properties-of-table-fields-using-x-code

Other option will be inserting the field name instead of field label in your custom table.

Thanks,

Girish S.

Was this reply helpful? Yes No
BASMA 932 on at

Like (0)

Report

i select table, then I select field associated to this table :

l

Was this reply helpful? Yes No