Please explain how we can use index function with cdt? want explanation with example.

Hi Team,

I understood how index function works, but can someone please write a code(with example) using index function with cdt.

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Associate Developer

    Hi  ,

    Lets assume you have 3 column in a CDT EmployeeData as "Name", "Number", "City". now if you want to fetch all the values of City column, you need to use the index function as below:

    Index(Your_CDT,column_Name,default_Value)

    Index(EmployeeData, "City", null)

    And in case of Record type, code syntax will be same. but you can not index it directly by giving the column name, you need to pass the column name as below

    Index(EmployeeData, recordType!yourRecordName.fields.yourField, null)

Reply
  • 0
    Certified Associate Developer

    Hi  ,

    Lets assume you have 3 column in a CDT EmployeeData as "Name", "Number", "City". now if you want to fetch all the values of City column, you need to use the index function as below:

    Index(Your_CDT,column_Name,default_Value)

    Index(EmployeeData, "City", null)

    And in case of Record type, code syntax will be same. but you can not index it directly by giving the column name, you need to pass the column name as below

    Index(EmployeeData, recordType!yourRecordName.fields.yourField, null)

Children
No Data