Variable transactionNameColumnsDdlConst
transactionNameColumnsDdl: {
bankName: "CASE WHEN \"arm\".\"bank_id\" IS NOT NULL THEN COALESCE(\"arm\".\"bank_name\", (SELECT string_agg(upper(left(p.part, 1)) || substr(p.part, 2), ' ' ORDER BY p.ord) FROM regexp_split_to_table(\"arm\".\"bank_id\", '[\\s_-]+') WITH ORDINALITY AS p(part, ord) WHERE p.part <> '')) END AS \"bank_name\"";
customerName: "COALESCE(\"arm\".\"customer_name\", \"arm\".\"customer_id\") AS \"customer_name\"";
entityName: "COALESCE(\"arm\".\"entity_name\", \"arm\".\"entity_id\") AS \"entity_name\"";
} = ...
Type Declaration
-
ReadonlybankName: "CASE WHEN \"arm\".\"bank_id\" IS NOT NULL THEN COALESCE(\"arm\".\"bank_name\", (SELECT string_agg(upper(left(p.part, 1)) || substr(p.part, 2), ' ' ORDER BY p.ord) FROM regexp_split_to_table(\"arm\".\"bank_id\", '[\\s_-]+') WITH ORDINALITY AS p(part, ord) WHERE p.part <> '')) END AS \"bank_name\""
-
ReadonlycustomerName: "COALESCE(\"arm\".\"customer_name\", \"arm\".\"customer_id\") AS \"customer_name\""
-
ReadonlyentityName: "COALESCE(\"arm\".\"entity_name\", \"arm\".\"entity_id\") AS \"entity_name\""
The name columns' wrapper expressions: filled in the wrapper, so the arm bodies' own text (
counterparty_description,search_text) keeps reading the real name.