Builds a UNION ALL SQL query across a list of tables retrieved from the database.
Registered as a process-text handler.
| Parameter | Description |
|---|---|
Param1 |
SQL fragment prepended to each table name (e.g. SELECT * FROM) |
Param2 |
SQL used to retrieve the list of table names via sql_get_list |
Param3 |
Optional SQL suffix appended to each sub-query (e.g. WHERE active = 1) |
Calls sql_get_list(Param2) to get a list of table names, then builds a UNION ALL query by joining "{Param1} {table}{Param3}" fragments. Database logging is disabled during execution.
Returns a UNION ALL SQL string ready for use in a query.
ObjProcessText(ObjData.ObjData) — inherits database and config access from ObjData.
cythonize -3 -a -i ObjTextQuerybuilder.py
Updated : 2025-10-02