Differences

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

--- niota-docs:niota_system_config_formatting [2022/01/22 15:14]
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\\
-''%conn_name%'' - connection name
+** ''%conn_name%'' ** - connection name of catalog object\\
-''%conn_disp_name%'' - connection display name
+** ''%conn_disp_name%'' ** - connection display name\\
-''%obj%'' - the catalog object name (table or view name)
+** ''%obj%'' ** - catalog object name (table or view name)\\
-''%desc%'' - description (not recommended, can be too long)
+** ''%desc%'' ** - catalog object 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>
@@ Line 113: / Line 116: @@
  define('SHOW_TABLE_SELECTOR_BY_DEFAULT',       true);
  define('DEFAULT_CATALOG_DISPLAY_TEXT_PATTERN', '%desc%');
- define('DEFAULT_CATALOG_ORDER_BY',             'g.conn_name, g.object, g.instance_name');
+ define('DEFAULT_CATALOG_ORDER_BY',             'conn_name, object, instance_name');
 </code>

niota

User Tools

Site Tools

Differences

Page Tools