Difference between revisions of "Combo (Filter)"

From TaticView
Jump to: navigation, search
 
(33 intermediate revisions by 5 users not shown)
Line 1: Line 1:
Implements a dinamic combo list that allows to filter objects data content in execution time according to selection.
+
<languages/>
  
  
To link the Combo (Filter) with the object(s):
+
<translate>
 +
<!--T:1-->
 +
[[File:mainmenu5.png]]
 +
'''Watch a [[Combo (Filter) Tutorial|video tutorial]] about the combo object'''.
  
* Select the Combo (Filter) object and left click the arrow icon (top right corner):
 
  
[[File:combo_filter1.png]]
+
<!--T:2-->
 +
Implements a dynamic combo list that allows to filtering objects data content in execution time according to selection. Supports content search.
  
  
* Drag the arrow over the desired object and left click it:
+
<!--T:29-->
 +
Filters and components (tables, charts, gauges, etc ...) are automatically connected when [[Adding an Object|added to the dashboard]].
  
[[File:combo_filter2.png]]
 
  
 +
<!--T:30-->
 +
To inhibit automatic connection of filters and components turn off the option in the settings.
  
* A arrow (link) will be show linking the Combo (Filter) to the data object.
 
  
 +
<!--T:36-->
 +
By default, arrows indicating the connections between components and filters are displayed only when the component is selected. In this case, the connections of this component are displayed. If you always want to display the indicative setar, just enable the ''Show arrows'' option in the design settings.
  
You can link the same Combo (Filter) to multiple data objects, allowing to filter all linked objects with the same data and at the same time.
 
  
 +
<!--T:31-->
 +
[[File:Enable auto filter en-US.png|link]]
  
[[File:combo_filter3.png]]
 
  
In this example, the Combo (Filter) object is loinked to the two data objects (table and chart), making both show the data only for the selected value: ''PIZZA''.
+
<!--T:32-->
 +
To connect the Combo (Filter) manually with the components:
  
 +
<!--T:5-->
 +
* Select the Combo (Filter) object and click the arrow icon (top right corner):
  
 +
<!--T:6-->
 +
[[File:Combo(Filtro) 1+en-US.PNG]]
  
'''Data Properties'''
 
  
[[Advanced row filter]], [[Filters]], [[Row limit]], [[Rows sort]]
+
<!--T:7-->
 +
* Drag the arrow over the desired object and click it:
  
 +
<!--T:8-->
 +
[[File:Combo(Filtro) 2+en-US.PNG]]
  
'''Title Bar Properties'''
 
  
[[Title bar Properties]]
+
<!--T:9-->
 +
* An arrow will be shown connecting the Combo (Filter) to the data object.
  
  
'''Layout Properties'''
+
<!--T:10-->
 +
You can connect the same Combo (Filter) to multiple data objects, allowing to filter all connected objects with the same data and at the same time.
  
[[Background color]],[[Border color]], [[Font]], [[Font color]], [[Font size]], [[Font style]], [[Object dimensions]], [[Text alignment]], [[X position]], [[Y position]]
+
<!--T:11-->
 +
To delete a connection click on the arrow and select the ''Remove Object(s)'' on the [[Design Options and Tools|top bar]] or press the delete key.
  
 +
<!--T:12-->
 +
You can also select the Combo (Filter) operation by clicking the drop-down arrow next to the combo title. You can select between:
 +
* Equal (=)
 +
* Different (≠)
 +
* Less than (<)
 +
* Greater than (>)
 +
* Less than or equal to (≤)
 +
* Greater than or equal to (≥)
  
'''Object Columns Properties'''
 
  
[[Column filters]], [[Column name]], [[Data type]], [[Mask]]
+
<!--T:38-->
 +
You can set a Initial content for Text Filters. If the content dosn't match no data will be retrieve.
 +
 
 +
<!--T:39-->
 +
[[File:Initial_content_en-US.PNG]]
 +
 
 +
 
 +
<!--T:37-->
 +
Text Combo filters support multiple selections. [[Combo_Filter_Selection|See how]]
 +
 
 +
 
 +
