How can I search in events

Configuration
1

Hi,

When i open the events in the dashboard is see for the example the following output:

Event 1342 fired 1:00 PM:
{
    "event_type": "state_changed",
    "data": {
        "entity_id": "sensor.c5ffab70_b61786ae",
        "old_state": {
            "entity_id": "sensor.c5ffab70_b61786ae",
            "state": "3",
            "attributes": {
                "type": "browser_mod",
                "last_seen": "2020-10-28T12:00:22.951188",
                "deviceID": "c5ffab70-b61786ae",
                "path": "/developer-tools/service",
                "visibility": "hidden",
                "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.111 Safari/537.36",
                "currentUser": "Rolf",
                "fullyKiosk": false,
                "width": 1398,
                "height": 766,
                "battery_level": 100,
                "charging": true
            },
            "last_changed": "2020-10-28T11:22:24.629037+00:00",
            "last_updated": "2020-10-28T12:00:22.951912+00:00",
            "context": {
                "id": "28818ae9191511ebb3141f30144edac4",
                "parent_id": null,
                "user_id": null
            }
        },
        "new_state": {
            "entity_id": "sensor.c5ffab70_b61786ae",
            "state": "3",
            "attributes": {
                "type": "browser_mod",
                "last_seen": "2020-10-28T12:00:23.186007",
                "deviceID": "c5ffab70-b61786ae",
                "path": "/developer-tools/event",
                "visibility": "visible",
                "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.111 Safari/537.36",
                "currentUser": "Rolf",
                "fullyKiosk": false,
                "width": 1398,
                "height": 766,
                "battery_level": 100,
                "charging": true
            },
            "last_changed": "2020-10-28T11:22:24.629037+00:00",
            "last_updated": "2020-10-28T12:00:23.186955+00:00",
            "context": {
                "id": "28a567da191511eb8220693a176253e3",
                "parent_id": null,
                "user_id": null
            }
        }
    },
    "origin": "LOCAL",
    "time_fired": "2020-10-28T12:00:23.187035+00:00",
    "context": {
        "id": "28a567da191511eb8220693a176253e3",
        "parent_id": null,
        "user_id": null
    }
}

But when I use the sqlite3 program, i see no data. Where is the data gone ?

sqlite> select * from events WHERE event_id = 1342 ORDER BY event_id DESC LIMIT 10;
         event_id = 1342
       event_type = state_changed
       event_data = {}
           origin = LOCAL
       time_fired = 2020-10-28 07:44:55.812854
          created = 2020-10-28 07:45:03.209845
       context_id = 78d1b8c618f111ebac84b58462c4aacf
  context_user_id =
context_parent_id =
sqlite>

Thanks for helping me out!

2

The number you see there always starts at 0 if you refresh that page and start listening.

No clue if this is possible or will be implemented in the future.

3