Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
protogrid:tableview [2021-11-19 01:05] – druprotogrid:tableview [2021-12-21 22:48] (current) – [Display Client-Side Calculated Data as a Tableview] dru
Line 49: Line 49:
 Any number of dedicated Search Dialog Boxes (aka search masks) can be configured for a TableView. Any number of dedicated Search Dialog Boxes (aka search masks) can be configured for a TableView.
  
-Any number of Filter Fields can be assembled for a Search Dialog Box (each configured either as a filter or as a sorter). A maximum of two Tag Fields can be configured as filters per Search Dialog Box.+Any number of Filter Fields can be assembled for a Search Dialog Box (each configured either as a filter or as a sorter). Per target field only one Filter Field can be defined at a time. Note that a maximum of two Tag Fields can be configured as filters per Search Dialog Box. 
 + 
 +Unlike normal views, in Search Dialog Boxes users basically have to fill in/set all filters. An empty filter field in a Search Dialog Boxes means a filter for those Cards where the target field is also empty.
  
 Please note that depending on the number of affected Cards, it may take several minutes before a newly created or modified search dialog box can be used by the users. Please note that depending on the number of affected Cards, it may take several minutes before a newly created or modified search dialog box can be used by the users.
  
 ===== Display Client-Side Calculated Data as a Tableview ===== ===== Display Client-Side Calculated Data as a Tableview =====
-If the setting "Related Proto" on the TableView definition is left empty, Protogrid will not populate any data into the corresponding TableView. Instead, the TableView can be filled dynamically using Client-ScriptLibrary code.+If the setting "Related Proto" on the TableView definition is left empty, Protogrid will not populate any data into the corresponding TableView. Instead, the TableView can be filled dynamically using Client ScriptLibrary code.
  
 To implement this, the following three JavaScript function calls are available: To implement this, the following three JavaScript function calls are available:
Line 89: Line 91:
             "text": "Test Date Column Header Text",             "text": "Test Date Column Header Text",
             "display_priority": 8,             "display_priority": 8,
-            "is_sortable": true+            "is_sortable": true                               // Note that for correct sorting of dates, the cell values must be understood by Javascript's Date() object or comply with the following format: "DD.MM.YYYY( HH:mm(:ss))"
         },         },
         {         {
Line 152: Line 154:
             "test-text-column": "Miller",             "test-text-column": "Miller",
             "test-number-column": 4004,             "test-number-column": 4004,
-            "test-date-column": "2022-12-12T12:12:12",+            "test-date-column": "05.06.2023 01:02:03",
             "test-html-column": "<b>Explanation text</b>"             "test-html-column": "<b>Explanation text</b>"
         },         },
Line 159: Line 161:
             "test-text-column": "Smith",                 "test-text-column": "Smith",    
             "test-number-column": 3003,             "test-number-column": 3003,
-            "test-date-column": "2024-12-12T12:12:12",+            "test-date-column": "05.06.2024 01:02:03",
             "test-html-column": "<b>Explanation text</b>"             "test-html-column": "<b>Explanation text</b>"
         },         },
Line 166: Line 168:
             "test-text-column": "Williams",                 "test-text-column": "Williams",    
             "test-number-column": 2002,             "test-number-column": 2002,
-            "test-date-column": "2023-12-12T12:12:12",+            "test-date-column": "05.06.2025 01:02:03",
             "test-html-column": "<b>Explanation text</b>"             "test-html-column": "<b>Explanation text</b>"
         }         }
Line 172: Line 174:
     "test-number-column",     "test-number-column",
     false     false
-)</code>+);</code>
  
 ==== Update the Value of a Single Cell in a Client-Side Calculated TableView ==== ==== Update the Value of a Single Cell in a Client-Side Calculated TableView ====
-<code javascript>cell_update_client_side_computed_tableview(tableview_id, new_cell_value, row_identifier, column_identifier)</code>+<code javascript>cell_update_client_side_computed_tableview(tableview_id, new_cell_value, row_identifier, column_identifier);</code>
  
 This allows to update a single cell value in a client-side calculated TableView. The TableView has to already been initialized. The function parameters can be set as follows: This allows to update a single cell value in a client-side calculated TableView. The TableView has to already been initialized. The function parameters can be set as follows:
Line 186: Line 188:
 <code javascript>cell_update_client_side_computed_tableview( <code javascript>cell_update_client_side_computed_tableview(
     "6e67b170-d6d3-4786-87b8-8db3e17ea960",     "6e67b170-d6d3-4786-87b8-8db3e17ea960",
-    "Aaron Williams",+    "Aaron Miller",
     "replaced-first-data-row",     "replaced-first-data-row",
     "test-text-column"     "test-text-column"
-)</code>+);</code>

Trace:

Print/export