Differences

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

--- niota-docs:niota_system_config_formatting [2022/04/21 19:03]
admin
+++ niota-docs:niota_system_config_formatting [2025/07/17 14:11] (current)
@@ Line 77: / Line 77: @@
 == DEFAULT_CATALOG_DISPLAY_TEXT_PATTERN ==
-pattern and list of pattern-variables to build the table list (
+Pattern and list of pattern-variables to build the table list.
-== DEFAULT_CATALOG_ORDER_BY ==
+Available patterns that are replace by metadata content.
-Order-by clause of catalog list (SQL syntax qualified with ''g.'')
-pattern for combo box in main grid page
+** ''%cat_id%'' ** - catalog id\\
-''%cat_id%'' - catalog id\\
+** ''%inst_name%'' ** - instance name\\
-''%inst_name%'' - instance name\\
+** ''%inst_descr%'' ** - instance description\\
-''%inst_descr'' - instance description\\
+** ''%conn_name%'' ** - connection name of catalog object\\
-''%conn_name%'' - connection name\\
+** ''%conn_disp_name%'' ** - connection display name\\
-''%conn_disp_name%'' - connection display name\\
+** ''%obj%'' ** - catalog object name (table or view name)\\
-''%obj%'' - the catalog object name (table or view name)\\
+** ''%desc%'' ** - catalog object description (not recommended, can be too long)\\
-''%desc%'' - description (not recommended, can be too long)\\
+** ''%obj_cat%'' ** - object category\\
-''%obj_cat%'' - object category\\
+== DEFAULT_CATALOG_ORDER_BY ==
+Order-by clause of catalog list (SQL syntax - not qualified)
 <code>

niota