Using the "where" clause in BusinessEvents Views for the data source.

Using the "where" clause in BusinessEvents Views for the data source.

book

Article ID: KB0084447

calendar_today

Updated On:

Products Versions
TIBCO BusinessEvents Enterprise Edition -
Not Applicable -

Description

Resolution:
Description:
===========
BusinessEvents Views - Datasource with the "where" clause does not work.

ex.:
SELECT * FROM /Dashboards/MT_testTiming WHERE TMS >= $tInput  ORDER BY TMS;

Environment:
===========
  o BusinessEvents 5.0
  o All Operating Systems

Symptoms:
=========
Error in log:
Error [Thread-70] [subscriber] NoViableAltException(79@[364:15: (lc= TOK_IN (u= unaryExpr -> ^( TOK_OR $inExpr $u) | TOK_LPAREN field ( TOK_COMMA field )* TOK_RPAREN -> ^( TOK_OR ( ^( TOK_EQ $e field ) )+ ) ) | TOK_NOT lc= TOK_IN (u= unaryExpr -> ^( TOK_NOR $inExpr $u) | TOK_LPAREN field ( TOK_COMMA field )* TOK_RPAREN -> ^( TOK_NOR ( ^( TOK_EQ $e field ) )+ ) ) )?])

Cause:
======
required to use Keyword "where" in lower case
CR BE-12676 exist (should be fixed in BusinessEvents Version 5.1)

Resolution:
========
Keyword "where" is case sensitive in BE 5.0 (lower case required)

i.e.:
SELECT * FROM /Dashboards/MT_testTiming where TMS >= $tInput  ORDER BY TMS;

Issue/Introduction

Using the "where" clause in BusinessEvents Views for the data source.