Return value at specific index in search with tables

Question

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?

Answer 1

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

Comments

Hi Antje

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

Regards, Mathias

---

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