What keyboard shortcuts are available in SQL Criteria dialog of interactive filtering in Statistica Enterprise?
Article ID: KB0076879
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 10 and higher |
Description
A data configuration with Interactive filtering setup is a prerequisite. Refer to how Interactive filtering can be setup in article : https://support.tibco.com/s/article/Interactive-data-filtering-in-Statistica-Enterprise.
The article details keyboard shortcuts that are available in SQL Criteria dialog of interactive filtering in Statistica Enterprise
Issue/Introduction
What keyboard shortcuts are available in SQL Criteria dialog of interactive filtering in Statistica Enterprise?
Resolution
1. A user can double click on a SQL criteria to enable or disable the criteria. This would be equivalent of clicking on Enable / disable button in the SQL criteria button in Statistica 13.2 and higher versions.
2. Shift+Double click will toggle between AND and OR if there are multiple conditions added. For example, the below column cannot be Suite1 and Suite2 . To make the AND an OR. simply hold down shift key and double click.
3. Ctrl+Shift+ left click on ... button will display the SQL for filtering values in the interactive filter.
2. Shift+Double click will toggle between AND and OR if there are multiple conditions added. For example, the below column cannot be Suite1 and Suite2 . To make the AND an OR. simply hold down shift key and double click.
3. Ctrl+Shift+ left click on ... button will display the SQL for filtering values in the interactive filter.
Feedback
Yes
No
Powered by
