Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Issues with Query mode filters #222

Open
dcdamien opened this issue Jan 15, 2025 · 0 comments
Open

Issues with Query mode filters #222

dcdamien opened this issue Jan 15, 2025 · 0 comments

Comments

@dcdamien
Copy link

dcdamien commented Jan 15, 2025

I have a table with 3 columns: key, summary, and reporter_display_name:

image

There is Query mode filtering set on summary. The datasource is Postgres.
The variable used for filtering is summaryFilter of type Textbox, with no default value:

image

The query is:

select
  key,
  summary,
  reporter_display_name
from
  jira_dwh.select()
where
  "summary" like '%${summaryFilter}%'

The column is set as below:

image

In general filtering works - variable value is set and resultset is filtered:

image

But..

Issue 1.

After entering search term that returns 0 rows, table headers disappear. Please note that the variable is intended to be not visible on the dashboard and I expect that user should be able to clear the filter on column level:

image

Expected behaviour is all columns specified in the layout should be visibile regardless of query result.

Issue 2.

Clicking the Clear button on the column clears the Search term but underlaying variable value stays untouched resulting in executing query with filter still set:

image

Expected behaviour is underlaying variable value should be cleared after clicking Clear on filtered column and query should be executed with empty variable.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant