Dojo,
I am not able to pass a Table variable as data to a Query filter component. Am I missing something ?
DMA: 10.5.3.
#Kata 58.
The query filter component only supports queries as data, not tables. Tables could be a result from a query but are not the query themselves. Just like you can't feed the selected items from a table visualization to the query filter, you won't be able to link a table variable to the query filter.
The query filter its main output is a new query that contains extra filter nodes, when dealing with table variables, there's no query involved, so the query filter won't be able to expose a query. If you want to create filters for the table, you can create individual dropdown components which do support tables as data.
There isn’t really a distinction between table data from a variable and table data from a query. However, there is a distinction between a query and table data.
– A query consists of a data source followed by a series of operators.
– A table is simply structured data with rows and columns.
Some visualizations support both queries and tables. When given a query, they execute it and visualize the resulting table, just as they would if they received the table directly.
The query filter visualization is unique because it supports queries without executing them. Instead, it modifies the query by adding extra filter nodes. The filtered query can then be passed to a table visualization, which executes it to display the filtered results.
In short, the query filter component is a filtering step between the original query and the visualization that displays the final content. So, it wouldn't know what to do with an actual table as data.
Thanks for further expatiating on this. I understand it much better.
Thanks for the explanation Gilles. One of the advantages of variables that stood out from the Kata was the ability to replace ad hoc data sources that fetched static data. I was eager to try this but I understand better now the distinction between table data and table data that are as a result of queries.