In BusinessEvents 3.x, querying records with a particular month and year from the cache.
Article ID: KB0088636
Updated On:
| Products | Versions |
|---|---|
| TIBCO BusinessEvents Enterprise Edition | - |
| Not Applicable | - |
Description
Resolution:
Description:
============
In BusinessEvents 3.x, querying records with a particular month and year from the cache.
Environment:
==========
TIBCO BusinessEvents 3.0.1
TIBCO BusinessEvents QueryAgent
Resolution:
==========
The following query can be used as an example to retrieve records from cache.
Select cust FROM /CEP/Ontology/Customer cust where /#DateTime/getMonth(cust.CreatedOn) = 5
and /#DateTime/getYear(cust.CreatedOn)=2010
Attachments:
===========
FIle OrderProcessing.zip attached for reference.
Description:
============
In BusinessEvents 3.x, querying records with a particular month and year from the cache.
Environment:
==========
TIBCO BusinessEvents 3.0.1
TIBCO BusinessEvents QueryAgent
Resolution:
==========
The following query can be used as an example to retrieve records from cache.
Select cust FROM /CEP/Ontology/Customer cust where /#DateTime/getMonth(cust.CreatedOn) = 5
and /#DateTime/getYear(cust.CreatedOn)=2010
Attachments:
===========
FIle OrderProcessing.zip attached for reference.
Issue/Introduction
In BusinessEvents 3.x, querying records with a particular month and year from the cache.
Attachments
Feedback
Yes
No
Powered by
