Embucket
query history filters
Add filters support into a Query History handlers
- Handler supports adding multiple filters in single request
- Applying multiple filters has a cumulative effect - filters combined.
Also search in worksheets by sql_text originally added in issue #434 looks the same as query filter by sql_text, adding it as a sub-issue.
Filters to be added, available in Query History accessible from worksheets Sql Text Filter - doing a full text search on sql text itself. if it heavily hits performance then maybe add some simplified implementation, so far full scan based. Duration filter - Greater than Query Id filter - Using Query ID (timestamp based) we expose somewhere in UI. Additionally decide what kind of query id we expose in UI - just a i64 number (as currently) or the same number encoded in BASE64 Query status filter: running, failed, successfull. Depends on issue
https://github.com/Embucket/embucket/issues/425
Extra filters for Query History outside of Worksheets + mentioned above
- Date range filter - explicitely defined date range - [begin : end]. It depends on sort order since filter can be applied only to items sorted in descnding order. Depends on issue #428 .
- Query type filter (statement types like: create, insert, select - investigate and update accordingly)
Here is a discussion on related issue: https://github.com/Embucket/embucket/issues/472
