TIBCO BusinessEvents (BE) - BQL query with IGNITE as CacheProvider and DateTime columns
Article ID: KB0070372
Updated On:
| Products | Versions |
|---|---|
| TIBCO BusinessEvents Enterprise Edition | - |
Description
How to perform a BQL query with a DateTime Concept property with Ignite as Cache provider
Issue/Introduction
How to perform a BQL query with a DateTime concept property
Environment
All Operating Systems
Resolution
You create a query that converts the DateTime property into a long value with BQL function DateTime.
Sample BQL query:
Attached a sample project.
Note:
From a performance point of view, we recommend adding a concept property of type long, storing the DateTime value as a long value and using the long value in the query.
Sample BQL query:
select cp from /Concepts/cpTest as cp where /#DateTime/getTimeInMillis(cp.dtValue)>1704805624950
Attached a sample project.
Note:
From a performance point of view, we recommend adding a concept property of type long, storing the DateTime value as a long value and using the long value in the query.
Attachments
Feedback
Yes
No
Powered by
