Task Report Status Filter not working

Question

Hi , 
 I am new to SAIL and I am trying to display a task report from one process model. I followed the Task Report Tutorial and did most of the things concerning it except the define status filter is not working . 
 Also I would like to display Assigners as users not a user name. 
 Could any with more experience with SAIL help me on it? 
 We are working with Appian version 18.1. 
 Thanks in advanced. 
 BR,Natasa

Peter Lewis · Answer

Can you post the full expression of what you have so far? Usually the best way to display a user's name is to using the user() function. You should be able to do something like this to show the users: 
 a!gridTextColumn(
 label: "User",
 data: a!forEach(
 items: local!datasubset.data.c4 
 /* This will vary depending on the column you use */
 
 expression: user(fv!item, "firstName") & " " & user(fv!item, "lastName")
 /* This returns the users first and last name and concatenates them together */
 )
)

Mike Schmitt · Answer

I urgently advise you to ditch the current concept of rendering all grid columns in a single forEach() statement. You should be declaring all columns independently, manually, as you will find it 100x easier (being conservative here) to configure each one per what your exact interface wishes are.

Mike Schmitt · Answer

Also I suggest you go check out a small helper app I developed and shared with the community a couple years ago - the Advanced User Task Report (which has an 18.1 version posted in the original thread luckily). At the very least you could probably use this to see how to deal more effectively with columns in a portal report queried into a SAIL form, as well as ways to handle display of multiple assignees. 
 I have a newer (19.4) version ready too, which honestly does certain things a lot better and more easily, but it looks like you're stuck with 18.1 for now unfortunately.