<!--T:13-->
 +
'''Example'''
 +
 
 +
<!--T:14-->
 +
[[File:Combo(Filtro) 3+en-US.PNG]]
 +
 
 +
<!--T:15-->
 +
In this example, the Combo (Filter) object is connected to the two data objects (table and chart), making both show the data only for the selected value: ''PIZZA''.
 +
 
 +
 
 +
<!--T:33-->
 +
Filters can also be connected hierarchically providing filtering of the contents of the next filter(s).
 +
 
 +
<!--T:34-->
 +
[[File:Filter hierarchical.PNG|link=]]
 +
 
 +
 
 +
<!--T:35-->
 +
Both forms are allowed simultaneously.
 +
 
 +
 
 +
<!--T:24-->
 +
See below all available properties for this object:
 +
 
 +
 
 +
<!--T:25-->
 +
* '''Data Properties''':
 +
** [[Object Filters|Filters]]
 +
** [[Rows sort|Rows Sort]]
 +
** [[Advanced row filter|Advanced Row Filter]]
 +
** [[Row limit|Row Limit]]
 +
 
 +
 
 +
<!--T:26-->
 +
* '''Title Bar Properties''':
 +
** [[Title bar Properties|Title Bar Properties]]
 +
 
 +
 
 +
<!--T:27-->
 +
* '''Layout Properties''':
 +
** [[Hide Border|Show Border]]
 +
** [[Border color|Border Color]]
 +
** [[Background color|Background Color]]
 +
** [[Font]]
 +
** [[Font color|Font Color]]
 +
** [[Font size|Font Size]]
 +
** [[Text alignment|Text Alignment]]
 +
** [[Font style|Font Style]]
 +
** [[Object positions|Object Positions]]
 +
** [[Object dimensions|Object Dimensions]]
 +
 
 +
 
 +
<!--T:28-->
 +
* '''Column Properties''':
 +
** [[Selected column]]
 +
** [[Column name]]
 +
** [[Data type|Data Type]]
 +
** [[Mask]]
 +
 
 +
</translate>

Latest revision as of 02:03, 5 October 2022

Other languages:
English • ‎português do Brasil


Mainmenu5.png Watch a video tutorial about the combo object.


Implements a dynamic combo list that allows to filtering objects data content in execution time according to selection. Supports content search.


Filters and components (tables, charts, gauges, etc ...) are automatically connected when added to the dashboard.


To inhibit automatic connection of filters and components turn off the option in the settings.


By default, arrows indicating the connections between components and filters are displayed only when the component is selected. In this case, the connections of this component are displayed. If you always want to display the indicative setar, just enable the Show arrows option in the design settings.


link


To connect the Combo (Filter) manually with the components:

  • Select the Combo (Filter) object and click the arrow icon (top right corner):

Combo(Filtro) 1+en-US.PNG


  • Drag the arrow over the desired object and click it:

Combo(Filtro) 2+en-US.PNG


  • An arrow will be shown connecting the Combo (Filter) to the data object.


You can connect the same Combo (Filter) to multiple data objects, allowing to filter all connected objects with the same data and at the same time.

To delete a connection click on the arrow and select the Remove Object(s) on the top bar or press the delete key.

You can also select the Combo (Filter) operation by clicking the drop-down arrow next to the combo title. You can select between:

  • Equal (=)
  • Different (≠)
  • Less than (<)
  • Greater than (>)
  • Less than or equal to (≤)
  • Greater than or equal to (≥)


You can set a Initial content for Text Filters. If the content dosn't match no data will be retrieve.

Initial content en-US.PNG


Text Combo filters support multiple selections. See how


Example

Combo(Filtro) 3+en-US.PNG

In this example, the Combo (Filter) object is connected to the two data objects (table and chart), making both show the data only for the selected value: PIZZA.


Filters can also be connected hierarchically providing filtering of the contents of the next filter(s).

Filter hierarchical.PNG


Both forms are allowed simultaneously.


See below all available properties for this object: