QFQ Merge » History » Revision 10
Revision 9 (Enis Nuredini, 24.06.2024 14:33) → Revision 10/17 (Enis Nuredini, 24.06.2024 14:33)
h1. QFQ Merge {{toc}} h2. Installation QFQ Merge feature should be installed automatically with new QFQ Version 24.3.x If the automatic upgrade wasnt successful, here are some important points: h3. SQL Function and Procedure QFQ should deliver one sql function and one procedure called: * build_dynamic_columns * auto_insert_merge_rules If one of these is missing then take these SQL statement to import it: attachment:build_dynamic_columns.sql attachment:auto_insert_merge_rules.sql h3. Grp Table Check if the table 'Grp' exists in database. Table should have following columns: * id * grId * name * reference * value * value2 * value3 * value4 * comment * enabled * modified * created SQL structure: attachment:Grp.sql In this table two records with following references should already exist: * qfq_merge_rule * qfq_merge_query SQL Merge Records: attachment:Grp_merge_data.sql h3. QFQ Merge Page Create for the merge tool a new page in Typo3 backend if not already done. Create a new qfq tt-content on that page with following content (http://docs.qfq.io/en/master/Report.html#merge-tool): <pre> file=_mergeData </pre> h2. Configuration h3. New Rules Let's trigger the automation to create some new rules depending on a beginning pId column name: !{width:300px}qfq_merge_rule_01.png! !{width:200px}qfq_merge_rule_01.png!