in record view, how to fix : Error Evaluation UI Expression Expr

index(local!datasubset.data, "UpdatedBy", null)

It looks like you're passing in a text rather than a query value to index. What are you indexing to try and get the "data" part? Can you post your code?

the local!datasubset is using rule!GEN_getAllDivAuditByDivNo(rf!divisionViewId) to return a CDT data type

with(
local!datasubset: rule!GEN_getAllDivAuditByDivNo(rf!divisionViewId),

a!gridField(
totalCount: local!datasubset.totalCount,
columns: {
a!gridTextColumn(
label: "DivNo",
field: "DivNo",
data: index(local!datasubset.data, "DivNo", null)
),
a!gridTextColumn(
label: "UpdatedBy",
field: "UpdatedBy",
data: index(local!datasubset.data, "UpdatedBy", null)
),
a!gridTextColumn(
label: "UpdatedOn",
field: "UpdatedOn",
data: index(local!datasubset.data, "UpdatedOn", null)
),
a!gridTextColumn(
label: "Comments",
field: "Comments",
data: index(local!datasubset.data, "Comments", null)
)
},
value: local!pagingInfo,
saveInto: local!pagingInfo
)



UpdatedBy is one element or column from this dataset, what type should be used for this parameter 3?

Thanks,

Can you paste here the value of local!datasubset?

It's likely that rule!GEN_getAllDivAuditByDivNo() is either a query rule and so should have a pagingInfo value passed in our the rue itself is already returning the .data attribute

I attached my code as file.
I am totally in Appian tool. my purpose is creating a interface to get the data for a specific record. first the query GEN_getAllDivAuditByDivNo() return all data for this record, the interface will show four columns, divNo is interger, UpdatedBy is text, UpdatedOn is datetime, Comments is Text.

Thanks!


please tell me how to deal with it or give me a example.

code.docx

I suggest the following, if it doesn't work please share the code for rule!GEN_getAllDivAuditByDivNo():

local!datasubset: rule!GEN_getAllDivAuditByDivNo(rf!divisionViewId, local!pagingInfo)

Great!! Thanks to Tim!!!! It works!!

But most importantly do you understand why??