cancel
Showing results for 
Search instead for 
Did you mean: 

HCI PI DataStore

Former Member
0 Kudos

Hi Experts,

I need to understand the storing and reading capabilities of HCI DataStores. After storing a message inside datestore can we put a filter/condition while reading the message from the datastore to get the required information only. Meaning, do data stored in datastores is indexed?

Please help in this regards,


Thanks,
Aman

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Aman,

Filter option is not possible while retrieving the data from the datastore. But we have option of Overwrite existing message option while you are writing the data (once after storing and picked up successfully when you write next time it will automatically overwrite the existing message).

Please put your exact requirement so that we can put some thoughts ....

Regards,

Vijay

Sriprasadsbhat
Active Contributor
0 Kudos

Hello Aman,

Adding to Morten views,filter is not possible when you retrieve it using select operation.

Filter while using get operation works only while you inserting record you set some unique entry id for each record.

Regards,

Sriprasad Shivaram Bhat

MortenWittrock
Active Contributor

Hi Sriprasad

You are right, I should have phrased that better. I meant e.g. routing on an XPath condition based on the /messages/message/... structure returned by the Select operation, if that fits the OP's requirements.

Thank you,

Morten

MortenWittrock
Active Contributor
0 Kudos

Hi Aman

If you retrieve an entry by ID (i.e. the Get operation), the retrieved value replaces the payload. At that point, you are free to map, extract values with a Content Modifier or whatever other operation makes sense in your context.

Alternatively, you can retrieve multiple entries with the Select operation, and iterate/filter them, if that is a better fit with your requirements.

Regards,

Morten