Project

General

Profile

Actions

Feature #17441

open

Report Notation 2.2: fireIf :Statement to trigger the root level query / fireSubIf : Statement to trigger the subquery

Added by Zhoujie Li 3 months ago. Updated 3 months ago.

Status:
In Progress
Priority:
Normal
Assignee:
Zhoujie Li
Target version:
Start date:
07.12.2023
Due date:
% Done:

0%

Estimated time:
Discuss:
Prio Planung:
No
Vote:

Description

Es wurde über mögliche Verbesserungen des if-Statements aus den Tickets #5345 und #17319 diskutiert. Wir kamen zu dem Vorschlag, dass mit 'fireIf' lediglich bestimmt wird, ob der Root-Level ausgeführt wird oder nicht. Das andere wäre 'fireSubIf', womit bestimmt wird, ob ein Subquery ausgeführt wird, auch wenn keine Records von der Root-Query kommen.

Vorschlag

Query-Ausführung für das Root-Level:

10  {
    sql = UPDATE table set ...

    fireIf = {{variable}} =|>|<|>=|<=|!= 

    altsql = SELECT ... (wird aus geführt wenn fireIf false ist)

}

Query-Ausführung für das Child-Level:

10  {
    sql = UPDATE table set ...

    fireSubIf = {{variable}} =|>|<|>=|<=|!= 

    20.sql = INSERT INTO ...

}

Related issues

Related to QFQ - Feature #5345: Report: UPDATE / INSERT / DELETE statements should trigger subqueries, depending on the result.In ProgressZhoujie Li03.02.2018

Actions
Related to QFQ - Feature #17319: Report Notation 2.1: 'if then else' / 'for' / 'while'NewQFQ Developer18.11.2023

Actions
Actions #1

Updated by Zhoujie Li 3 months ago

  • Related to Feature #5345: Report: UPDATE / INSERT / DELETE statements should trigger subqueries, depending on the result. added
Actions #2

Updated by Zhoujie Li 3 months ago

  • Related to Feature #17319: Report Notation 2.1: 'if then else' / 'for' / 'while' added
Actions #3

Updated by Zhoujie Li 3 months ago

  • Description updated (diff)
Actions #4

Updated by Zhoujie Li 3 months ago

  • Assignee changed from QFQ Developer to Zhoujie Li
Actions #5

Updated by Zhoujie Li 3 months ago

  • Status changed from New to In Progress
Actions #6

Updated by Zhoujie Li 3 months ago

  • Tracker changed from Support to Feature
Actions

Also available in: Atom PDF