1) Interaction between filters from different tables doesn't seem to work.
In my SQL query, I have data from sales quotes with a link no the customer table.
I have one filter on the customer ID from the sales quotes table and another filter on the customer full name from the customer table.
In the dashboard, filtering on some customer IDs has no impact on the customer names filter in which I still have the full list of customer names.
My filters are however well linked in the dashboard and the tables are well linked in the SQL query.
Is it possible to make filters based on fields from different tables interact?
2) Filter with limited values
In the same example as above, I also get the sales quotes status names from a another table. Again, filters are linked and the tables are linked in the SQL query.
My problem is that, in the status table, I have status names of all document types (quotes, orders, deliveries, ...). I consequently have a restrection in my SQL Query to focus on quotes status but it has no impact on the filter. Is that possible to limit values from a field in the filter?
Thank you for your answer. This solves my first problem !
For the second problem, it does not change anything.
My problem is that, the list of values in filters coming from linked tables is not pre-filtered with only values related to my main table.
Ex : In my quotes dashboard, I have filters on data from the customer table. This table is well linked in my query. However, in the filter, I have by default the complete list of all existing customers and not the customers who received quotes.
Is there a way to pre-filter/limit values in a filter?
@MarieG All the issues I've linked to, if they are "Open" (see the big green label below the issue title), then the issue has not been resolved (fixed/implemented). Upvote issues by clicking on the first post of each issue you're interested in. I cannot provide timelines for any issues.