Hi:
I was experimenting with the Grid example in Appian Tutorials (https://docs.appian.com/suite/help/23.1/Grid_Tutorial.html) and noticed that I had some rows with no firstName and LastName. So, I thought I would use "fv!row.firstName" as part of the showWhen-attribute to prevent those rows from being show (see image below). However, I am getting "scoping error" messages. I know I can use query to filter out those rows but thought I would experiment with this approach because I have had issues with understanding local-variable scoping. For example, when I use {} right after a!localVariables (), I get scoping error (see second image.
Any responses to helping me understand local-variables/scoping would be appreciated.
Thank you.
Ma
Discussion posts and replies are publicly visible
So, facts first. As per the documentation fv!row can ONLY be used when assigning to the value parameter.
https://docs.appian.com/suite/help/23.1/Grid_Column_Component.html#parameters
Now, about the why. It just does not make sense in any other parameter as the gridColumn component defines the logic for the whole column.
If you want to show/hide a component in an individual cell, just add a richttextdisplayfield and make it show data according to your logic.
I guess what I am looking for is something similar to 'disableRowSelectionWhen' that would allow me to hide an entire row if one or more columns have is empty/null.
MaNa said:that would allow me to hide an entire row if one or more columns have is empty/null
You might want to think a bit more about this. Why would you want to hide a row when a column has an entirely empty/null value? What would this even look like / accomplish?
Mike,
The use case is when multiple faculty members submit grades for a student and GPAs are calculated after all faculty members submit their grades. Until all grades are submitted, the GPA column is null. So, I didn't want the interface displaying any rows where GPA column is null.
Guess the right approach would be to filter the data (pass only rows where the GPA column is not NULL) but I was experimenting to explore if there was a way to provide users with an option to either view or not view a row based on a column value (e.g., show only students/GPAs that qualify for Deans' List).
I support you idea of fetching only the required data instead of fetching all, wasting memory and trying to hide some of the data in the UI.
Yes, if the requirement is that your form should show GPA and that the only rows which appear are those where it's non-blank, then the key is to filter your data in advance of feeding it into your grid.
If you're querying the data from the DB, then you would simply provide a query filter and filter out rows where that value is not populated.
If, on the other hand, you are passing the whole data set (with a mixture of rows) like as a process PV array, then you could instead create an on-form temp variable consisting only of the rows you'd like to display. Something along the lines of, local!myTempArray: a!forEach(ri!myWholeArray, if(a!isNullOrEmpty(fv!item.GPA), {}, fv!item) within your local variables declaration. Then you'd simply pass that local variable into the data parameter of your grid, and you'd be displaying only the rows which have a value populated here.
MaNa said:As for the syntax in image 2, isn't the a!localVariable() on line 1, similar to the example in your response?
No it is not. The {} start the expression part and you cannot define local variable in the expression part directly the way you did it. To do that you need to have another nested localvariable() function, as I mentioned in my previous response. Hope this helps!
That sounds like an approach I should investigate - will do soon.
Abhay: That is what I learned from Stefan and you. I am used to using {} to segment code from C/C++ - Appian seems to have interpretations based on {} - didn't realize { indicated start of expression. Live and Learn.
I am going to post another problem - for nested forEach() - where not sure why the local variables are not working.