How to run SQL inserts on startup?

[wsw70]

In #949 (comment) @tstack gave a concise solution to automatically insert SQL filters on lnav startup. Following this (as a complete beginner in lnav), I created a /root/.config/lnav/formats/installed/filter-journalctl.sql file⁽¹⁾ with

INSERT INTO lnav_view_filters (view_name, enabled, type, pattern) VALUES ('log', 0, 'OUT', 'Started Session');

The intent is to filter out messages such as

Aug 02 09:58:28 srv systemd[1]: Started Session 170062 of User root.

I then started lnav -e "journalctl -f" but the message is still there.

Is there anything else I should do to make this work?

---

⁽¹⁾ The path /root/.config/lnav/formats/installed/ was already there, created by lnav on its own

[tstack]

INSERT INTO lnav_view_filters (view_name, enabled, type, pattern) VALUES ('log', 0, 'OUT', 'Started Session');

I then started lnav -e "journalctl -f" but the message is still there.

The second column in the INSERT is enabled and it's set to 0, so it will be disabled by default. Change it to 1 to enable it all the time. Or, you can go into the filter UI panel and enable it there.