Community for yuuvis®

0 votes
in yuuvis Momentum by (330 points)

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

1 Answer

0 votes
by (1.3k points)
selected by
 
Best answer
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.

Welcome to the yuuvis® Community

Welcome to yuuvis® Q&A, where you can ask questions and receive answers from other members of the community.
...