Is it possible to have a list generated via a...

(Michael) #1

Is it possible to have a list generated via a SELECT statement displayed as a REF_ROWs statement?

REF_ROWS generates a list that is displayed as an inline table which is what I would like to do with a SELECT.

OR

Can the REF_ROWS be written so that a list is generated from another column other than the key fields?

(Praveen Seshadri (AppSheet)) #2

Well, no. If you have a list of Ref values, then they are effectively identifying rows in another table. So they can be shown inline as a nested table of those rows.

But if it is just a list of values, then they do not uniquely identify rows in a table. The key is the only column that is guaranteed to uniquely identify a row. You could certainly write an expression to get a list of values (eg: Row label values) and then use that to construct a list of Ref values that correspond to those via some matching expression.

(Aleksi Alkio) #3

I believe you are looking for a inline view which is coming from another table and without REF_ROWS. Read the list with a SELECT(TableName[KeyColumnName],TRUE) in virtual column and set the type to List and ElementType to “Ref”.