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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / How to get property In...
Finance | Project Operations, Human Resources, ...
Unanswered

How to get property Included column value of data field of table index?

(0) ShareShare
ReportReport
Posted on by akshi 150

Hello,

I want to get the value of the property value Included Column of the data field Qty of the index TransIdIdx of CustInvoiceTrans below.

I was able to get the Datafield(Qty) with DictIndex.includedColumn, but I can't find a way to get the Included Column value of the property in the DictIndex class.

If anyone knows how to get it, could you share it?

Any advice would be appreciated.

I have the same question (0)
  • GirishS Profile Picture
    GirishS 27,825 Moderator on at
    RE: How to get property Included column value of data field of table index?

    Hi Akshi,

    How you got Data field value?

    If you got property of the Data field value, then my assumption will be using the same you can get the included column value right?

    Thanks,

    Girish S.

  • Anton Venter Profile Picture
    Anton Venter 20,303 Super User 2025 Season 2 on at
    RE: How to get property Included column value of data field of table index?

    Why do you want to do this?

  • akshi Profile Picture
    akshi 150 on at
    RE: How to get property Included column value of data field of table index?

    Hi Girish,

    I got the Data field value by this code.

    Dictionary dict;
DictTable  table;
DictIndex  idx;
dict = new Dictionary();
table = new DictTable(dict.tableName2Id("CustInvoiceTrans"));
idx = new DictIndex(table.id(), table.indexName2Id("TransIdIdx"));

if(idx.numberOfIncludedColumns())
{
    for (int k=1; k <= idx.numberOfIncludedColumns(); k  )
    {
        int includedCol = idx.includedColumn(k);
        str includedColName = table.fieldName(idx.includedColumn(k));
         Info(strFmt("IncludedColumn: %1, IncludedColumnName: %2",includedCol, includedColName));
    }
}


    Do you know how to get the value Yes or No for the Included Column?

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 684 Super User 2025 Season 2

#2
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 588

#3
Martin Dráb Profile Picture

Martin Dráb 542 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans