Show a text value instead of row id in an reag-only grid

Question

In the cloud database, a value with the row id is stored. 
 I have this read only grid, I want to change the row id value instead of another field of the row 
 In the following read-only grid image, the value of the row id "3" appears in the column "Grupo/Empresa" I want to change that value to a text to facilitate identification

In this case the row id "3" belongs to "CORFOPYM QUITO" 
 In the read only grid should appear " "CORFOPYM QUITO" instead of "3"

Amaan Shekh · Accepted Answer

1. you have to query from table (use a!queryEntity) to get the data in interface 
 2. store that value (data) in a local variable 
 3. in the grid column try this in value parameter -> index(
local!/*data's local variable*/.nombre,
wherecontains(fv!row[/*your int record field*/],local!/*data's local variable*/.id),
{}
)

Show a text value instead of row id in an reag-only grid

Top Replies