Hey All,
I want the null values in my read only grid to be renamed an account for as "No". So there should be 44 no values. How do I achieve this in Appian? I have provided the code for the two columns below.
{ a!gridColumn(
value:fv!row.DeliveredSDTMAssessment, align: "START" ), a!gridColumn( value: fv!row.AppId )}
Discussion posts and replies are publicly visible
I don't think you can update this at the grid column level - the issue is that your query returns three rows: for No, Yes, and null. So even if you make a change at the grid column level, you would end up with an extra unused row.
Instead, I'd suggest updating the data portion of your grid to address this issue. You can either use some expressions to combine them into a single row (probably using local variables) and plugging that local variable as the "data" for your grid, or you can manipulate the data in the database by creating a database view.