Display Information in Each Row

Question

I am trying to have the information iterated through and displayed in each row but am having trouble.. Can you please advise? 
 
 a!gridField_25r2(
 label: "Online Banking Profile Info",
 labelPosition: "ABOVE",
 data: rule!OOW_returnOBprofileDetails(CIF: ri!CIF),
 columns: {
 a!gridColumn(
 label: "Account Username",
 value: fv!row.userId
 ),
 a!gridColumn(
 label: "Account Nickname",
 value: rule!OOW_returnProfileNicknames(CIF: ri!CIF)
 ),
 a!gridColumn(
 label: "Last Log In",
 value: a!forEach(
 fv!row,
 rule!OOW_returnUserProfileLastLogIn(CIF: fv!row.customerCif)
 )
 ),

 },
 pageSize: 5,
 borderStyle: "STANDARD",
 shadeAlternateRows: true
 ) 
 This is what is returned from my rule.

Shubham Aware · Answer

Modify your data source rule rule!OOW_return0BprofileDetails() to return properly structured data with one row per account, ensuring each account has its own nickname and last login time as separate items in the array. 
 Also could you help us with what&rsquo;s exactly your source data and what&rsquo;s expected output to looklike.

Harsha Sharma · Answer

Your rule referenced in data attribute, is returning a single text instead of List of Text. If you expect the values to be displayed as an array then split the last expression in your rule using 
 split(local!variable (or whatever final expression you have) ,&rdquo;;&rdquo;) 
 No need to modify anything in main rule just split the final output so that it turns into a list of strings then try!

Mike Schmitt · Answer

a!gridColumn() is supposed to reference a single column of a single row of data , but here, in the column you're having it return that column's value for all rows , which is of course incorrect. What you should be doing is making sure the "nickname" is included in the "return... ProfileDetails()" rule, and reference the value via i.e. "fv!row.nickname" (or whatever the property's name is in the returned data set).

Display Information in Each Row

Top Replies