QFQ Merge » History » Revision 11
Revision 10 (Enis Nuredini, 24.06.2024 14:33) → Revision 11/17 (Enis Nuredini, 24.06.2024 14:34)
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:300px}qfq_merge_rule_02.png!