Mark search results

[deepskyblue86]

Is there a way to mark search hits? I can't find it in the guide.
My use case is viewing the time between some events, leveraging T.

[tstack]

There's no builtin command or hotkey to perform this, but you can get there using the SQL interface. By doing an UPDATE on a log table and setting the log_mark column to 1, it will mark the log message. So, to mark all the log messages that match the current view's search term, you can execute the following SQL statement:

;UPDATE all_logs SET log_mark=1 WHERE log_text REGEXP (SELECT '(?i)' || search FROM lnav_top_view)

You can put this statement in a script and then execute it by using the | hotkey to enter the script prompt and then type in the script name.

To bind this statement to a hotkey (ex: underscore), you can run the following:

:config /ui/keymap-defs/default/x5f/command ;UPDATE all_logs SET log_mark=1 WHERE log_text REGEXP (SELECT '(?i)' || search FROM lnav_top_view)

(Note that the x5f above is the hex ASCII code for underscore.)

Of course, you can also customize the SQL statement to add more conditionals or directly write in the search terms.

[deepskyblue86]

Thank you, that's amazing. Can we have this in the FAQ? 😁

[piotr-dobrogost]

What view are we talking about here?
In the "normal" view all search results are marked in the left column.

[deepskyblue86]

@piotr-dobrogost in the "normal" view I don't have any column...
Anyway by "marked" I didn't mean highlighted, I meant as per m command, also called bookmark in the help page.