Save SQL prompts


Author
Message
Daniel M.
Daniel M.
New Member (43 reputation)New Member (43 reputation)New Member (43 reputation)New Member (43 reputation)New Member (43 reputation)New Member (43 reputation)New Member (43 reputation)New Member (43 reputation)New Member (43 reputation)
Group: Forum Members
Posts: 17, Visits: 44
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
Edited 6 Months Ago by Daniel M.
LogViewPlus Support
LogViewPlus Support
Supreme Being (12K reputation)Supreme Being (12K reputation)Supreme Being (12K reputation)Supreme Being (12K reputation)Supreme Being (12K reputation)Supreme Being (12K reputation)Supreme Being (12K reputation)Supreme Being (12K reputation)Supreme Being (12K reputation)
Group: Moderators
Posts: 1.2K, Visits: 4.3K
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
Edited 6 Months Ago by LogViewPlus Support
Daniel M.
Daniel M.
New Member (43 reputation)New Member (43 reputation)New Member (43 reputation)New Member (43 reputation)New Member (43 reputation)New Member (43 reputation)New Member (43 reputation)New Member (43 reputation)New Member (43 reputation)
Group: Forum Members
Posts: 17, Visits: 44
While writing the topic, I also grew unsure about the title, but I though: let's start small, but give the bigger use case.. :-)
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Login

Explore
Messages
Mentions
Search