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>

 

Resolution

To do this, use the StreamBase contains() function as follows.. 
WHERE contains(field_name, '')

 

Issue/Introduction

Using a wildcard value in a query WHERE clause.
Powered by Wolken Software