web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / get field value by fie...
Microsoft Dynamics AX (Archived)

get field value by field id

(0) ShareShare
ReportReport
Posted on by Community Member

hi,

i  know table name , table field id  and  table field name as  string .

for example  Table1  , with field id  60001  and  fieldName  - "code" as string ;

i want to get the value  of this field  from database .

how can i  get this information ?

*This post is locked for comments

I have the same question (0)
  • Basheer17 Profile Picture
    Basheer17 2,720 on at

    You can get lot of information on the internet. msdn.microsoft.com/.../aa848113.aspx for example.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi David,

    What do you mean 'from database'?   Are you talking about getting this information using x++ or through t-sql?

    T-SQL would be: select field from Table1

    x++ would be very similar:

    Table1 t1;

    while select field1

        from t1

    {

      info(strfmt("my field value is: %1",field1)); // will loop through every record in Table1

    }

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    i had a problem  where   I have table field name  as string data type.  "code","firstname" and etc. you can't loop through  table when you have string .

    i   solved my issue

    fieldID = fieldName2Id(tableName2Id("tablename"), "fieldName");

    valueStr = table.(fieldID )

    you are getting  value in valueStr field.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans