a!gridColumn( label: "Conformance", sortField: "adherence", value: a!richTextDisplayField( label: "Adherence", value: { a!richTextItem( text: if( rule!INO_isBlank(fv!row.adherence), "-", fixed(fv!row.adherence, 2) & "%"/*text(fv!row.adherence /100, "##.##%")*/ ), link: a!dynamicLink( value: fv!row.employee, saveInto: { ri!selectedEmployee, a!save(ri!selectedEmployeeRow, fv!identifier) }, showWhen: and( and( not(isnull(ri!showDynamicLinks)), ri!showDynamicLinks ), fv!row.adherence <> 0, not(or(fv!row.employee.isTeamLead)) ) ), linkStyle: "STANDALONE", color: "STANDARD", size: "MEDIUM", style: if( and(fv!row.employee = ri!selectedEmployee), "STRONG", "PLAIN" ) ), " ", a!richTextIcon( icon: if( isnull(fv!row.adherence), null, if( todecimal(fv!row.adherence) >= todecimal(local!adhereranceTarget.targetValue), "check-circle", "minus-circle" ) ), caption: "Target Minimum: 95%", showWhen: and(fv!row.adherence <> 0), color: if( isnull(fv!row.adherence), null, if( todecimal(fv!row.adherence) >= todecimal(local!adhereranceTarget.targetValue), cons!INO_HEX_POSITIVE, cons!INO_HEX_NEGATIVE ) ), size: "MEDIUM" ) } ) ),
This error is showing after clicking "Conformence" column. Because this data came from stored procedure and that's why "sortField" not working proper and we are getting this error. How to sort then?
Discussion posts and replies are publicly visible
You can cast stored procedure output into dictionary structure using a!map() function. Also, a datasubset can be created. Use this data while creating grid instead of directly using stored procedure output.