How to compare the data value that is stored in the Database with the new data point using stream analytics builder?

What product/components do you use and which version/fix level are you on?

latest

Is your question related to the free trial, or to a production (customer) instance?

production

What are you trying to achieve? Please describe it in detail.

The events consits of the order number key value along with other key value pairs. Multiple events has the same order key value. I need to store only once order number in DB. That means the order number value should be unique in the DB.
Is there a way to implement logic with stream analytics builder?

Do you get any error messages? Please provide a full error message screenshot and log file.

Have you installed all the latest fixes for the products and systems you are using?

yes.

This is not doable with the built-in blocks. I would suggest using an EPL App to listen for events and then look for existing matching event with FindEvent:

https://documentation.softwareag.com/pam/10.15.1/en/webhelp/related/ApamaDoc/com/apama/cumulocity/FindEvent.html

You can search for events with a specific key-value pair. Based on the result you can decide whether to save, update or discard the event.

If required, you could wrap this functionality into a custom block for Analytics Builder:

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.