Welcome to "KB Articles"
How to use a wildcard in a LiveView query
book
Article ID: KB0073587
calendar_today
Updated On:
Products
Versions
TIBCO Live Datamart
2.x, 10.x
Show More
Show Less
Description
In some case, you may want to match on all possible values for a string field name in a LiveView query WHERE clause. For example..
WHERE field_name == <any value>
Issue/Introduction
Using a wildcard value in a query WHERE clause.
Resolution
To do this, use the StreamBase contains() function as follows..
WHERE contains(field_name, '')
Feedback
thumb_up
Yes
thumb_down
No