LogViewPlus Support » LogViewPlus Support » Features & Suggestions » Save SQL prompts

Save SQL prompts

Vankog — Thu, 23 Jan 2025 07:45:28 GMT

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
[code language="sql"]SELECT distinct session FROM CurrentView ORDER BY Timestamp DESC[/code]
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

RE: Save SQL prompts

Vankog — Thu, 23 Jan 2025 07:45:28 GMT

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

RE: Save SQL prompts

LogViewPlus Support — Wed, 22 Jan 2025 20:39:43 GMT

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