This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
niota-docs:grid_edit [2022/01/09 12:56] admin |
niota-docs:grid_edit [2025/07/17 14:11] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== grid edit - user interface ====== | + | ====== Grid edit - user interface ====== |
| When successfully logged in you are usually linked to the grid editing dialog. How this dialog appears to you depends on how your local niota admin has configured the system. | When successfully logged in you are usually linked to the grid editing dialog. How this dialog appears to you depends on how your local niota admin has configured the system. | ||
| Line 18: | Line 18: | ||
| ===== Page layout ===== | ===== Page layout ===== | ||
| The page can be divided into three sections. From top to bottom: | The page can be divided into three sections. From top to bottom: | ||
| - | - Upper menu bar | + | * Upper menu bar |
| - | - Lower menu bar | + | * Lower menu bar |
| - | - Grid area | + | * Grid area |
| {{ :niota-docs:g_01_010_grid_area_overview_01.png?nolink |}} | {{ :niota-docs:g_01_010_grid_area_overview_01.png?nolink |}} | ||
| Line 35: | Line 35: | ||
| ==== Upper menu bar clickable icons ==== | ==== Upper menu bar clickable icons ==== | ||
| - | {{niota-docs:admin_area.png?nolink|}} **[[admin_pages | switch to admin pages]]**\\ | + | * {{niota-docs:admin_area.png?nolink|}} **[[grid_edit_upper_menu_bar | switch to admin pages]]**\\ |
| - | {{niota-docs:logout.png?nolink|}} **[[logout | log out]] **\\ | + | * {{niota-docs:logout.png?nolink|}} **[[grid_edit_upper_menu_bar | log out]] **\\ |
| - | {{niota-docs:user.png?nolink|}} **[[profile | change profile settings]]**\\ | + | * {{niota-docs:user.png?nolink|}} **[[grid_edit_upper_menu_bar | change profile settings]]**\\ |
| \\ | \\ | ||
| - | {{niota-docs:help_custom.png?nolink|}} **[[custom_help | custom help link]]**\\ | + | * {{niota-docs:help_custom.png?nolink|}} **[[grid_edit_upper_menu_bar | custom help link]]**\\ |
| - | {{niota-docs:help_system.png?nolink|}} **[[system_help | system help link]]**\\ | + | * {{niota-docs:help_system.png?nolink|}} **[[grid_edit_upper_menu_bar | system help link]]**\\ |
| \\ | \\ | ||
| \\ | \\ | ||
| Line 56: | Line 56: | ||
| * category filter - only the catalog instances of the selected category will be displayed in the grid selector (to create categories check the related admin feature: #LINK) | * category filter - only the catalog instances of the selected category will be displayed in the grid selector (to create categories check the related admin feature: #LINK) | ||
| \\ | \\ | ||
| - | * {{niota-docs:double_arrow.png?nolink|}} **[[toggle_selector | hide or display selectors]]**\\ | + | * {{niota-docs:double_arrow.png?nolink|}} **[[grid_edit_lower_menu_bar | hide or display selectors]]**\\ |
| - | * {{niota-docs:transactions.png?nolink|}} **[[transaction_menu | menu of available transaction]]**\\ | + | * {{niota-docs:transactions.png?nolink|}} **[[grid_edit_lower_menu_bar | menu of available transaction]]**\\ |
| \\ | \\ | ||
| \\ | \\ | ||
| Line 70: | Line 70: | ||
| Depending on your access authorities and the configuration of the table you may find this clickable icons in the grid area toolbar. | Depending on your access authorities and the configuration of the table you may find this clickable icons in the grid area toolbar. | ||
| - | {{niota-docs:import.png?nolink|}} **[[gridedit_excel_import | import from Excel sheet into database table]]**\\ | + | * {{niota-docs:import.png?nolink|}} **[[grid_edit_toolbar | import from Excel sheet into database table]]**\\ |
| - | {{niota-docs:excel_import_partial.png?nolink|}} **[[gridedit_excel_partial_import | replace/update table from Excel sheet]]**\\ | + | * {{niota-docs:excel_import_partial.png?nolink|}} **[[grid_edit_toolbar | replace/update table from Excel sheet]]**\\ |
| - | {{niota-docs:export.png?nolink|}} **[[gridedit_excel_download | export and download Excel sheet]]**\\ | + | * {{niota-docs:export.png?nolink|}} **[[grid_edit_toolbar | export and download Excel sheet]]**\\ |
| - | {{niota-docs:display_sp.png?nolink|}} **[[gridedit_callable | show callable objects (procedures)]]**\\ | + | * {{niota-docs:display_sp.png?nolink|}} **[[grid_edit_toolbar | show callable objects (procedures)]]**\\ |
| - | {{niota-docs:save_path.png|?nolink|}} **[[gridedit_favourite | set current grid as favourite]]**\\ | + | * {{niota-docs:save_path.png|?nolink|}} **[[grid_edit_toolbar | set current grid as favourite]]**\\ |
| - | {{niota-docs:reset_path.png|?nolink|}} **[[gridedit_favourite | reset favourite grid]]**\\ | + | * {{niota-docs:reset_path.png|?nolink|}} **[[grid_edit_toolbar | reset favourite grid]]**\\ |
| - | {{niota-docs:search.png?nolink|}} **[[gridedit_advancedfilter | reload table and prompt for selections]]**\\ | + | * {{niota-docs:search.png?nolink|}} **[[grid_edit_toolbar | reload table and prompt for selections]]**\\ |
| - | {{niota-docs:grid_validation.png?nolink|}} **[[gridedit_advancedfilter | validate table constraints and lookup]]**\\ | + | * {{niota-docs:grid_validation.png?nolink|}} **[[grid_edit_toolbar | validate table constraints and lookup]]**\\ |
| \\ | \\ | ||
| \\ | \\ | ||
| Line 85: | Line 84: | ||
| You can find edit features at the bottom of the grid. With additional configuration it can be displayed at the top of the grid too (as you can see on the picture upwards). | You can find edit features at the bottom of the grid. With additional configuration it can be displayed at the top of the grid too (as you can see on the picture upwards). | ||
| - | {{niota-docs:add.png|add row}} add row: inserts a new row into the grid (and the database table)\\ | + | * {{niota-docs:add.png|add row}} add row: inserts a new row into the grid (and the database table)\\ |
| - | {{niota-docs:edit.png|edit row}} edit row: edit the current row\\ | + | * {{niota-docs:edit.png|edit row}} edit row: edit the current row\\ |
| - | {{niota-docs:view.png|view row}} view row: opens the content of the row in a popup\\ | + | * {{niota-docs:view.png|view row}} view row: opens the content of the row in a popup\\ |
| - | {{niota-docs:delete.png|view row}} delete row: deletes the selected row(s)\\ | + | * {{niota-docs:delete.png|view row}} delete row: deletes the selected row(s)\\ |
| - | {{niota-docs:reload.png|reload grid}} reload grid: reloads the grid content\\ | + | * {{niota-docs:reload.png|reload grid}} reload grid: reloads the grid content\\ |
| - | {{niota-docs:search-grid.png|search}} search: opens the search input on the top of the columns\\ | + | * {{niota-docs:search-grid.png|search}} search: opens the search input on the top of the columns\\ |
| + | For special cases of "null" and empty string editing click here: | ||
| + | [[niota-docs:grid_edit_null_and_empty|Grid editing special cases]] | ||