Searching for values of table (column)

Question

Hi Yuuvis Team

I want to search for a value in a table. Is this possible and how do I do this? Is there a special syntax? Currently even when I simply check the table property without specifying a colum for NOT NULL, I do not get anything returned.

{"query":{"statement":"SELECT * FROM system:object WHERE tenYuuvistest:processQueue IS NOT NULL","skipCount":0,"maxItems":20}}

Schema:

<propertyTableDefinition>

<id>processQueue</id>

<propertyType>table</propertyType>

<cardinality>single</cardinality>

<required>false</required>

<propertyStringDefinition>

<id>queueProcessId</id>

<propertyType>string</propertyType>

<cardinality>single</cardinality>

<required>true</required>

</propertyStringDefinition>

...

</propertyTableDefinition>

Kind regards
Nicole

Answer 1

Hi Nicole, currently we do not support search on field level in tables. This is planned for the release in Q4. The only possible solution is searching by full text.