Skip to main content
New Participant
Nov 10, 2023 3:28 PM UTC
Question

Unable to index the values when datatype of variable is recordtype

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
    Nov 10, 2023 3:38 PM UTC

    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?

    The Expression Guru
    New Participant
    Nov 11, 2023 12:54 PM UTC

    yeah pv!employeeDetails is the recordType.

    stefanhelzle0001
    Brainy
    Nov 11, 2023 2:22 PM UTC

    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.