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
It's simple. The variable is accessible within the block into which it is defined.
See the following to understand it better -
a!localVariables( local!a: 1, { a!localVariables(local!b: 2, local!a), local!b } )
Abhay,
That was understanding - variable is available within the defined block. Unless, I am missing something, I don't see why line 8 in my example (second image in my original post) gives an error when the variable is defined on line 3. However, if I remove the braces on line 2 and 24, the error goes away (see image below).
Madhu
Stefan,
I can accept that Appian treats the curly-braces as the start of an expression. Back to my original issue, which is why is using "fv!row" (image below) causing a scoping variable issue. Isn't fv!row part of the gridField function that should be available at line:56? It is available at line 55. If passing it to the isNotNullorEmpty function is the issue, how do I access the value of fv!row in a function/expression for something like let's say to determine if the row is an odd or even row?
Thanks for your help.
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.