Search events by response models

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

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

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

I want to implement search on event data models .at the moment none of the parameters available is becoming helpful except being pre defined filters as shown belows

can you please advise how to search through my non/semi structured documents over some of its field

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?

Hi @Harshil_Gandhi ,

could you please share more details on the data structure of your events and what/how you want to search them?

Regards Kai

Below is my single event structure

“events”: [
{
“creationTime”: “2022-11-08T10:03:49.508Z”,
“source”: {
“name”: “Demo_Sensor_Visual_MCS-02I502”,
“self”: “https://t129954457.emea.cumulocity.com/inventory/managedObjects/524”,
“id”: “524”
},
“type”: “UDI-Event”,
“lastUpdated”: “2022-11-08T10:03:49.508Z”,
“self”: “https://t129954457.emea.cumulocity.com/event/events/381623”,
“time”: “2022-11-08T11:03:48.000+01:00”,
“id”: “381623”,
“text”: “Quality test event”,
“image_string”: “/9j/4AAQSkZJRgABAQAAAQABAAD/2wBDAFA3PEY8MlBGQUZaVVBfeMiCeG5uePWvuZHI////////////////////////////////////////////////////wAALCAEdBCQBAREA/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/9oACAEBAAA/AKlFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFJRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRS0lFFFFFFFLRRSUtFFFFFFFJRRRRRRRRRRRRRRRRS0qdakpKKD1ozSGg1ds/wDVfjViiiiikpDRRRRRRSCikooNZdFFFFFFFFFFFFFFFFFFFFFFFFFFFFFJRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRS0lFFFLSUtFJS0UUUUUUUUlFFFFFFFFFFFFFFFLSr1p5opp5bFLsPrSbTRtNBU1ftBiEVPRSUtFJRSUUUCjtSUUUnaikrMoooooooooooooooooooooooooooopKKKKKWkooooooooooooooooooooooooooooooooooooooooopaKSlooopKWkpaKSiiiiiiiiiiiiiiilpydaeRRim/x0rnHShTTqRulXbb/UrU1FIaWkooopO1HSijNFJSUUmKKzKKKKKKKKKKKKKKKKKKKKKKKKKKKSiiiiiilpKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKWkopaKKSlooopKWikooooooooooooooopacnWpCMUUz+Kh6RTinbxSM2eK0YP9Sv0qSiiikoopM80UGiiikpKDQaSsyiiiiiiiiiiiiiiiiiiiiiiiiiikpaSiiiilpKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKWkooooooopaSiilopKWiikopaSiiiiiiiiiiiiiiiilp0fWpSSeKQimfx04gU0gUECkwK04hiNR7U+iioppPLXOKr/az6UC7POQKQ3TcUgum6YpRdEds1NDN5hPGKmopKKSkopKzaKKKKKKKKKKKKKKKKKKKKKKKKKSilpKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKWkpaSlopKWiikpaKSiiiiiiiiiiiiiiiilp0fWpqQ1H/AB0rHFMooxWrH/q1+lOooqvd/wCrqvBGrKxbtTd0eeVpS0WPu0mYvQ0sqIEDJUlmM5Jq3RSGmu21SarpcFnwRUk0mxcimRS7yaa82GIqrRRRRRRRRRRRRRRRRRRRRRRRRRSUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUtJRRRRRRRRS0lLRSUUUtJRRS0UlFFFFFFFFFFFFFFFFLTo+tWOgplR/wAdD9aaDiilBrUT7g+lOooqteE7KZagNGQaa0EYP3qQRRH+PFOFujdGpLhdkSrTrP7pqzS0hqOY/uzVKHmUVPdfcFQJIU6VIkYkXcTyar0UUUUUUUUUUUUUUUUUUUUUUUlLSUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUtJRRRRS0lFFFFFLRSUUUUUtFFJRRRRRRRRRRRRRRRRS0+L71T5NNPIqIffpzAGm7RS7RRgZFaS/dH0p1JRVa96CmwHbAzd6rDdI2M1N9lb1qIFon96muG3RrnrTrP7pqzS0hqKc/uzVOJgrgmp2kicYY0LFG33akVAq4AqhRRRRRRRRRRRRRRRRRRRRRRRSUUUtFJRRS0lFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFLRSUUUtFFFFJRRRRRRRRRRRRRRRRS0+L71SgE0ZAGKi/jpWBNNwaMGlUHcK1B0FLRRVS9JwKZGD9nPpUMb7GzipftTegqF3Ltk1NP/AKtafaD5TVkUUVFcH90az6KtWucGrFZtFFFFFFFFFFFFFFFFFFFFFFFFFFFFFJRS0lFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFLRSUUUUUtFFFFJRRRRRRRRRRRRRRRRS0+LrVjGeaYai/jpWbFJv9qTdTkbMg+taY6UtJS1TveoFLDtWA7uRTN8GPu0mYM9KeiwseBzTLrsO1S2owmanooqG4/wBUapKpY4FP8h/SnRuIiQwq0rBlz61nUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUlFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFLRSUUUUUUtJS0lFFFFFFFFFFFFFFFFFLTo+tTh+1NNMH36VgO9NIFMqSMDzF+tadFLRVK8zmpIEDwYPSk+yp7002q+tV3HlyYBp9wchc+lT2v+rqekpahuT+6NVrb/W1cxVK4/1pqzD/AKsVRoooooooooooooooooooooooooopKKWkooooooooooooooooooooooooooooooooooooooooooooooooooooopaSlpKWkooooooooooooooopafH1qTFFRgfPSspNJsNIVNPhH71frWnRRRVK8+9TkYxwZHNRfaG96DcPTERpXp1yApAqe2/1dTUGkGc1Fc/6o1URyhyKswTFzgimywFnJzUyLtUD0rPooooooooooooooooooooooopKWikooooooooooooooooooooooooooooooooooooopaSiiiiiiiiiiiiiiiiilpKWkooooooooooooooooooqSIZJqWgggVFghsilG6k+ajJp8PMq/WtKiiiqN39+mpOUXbjIpfPX+4KTzl/uilW4C9qilfec1btv9XU1FJUN1xHVGrFqPmJollZXIFM89/WoqKKKKKKKKKKKKKKKKKKKKKKKKKKSiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiilpKKKWikpaSiiiiiiiiiiiiiiiipYe9S0uOKTikxTTSYp8I/fLWhRSUtMZQw5GaTykx90U3yU/uigxJ/dFBhT+6Kb5CZ+7UgUKMCnUlJ3qC6/1dV4Apb5qtKFTpgUjRoxJxTfKj9BVOiiiiiiiiiiiiiiiiiiiiikpaKKKSiiiiiiiiiiiiiiilpKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKWikpaKKKKKSiiiiiiiiiiiiiiiipoOpqXNBpM0h4ptFPg/1wq/RSUtQvMqnBNNF0uec0G5QUfaEx1o+0J60nnp61KpBGaWikqvdn5BVQZzxSlm7k1YjkAiwTzUG5vemUUUUUUUUUUUUUUUUUUUUUUUUUUlFFFFFFFFFFFFFFFFLSUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUtFJS0UUUUUlFFFFFFFFFFFFFFFFSwnBNS0maTPNGaTNFPt/wDXCr9FFJVJx/pIB9amkMadQOaVER1yAKXyU9OaifylbBxTZ0UJuUYqaD/VCpKSiq939wVHajJNNuRiTiowpIzjipxJGAKrUUUUUUUUUUUUUUUUUUUUUUUUUUlFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFLRSUUUUUUUUUUUUUUUUUUUUUUUtGT60ZPrS7j60bj60bjRuPrU9oczVoUUlFU2JN1we9Nux845qW1cbanLAVnynMpPvU83+oFTQ/wCqFPopKrXf3QKbad6SeJmkyBmpEQiHGOareW392mUUUUUUUUUUUUUUUUUUUUUUUUlFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFLRSUUUUUUUUUUUUUUUUUUUUUUUUUUUtFFWLIfvfwrQpKKKp8faqfcwF/mWq6xyAcUoSUihIHLc8VNc8RgVJD/AKsVJSUVWu+gpLTHNOln2PjFSRtvXNLis6iiiiiiiiiiiiiiiiiiiiikooooopaSiiiiiiiiiiiiiiiiiiiiiiiiilpKKKKKKWkoooopaSiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiilooqzY/wCsP0q/SUUGqS5NzT7mYr8oqqJHHOaUyu3enxTMG5OamueYxUkX+rFSUUlVrvoKrK5XoaGYscmrUbbYMioftD+tQ0UUUUUUUUUUUUUUUUUUUUUUUlFFFLSUUUUUUUUUUUUUUUUUUUUUUUUUUtJS0lFFFLSUUUUtFJRRRRS0UlFFFFLSUUUUUUUUUUUUUUUUUUUUUUUUUUUUtFFWrH/WH6VeopKD0qpH/wAfJ7VFdf62oyw2YxSxOq53DNNHL8VauP8AVqO9TJwgp1AoqrdnpVapood65zirGweXsFQ/Zfeq1FFFFFFFFFFFFFFFFFFFJRS0UlFFFFFFFFFFFFFFFFFFFFFFFFFFFFFLSUtFJRRRRRRRS0UlFFFFFFLSUUUUUtJRRRRRRRRRRRRRRRRRRRRRRRRRRRS0UVbsfvNV2iikPSqcXNyc1JNFGz/McGojDFn71BhiA+9SpFHkENRdcbasJ9wUtFFVLs8gVXAzViBwEIJqMSOX+8etWjIB3qhRRRRRRRRRRRRRRRRRRRRSUtFJRRRRRRRRRRRRRRRRRRRRRRRS0lFFFFFFFLSUUUUUUUUtJRRRRRRRRRRS0lFLSUUUUUUUUUUUUUUUUUUUUUUUUUUUUtFFW7Hq1XaKKa3Q1Uh/4+DTp4S7ZBqE27DPNHkPSrC4YU+56qKsR/dFLRRVS7+8KW2UFSSKhlGJCBU21RBnHNVs0lFFFFFFFFFFFFFFFFFFFFJS0UlFFFFFFFFFFFFFFFFFFFFFFFLRSUUUUUUUtJRRRRRRRRRRRRRRRRRRS0UUUUUUlFFFFFFFFFFFFFFFFFFFFFFFFFLRRVyx6NVyikpG6GqkA/fk0k7yCQ4zURlkxgmkEknYmpI3kZwM1Jc9V9asL90UtFIap3f3hT7bhPqajliYuTSGUGPZioaKKKKKKKKKKKKKKKKKKKKKSloopKKWkoooooooooooooooooooopaKSiiiiiiiiiiiiiiiiiiiiiiiiilpKWiiiikooooooooooooooooooooooooopaKKu2P3Wq3RRTH+6c1VtT+8anSXChyMdKgnkEhyKWGVUGCM1LFMhbG3BNFzjctWF+6KWkoNU7v74pkcxQY605rhj2qGkooooooooooooooooooooopKWiiiiiikooopaSiiiiiiiiiiiiiilopKKKKKKKKKKKKKKKKKKWkoooopaSiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiilooq9ZD92atUUUyTOw4qpA4RyWp5aFskimnyeOKD5HpSjyRjHWmyuGdcdqtjoKKKSoJYPMbOaZ9l/2qPsv+1Tfsx9aPsx9ar0UUUUUUUUUUUUUUUUUUUUUUlLRRRSUUUUUtJRRRRRRRRRRRRRRS0lFFFFFFFFFLSUUUUUUUUtJRRS0lLSUUUUtJRRRS0lFFFFFFFFFFFFFFFFFFFFFFFLRRV+y/1VWaKKSmGFGOSvNJ5EY6LQYIz/AA0nkR/3aT7OnpQIEBzipO1FFFJRRSUYrMooooooooooooooooooooopKKKKWkpaSilpKKKKKKKKKKKKKKKKKKWkoooooooooooooooooooooooooooopaSiiilpKKKKKKKKKKKKKKKKKKKKKKKKWiitG0GIRU9JS0UUlLSUlJjmlNJRRSUUUUVl0UUUUUUUUUUUUUUUUUUUlFFLRSUUUtFJS0lFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFLRSUUUtJRRRRRS0lFFFFFFFFLSUUUUUUUUUUUUUUUUUUUtFFaVsMQrU1FFFFFFJQaSkpRRSUUlFFFZdFFFFFFFFFFFFFFFFFFFFJRS0UlFFFFFFFFLSUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUtJS0UlFFFFLRSUtJS0lFFFFFFFFLSUUUUUUUUUUUUUUUUUUUtFSwR+Y30rQjGEAp9FFFFFFJSUUUUhopKKKKKy6KKKKKKKKKKKKKKKKKKKKSilopKKKKKKWkoooopaSiiiiiiiiiiiiiiiiiiiiiiiiiiilpKKKKKKKKWiiikoooooooooooooooooooooooooooooopaKtWP3m+lXE+6KdRRSUUtJRSUUlGaKKSiig0Vl0UUUUUUUUUUUUUUUUUUUUlFFFFFFLSUUtJS0lLSUUUUUUUUUUUUUtJRRRRRRRRRRRRRRRRRRRRRRRRS0UUUlLSUUUUtJRRRRRRRRRRRRRRRRRRRRRRRRRU9q22T8KvI3y07cKXIpM0ZFGaXNJkUZFIWA700yD1pPMB70bxS7hRuHrSbxRuHrS7wO9MaZR3pn2hao0tFFFFFFFFFFFFFFFFFJS0lFFFFLRRSUUUUtJS0lFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFLSUtJRRRS0lFFFFFFFFFFFFFFFFFFFFFFFFFKpKnIqQTOO9Hnv60v2iT1pPtEn96l+0SetJ58nrR58nrR58n96k81/wC8aTzG/vGk3E9zRub1o3t6ml3t/eNJvb1NG9vU0b29TRuJ7mkzRSUUtFFFFFFJS0UUUUUlFFFFFFFFFLRSUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUtJRRRS0UlFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFLRRRSUtFJRRRRRS0lFFFFLRRRRRRRRRRSUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUtJS0lFLSUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUtJS0lFLSUUUUtJRRRRRRRRRRS0UUlFLRRRSUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUtJRRRRRRRRS0lFFLSUtJRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRS0UUlFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFLSUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUtJRRRS0lFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFf/9k=”,
“lot”: “”,
“test_status”: “Rejected”,
“reason”: “No code”,
“ref”: “”,
“event_type”: “UDI-Event”,
“producer”: “”,
“location”: “Cris-2”,
“child_type”: “Demo_Sensor_Visual_MCS-02I502”,
“udi-type”: “HIBC”,
“udi-code”: “”,
“quality”: “A”
}

i want to implement full text search entirely across all events with in my tenant DB

Is there any endpoint which allows me to do full text search and generates paging on top of searched content

statistic in Pagination is flawed on event endpoint
in this case Server side paging never works

  • The event endpoint by default gives 5 records per page if not queried by any query parameters

  • With this,It gives total number of pages for all events

  • As you pass the query parameter in Endpoint,the resultant dataset removes total pages,This is weired and Endpoint is not consistent,pagination can never work in this scenario

I do not want to treat my page as server side linked list for pagination and next and previous link i do not use it for binding it to my paginated client component

Please make totalpages consistent

result data models are not consistent in filtering and search

There is no full text search API on events available.
Only parameters available in the documentation can be used, e.g. you can query only for events which contain a specific fragment with the fragmentType and optionally also the value (in case of String value) with the fragmentValue parameter.

Regarding your remarks:

This is correct. With the pageSize and currentPage parameters you can specify the page size (max 2000) and the page you want to retrieve.

Total number of pages is only added if the parameter withTotalPages is set to true.

I am afraid this is an error on your end. Please try using Postman with the parameters correctly and do not mix between adding parameters in the “table format” (like withTotalPages) and in the “address bar” (like source).
Properly sending the parameters will return the result as expected.

open your browser you will see the same result (Postman or No Postman)

totalpages are not consisent. its fine if its not there but i can make verification for my implementation

This is true for measurements endpoint as well by the way

is it possible to get source code of events microservice ,I would change by myself. if its not possible at your end

Please watch your tone, we want to keep a friendly environment in this community :slight_smile:

You are missing to add the required withTotalPages=true parameter!
Please always add this to your queries if you want the totalPages to be included in the response.

This parameter is by default false, hence no totalPages are given.

I understand that it might be confusing as the event API returns totalPages when no parameters are given at all. I will delegate this to R&D.

2 Likes

Marking it as answer,It would have been concluded more friendly if answered in first instance

Thanks anyways.!Apologies for any offense