QFQ Merge¶

• Table of contents
• QFQ Merge
  • Installation
    • SQL Function and Procedure
    • Grp Table

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:

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:
build_dynamic_columns.sql
auto_insert_merge_rules.sql

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: Grp.sql

In this table two records with following references should already exist:

• qfq_merge_rule
• qfq_merge_query