This article answers common questions about query controls.
- Do query controls support conditional filters such as date dropdowns?
- Do query controls support fuzzy search?
- Can content in a query control be wrapped and center-aligned?
- If I use a query control to filter a field by the value 2, will a crosstab automatically display and aggregate data for ">2" and "<=2"?
- For a single-select or multi-select box, is the search limited to the 1,000 previewable items?
- Can I add more than two filter conditions?
- Why are there no values for the dynamic parameter condition in my query control?
- After setting a custom time range, can I modify the range by editing the original field?
- Can a composite query control use multiple data sources?
- Why does the query button in the query control sometimes appear and sometimes disappear?
- What should I do if a long field name is not fully displayed in a query control?
- Can a query control be styled as a dropdown?
- Does the time control support querying by year, month, day, hour, minute, and second?
- Do composite query controls support SQL dynamic parameters?
- Do query controls support keyword search?
- Can a single query control filter data from different data sources?
- Can I reorder tabs?
- Why do I get the "Querying contains null column, check the query model part" error when querying a dashboard?
- Why do I get the "Querying unknown pathId schema…" error when querying a dashboard?
- What types of conditional filters do query controls support?
Do query controls support conditional filters?
Yes. Query controls support conditional filters for time, text, and numeric data. For more information, see Query Type Configuration and Display.
Do query controls support fuzzy search?
Can content be wrapped and center-aligned?
Center alignment is supported. In the control style settings, you can set the content layout to left-aligned or centered.
Do crosstabs auto-aggregate filtered data?
No, this is not supported.
Is search in select boxes limited?
The dropdown list for a filter condition displays a maximum of 1,000 items. However, you can search through up to 10,000 items. Alternatively, you can manually enter a value to search for.
Can I add more than two filters?
You can add a maximum of two filter conditions. If you need more than two conditions, use a composite query control. For more information, see Composite query control.
Why are dynamic parameter conditions empty?
When using SQL parameters to filter a text field by enumeration, you must define the enumerated values in the parameter settings and then enter them manually.
Can I modify a custom time range?
If you set a dynamic query window of one month and then select a specific start or end time, the corresponding end or start time becomes uneditable. To query a different month, first clear the dates in the filter condition, and then select a new time range.
Can composite queries use multiple data sources?
No. A composite query control supports only datasets from a single data source, although it allows for multi-level nested AND/OR logic.
Why does the query button appear or disappear?
How to display long field names?
Can query controls be styled as dropdowns?
Time control query granularity
Yes. For more information, see Date Query.
Do composite queries support SQL dynamic parameters?
No.
Do query controls support keyword search?
Yes. You can enable keyword search by configuring a conditional filter in the query control.
Can one control filter multiple data sources?
Yes. For more information, see Create a new query control.
Can I reorder tabs?
"Querying contains null column" error
Cause: A dimension referenced in the dashboard was converted to a measure in the dataset.
Solution: Recreate the dashboard.
"Querying unknown pathId schema" error
Cause:
- A dimension referenced in the dashboard was converted to a measure in the dataset.
- A dimension or measure referenced in the dashboard was deleted from the dataset.
Solution: Revert the changes made to the dimensions or measures in the dataset.
Supported conditional filter types
Query controls support conditional filters for time, text, and numeric data. For more information, see Query Type Configuration and Display.