QFQ

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:500px}qfq_merge_rule_01.png!