Cannot use filter for Native Query

Business Apps Insights
1

Hi Insights Team,

I need to use native query to write complex sql and join some related tables. The native query run well but when adding to dashboard I cannot use filter. The filter cannot find column name of the query.
Please help me on this issue.

image
image1285×669 36.4 KB

Thanks
Dharma Han Nguye

2

Hi, @hanntd
The dashboard filters aren’t supported with native queries yet. It is planned to be supported though.

3

Thanks @nextchamp.saqib

4

Any timelines on when this will be available?

5

No specific timeline has been established yet. However, I can assist you in creating a specification that you can use to implement the feature on your own.

6

Hi @nextchamp.saqib , Can you please give some idea how can an individual do so?

7

Hi Insights Team,
Not sure that is it similar / different but I need to use script query to fetch data from api. The script query run well but when adding to dashboard I cannot use filter. The filter cannot find column name of the query.
Please help me on this issue.

8

Filters can be applied for Native Queries using this method:

  1. Enable Query Reusability in Insights settings
  2. Create a native query
  3. Create a visualised query with table as the native query
  4. Add this visual query to dashboard
  5. We can add filters to this visual query that inherits native query

Reference: https://x.com/FrappeInsights/status/1780543019206250977