Save SQL prompts

Posted on Jan 22, 2025 at 11:02 AM
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
Posted on Jan 22, 2025 at 8:39 PM
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
Posted on Jan 23, 2025 at 7:45 AM
While writing the topic, I also grew unsure about the title, but I though: let's start small, but give the bigger use case.. :-)

This topic is closed and cannot receive new replies.