LogViewPlus Support

Save SQL prompts

https://www.logviewplus.com/forum/Topic2325.aspx

By Vankog - 22 Jan 2025

In my analysis efforts, I very often drill down to particular session IDs to analyse the flow of events for affected users etc.
For this I use the SQL scratchpad with
SELECT distinct session FROM CurrentView ORDER BY Timestamp DESC

Then I switch to text results and copy each result entry.
Then I create a text filter on the session column with these values via regex.

While this is already quite cumbersome and I'd really like to get something like this out of the box, I think one minor improvement would already be, so save the SQL statements.

Thanks for considering this.
Best regards,
Daniel
By LogViewPlus Support - 22 Jan 2025

Thanks for the suggestion Daniel.

I think the ability to create multiple text filters at the same time is a great idea!  I am not sure how we will do it, and as a first draft it is unlikely we will be able to go from SQL statement to filter creation.  Let me investigate and see what we can do.

> save the SQL statements

That's also a really good idea!  Again, I will need to have a think about the best way to implement this.  From your subject line it looks like this is the main feature you are looking for.

Thanks again!

Toby
By Vankog - 23 Jan 2025

While writing the topic, I also grew unsure about the title, but I though: let's start small, but give the bigger use case.. :-)