SQL statementto retrieve Entity (type) information from the backingstore.
book
Article ID: KB0089859
calendar_today
Updated On:
Products
Versions
TIBCO BusinessEvents Enterprise Edition
-
Not Applicable
-
Description
Resolution: Description: =========== Creating database queries using Oracle data types in backingstore.
Environment: =========== TIBCO BusinessEvents 3.x/4.x All Operating Systems
Resolution: ======== Table and column names are included in double quotes (“) and they are case sensitive in the SQL statement.
There are some special settings required for nested tables (e.g. concept references), but the syntax is straightforward Oracle. For datetime types use t.ENTITY."myDatetimeProperty"."tm" because this is a structured type.
select t."ENTITY"."xYzconceptproperty",t."ENTITY"."conceptproperty" from d_concepttable t where t.ENTITY."aBc"='anyvalue'
-- based on the BackingStore example (FraudDetection) select t.ENTITY."EXTID$",t.ENTITY."Debits" from d_account t where t.ENTITY."AvgMonthlyBalance"='10000';
Issue/Introduction
SQL statementto retrieve Entity (type) information from the backingstore.