F8270 more button for columns with long text AND add QBAR to for qfq | escape

extension/Documentation/Manual.rst

@@ -6470,6 +6470,40 @@ Example::
                     CONCAT('y|F:', p.pathFileName,'|t:File (link)|o:', p.pathFileName) AS _link
                 FROM Person AS p  
 
+
+.. _special-sql-functions:
+
+Special SQL Functions
+---------------------
+
+.. _qbar-qscape-qfq-delimiter:
+
+QBAR: Escape qfq Delimiter
+^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+The SQL function QBAR(text) replaces "|" with "\\|" in `text` to prevent conflicts with the qfq special column notation.
+
+Example::
+
+    10.sql = SELECT CONCAT('T:fileadmin/', QBAR(p.name), '.pdf') AS _thumbnail
+                FROM Person AS p  
+
+.. _qmore-truncate-long-text:
+
+QMORE: Truncate Long Text
+^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+The SQL function QMORE(text, n) truncates `text` if it is longer than `n` characters and adds a "more.." button. If the "more..."
+button is clicked, the whole text is displayed.
+
+Example::
+
+    10.sql = SELECT QMORE("This is a text which is longer than 10 characters", 10)
+
+Output:
+
+This is a `more..`
+
 .. _download:
 
 Download