What is the equivalence of Entity using Structure

What is the equivalence of Entity using Structure

  

hi there, 

I am using SQL Advance that returns more than one row of text. If I use entity with attribute text as output type, it works. How if I want to use structure? I try list of text, it does not work, also a list of structure of text attribute.

Thank you,

regards,

Made 

You always need a record structure as Advance SQL output structure.

If it return multiple records (as it commonly did), don't worry, your aggregate's output is a List of that structure's record.

WOrks:


, but  error:

where:



regards,

I

Solution

hi,

use  just text structure:

and 

fetch using the list:


Solution