Skip to main content
November 10, 2023
Question

Unable to index the values when datatype of variable is recordtype

  • November 10, 2023
  • 3 replies
  • 0 views

Hello Everyone,

I would like to apply filter for the process report using queryprocessanalytics.Configured the queryfilters as below but none of the approach helped me.The result is null. 

1.

a!queryFilter(
field: index(index("c7","employeeDetails",{}),"employeeId",{}),
operator: "=",
value: "7"
),

2.

a!queryFilter(
field: "c7[recordTye!EmployeeDetails.fields.employeeId]"
operator: "=",
value: "7"
),

I have tried to index the same way on the process report data fields > Definition but not able to get the indexed value.

Is there any way to filter the values of particular field in record type.

    3 replies

    mikes0011
    Brainy
    November 10, 2023

    Does the Employee Details column in your report (the one corresponding to C7) actually show up correctly on the Process Report?  Could you include a screenshot?   Also: can you confirm my assumption that the column's value is just defined like "=pv!employeeDetails" where pv!employeeDetails is the recordtype data item?

    November 11, 2023

    yeah pv!employeeDetails is the recordType.

    stefanhelzle0001
    Brainy
    November 11, 2023

    I did some investigations, and it seems like indexing into record type data in process reports is not supported currently. This includes filtering.

    If you need to filter for this field, you will have to copy it into a separate process variable and use this instead.