yuuvis® Q&A

0 votes
in yuuvis Momentum by (470 points)

Hi Yuuvis team

we have a table property that has two columns, key and value.

When searching for an item, the whole table is returned with all lines. Is it somehow possible to only return one specific column? I.e. by giving the index or by filtering the key in the query?

1 Answer

0 votes
by (3.0k points)
selected by
 
Best answer

Dear Mathias,

it is possible to reference one or multiple table columns between the 'SELECT' and 'FROM' keywords. If you consider an example table property 'pricelist' with the two columns 'item' and 'price', you could start your query statement with 'SELECT pricelist.item FROM ...'. The query will then return only the selected columns, in the example only the 'item' column.

>> Documentation

Best regards,
Antje

by (470 points)
Hi Antje

Sorry, I meant to return a specific row, not a specific column. Is this possible?

Regards, Mathias
by (3.0k points)
+1
Dear Mathias,

It is not possible to select individual rows to be returned. We consider the entire table as value for the table property. The columns we consider as well-defined sub-properties but not the individual rows as their actual number depends on the concrete value of the table property.

Best regards,
Antje
...