Skip to Content
0

HCI PI DataStore

Mar 03, 2017 at 11:54 AM

535

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Morten Wittrock
Mar 03, 2017 at 12:15 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Sriprasad Shivaram Bhat Mar 03, 2017 at 12:21 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

1
avatar image
Former Member Mar 06, 2017 at 09:17 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded