How to use a wildcard in a LiveView query

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

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, '')