Search/Filter Smart Cell (SQLite, but maybe other types)

[djgoku]

Unless I am missing something the Current page search on the SQL Query smart cell just highlights outputs. It would be awesome to be able to filter/search maybe even use FTS results in the output.

I can't tell if the Current page search is apart of Livebook or comes from Vegalite.

[josevalim]

Yes, as the name implies, it is only the current page. It is part of the table widget. Maybe you can use data transformation smart cell to filter fields containing a certain expression?

I also wonder if “highlight” is a better name. :)

[djgoku]

Oh, great that works!

Exqlite.query!(conn, "select * from dataset", [])
|> Explorer.DataFrame.new()

Then I just added a Data Transformation as you suggested.

[djgoku]

Thank you again. @josevalim is this worth documenting? If so where would I document it that would be useful for others?

[josevalim]

We should have an UI button for it, I added it here: livebook-dev/kino_explorer#94

[djgoku]

Thank you!