Input field-based predicate expression for LiveView Delete adapter

Input field-based predicate expression for LiveView Delete adapter

book

Article ID: KB0079221

calendar_today

Updated On:

Products Versions
TIBCO Streaming 7.x, 10.x

Description

I would like to use the LiveView Delete adapter to delete rows based on a predicate expression, where the expression is built using values from certain input fields.  For example, the schema sent to the LV Delete adapter is:

  TableName (string)
  Predicate (string)
  category (string)

How can I configure the predicate expression to be..

  category=<the value of the 'category' input field>

?

Issue/Introduction

Input field-based predicate expression for LiveView Delete adapter

Resolution

Since the LiveView Delete adapter only knows to look for the 'TableName' and 'Predicate' input fields, you must construct the predicate in an upstream Map operator.  In the Map operator's "Additional Expressions" tab, set..

Predicate = "category='"+input1.category+"'"