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
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 
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.
Marking it as answer,It would have been concluded more friendly if answered in first instance
Thanks anyways.!Apologies for any offense
This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.
