Shortcode WHERE clause in charts

  • Resolved johans

    (@johanselbing)


    3 weeks, 4 days ago

    Hello again, I have a pretty complex SQL query that I can only properly visualize with a Chart App of the type ‘Table’ and not with a Data Table App. This is because I have many levels of relationships, and I would like to ‘flatten’ the data into a combined table.

    Now I would like to filter some rows, but it seems like the WHERE clause with shortcodes (shortcodeParam) can only be used in Data App types? If I put it in the Chart App under Data Source, the app doesn’t load, and using ‘filter_field_name’ has no effect. Is there any other possibility to pass filters to Chart Apps, alternatively to use custom SQL queries in Data Table Apps?

    Thanks!

    • This topic was modified 3 weeks, 4 days ago by johans.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor Kim L

    (@kimmyx)

    Hi @johanselbing,

    Thanks for the post!

    Do you have a sample of the non-working SQL query you used in the Chart app? We’d like to test it out. ??

    You can create a view of your custom query and then use that view as the data source of your data table app.

    Here’s a short demo: https://share.zight.com/KouRxKQJ

    We’ll wait for your response! ??

    Thread Starter johans

    (@johanselbing)

    Thank you for the help! Creating a view and using it in a Data Table app solved the problem, so I don’t need to use the Chart.

    Plugin Contributor Kim L

    (@kimmyx)

    You’re welcome, @johanselbing! ??

    I’ll be closing this thread. Feel free to create a new one if you have new questions.

Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.