Visual extra

Package name: visual

Visual: Target gauge Total
Show lifetime performance speedometer 

 Properties 

 

 Type: Visual extra 

 Groupable: No 

 Show in lists: No 

 Searchable: No 

 

 User interface 

 Field in show mode 

 

 Due to its nature this field has no special editing mode. 

 Configuration 

 This field does not need deployment (no ekstra database fields required). 

 No configuration required for this field type 

 Developer info 

 

 FeltTypeID: 810 

 SQL datatype: N/A 

 Class name: FieldGaugePerformance

Visual: Target gauge Step
Show performance speedometer for this step 

 Properties 

 

 Type: Visual extra 

 Groupable: No 

 Show in lists: No 

 Searchable: No 

 

 User interface 

 Field in show mode 

 

 Due to its nature this field has no special editing mode. 

 Configuration 

 This field does not need deployment (no ekstra database fields required). 

 No configuration required for this field type 

 Developer info 

 

 FeltTypeID: 811 

 SQL datatype: N/A 

 Class name: FieldGaugePerformanceStep

Canvas: Freehand
Draw, freehand, in a canvas 

 Properties 

 

 Type: Visual extra 

 Groupable: [YES/NO] 

 Show in lists: [YES/NO] 

 Searchable: [YES/NO] 

 

 User interface 

 Field in show mode 

 [INSERT IMAGE] 

 Field in edit mode 

 [INSERT IMAGE] 

 Configuration 

 [INSERT IMAGE] 

 [Description of configs] 

 Developer info 

 

 FeltTypeID: 812 

 SQL datatype: MEDIUMTEXT 

 Class name: FieldCanvasDrawing

Canvas: Marking
Mark a spot on an image 

 Properties 

 

 Type: Visual extra 

 Groupable: [YES/NO] 

 Show in lists: [YES/NO] 

 Searchable: [YES/NO] 

 

 User interface 

 Field in show mode 

 [INSERT IMAGE] 

 Field in edit mode 

 [INSERT IMAGE] 

 Configuration 

 [INSERT IMAGE] 

 [Description of configs] 

 Developer info 

 

 FeltTypeID: 813 

 SQL datatype: TINYTEXT 

 Class name: FieldCanvasMarking

Sliderbar
Numbers with decimal comma using a sliderbar for input 

 Properties 

 

 Type: Visual extra 

 Groupable: No 

 Show in lists: Yes 

 Searchable: Yes 

 Requires configuration: [Yes/no] 

 

 User interface 

 Field in show mode 

 

 Field in edit mode 

 

 Configuration 

 

 Required: 

 

 Minimal value 

 Maximum value 

 

 Options: 

 

 Making the slider display vertically

 

 orientation: "vertical", 

 

 

 Using steps i the slider

 

 step: 10, 

 

 

 JSON configuration notes:  [1] 

 

 Developer info 

 

 FeltTypeID: 911 

 SQL datatype: DECIMAL(20,6) 

 Class name: FieldSliderBarDecimal

SQL: Diagram query
Shows an sql-query as a graph, just like the  dashboard widget , with the same configs as the  sql-subselect field . 

 Properties 

 

 Type: Visual extra 

 Groupable: No 

 Show in lists: No 

 Searchable: No 

 Requires configuration: Yes 

 

 User interface 

 Field in show mode, when rendering a line-chart. 

 

 Due to its nature this field has no special editing mode. 

 Configuration 

 [INSERT IMAGE] 

 Either, write an sql-query that fetches the exact data to be shown, as described here. 

 Or, write a simple sql-query that fetches the lines of data and select render-mode "Parse listed data". 

 Select a graph type, remember that the expected structure of the data is different for circle- and xy-graphs. 

 Parse listed data 

 This option parses the given data in the following way. 

 

 Column 1 will be used as x-axis values. 

 Column 2 will be used for datasets in the graph. 

 Column 3 will be used for y-axis values. 

 

 Example 

 This is data generated by the query:  SELECT DATE, CATEGORY, AMOUNT FROM data_demoentity ORDER BY DATE ASC 

 

 

 

 Date 

 Category 

 Amount 

 

 

 01/01/2024 

 Category 1 

 10 

 

 

 01/01/2024 

 Category 2 

 0 

 

 

 01/01/2024 

 Category 3 

 15 

 

 

 01/02/2024 

 Category 1 

 20 

 

 

 01/03/2024 

 Category 2 

 20 

 

 

 01/04/2024 

 Category 1 

 30 

 

 

 01/04/2024 

 Category 2 

 10 

 

 

 01/04/2024 

 Category 3 

 15 

 

 

 

 This will be transformed to this, when rendering an xy-graph. 

 

 

 

 Title 

 Category 1 

 Category 2 

 Category 3 

 

 

 01/01/2024 

 10 

 0 

 15 

 

 

 01/02/2024 

 20 

   

   

 

 

 01/03/2024 

   

 20 

   

 

 

 01/04/2024 

 30 

 10 

 15 

 

 

 

 Developer info 

 

 FeltTypeID: 530 

 SQL datatype: N/A 

 Class name: FieldSubselectDiagram