Skip to Content
avatar image
Former Member

HCI PI DataStore

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Mar 03, 2017 at 12:15 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 03, 2017 at 12:21 PM

    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

    Add comment
    10|10000 characters needed 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

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

    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

    Add comment
    10|10000 characters needed characters exceeded