Good morning All,
we are using Gridfield to populate the task report data. In the task report we have one column which will bring back text values of tp!assignees or a constant value with some logic. When are using index function to populate the data in the grid. Everything works great until assignee's are null for a task.
1. grid will sort the null values to the end of the list, irrespective of asc/desc order. Field sorting is not working properly for that Task Assignee column. All the null values are pushed to the end of the column independently. Rest of the columns are working fine.
2. The rule is returning the values of the column in sorted order as shown at the top of the Image.
3. Tried adding a default value in the index and the issue is that index is not recognizing this field as an null/empty value.
I appreciate the help and Thank you all in Advance.
Discussion posts and replies are publicly visible
Likely issue is the 'field' in the column definition (a!gridTextColumn) doesn't match the field in the datasubset.In the below code the field has value label and the data is label also. a!gridTextColumn( label: "Name", field: "label", data: index(local!dataForCurrentPage, "label", null), alignment: "LEFT" )
Likely issue is the 'field' in the column definition
(a!gridTextColumn) doesn't match the field in the datasubset
.In the below code the field has value label and the data is label also. a!gridTextColumn( label: "Name", field: "label", data: index(local!dataForCurrentPage, "label", null), alignment: "LEFT" )
a!gridTextColumn( label: "Name", field: "label", data: index(local!dataForCurrentPage, "label", null), alignment: "LEFT" )
Hi Ramaseshur, In Appian datasubset, the null value is discarded automatically, So you need to manipulate the data by replacing the null value to " " (Blank Space), a!gridTextColumn( label: "Task Assignees ", field: "c16", data: updatearray( index(local!dataset.data,"c16","No Assignee"), wherecontains(tostring(null),touniformstring(index(local!dataset.data,"c16","No Assignee")),
" " ) ) ),