Project

General

Profile

Actions

Feature #8975

closed

Report Notation: 2.0 - `10.sql` wird ersetzt durch `<name>.sql` resp `<name> { ...` - Merge Request

Added by Carsten Rose over 4 years ago. Updated about 2 months ago.

Status:
Closed
Priority:
High
Assignee:
Carsten Rose
Target version:
Start date:
30.08.2019
Due date:
% Done:

0%

Estimated time:
Discuss:
Prio Planung:
No
Vote:

Description

  • Neu koennen die Zahlen in der Report Notation entfallen.
  • Alternativ koennen Bezeichner verwendet werden.
  • Das geparste Array wird nicht sortiert.
# Ohne Zahlen
{
  sql = SELECT ....
  {
    sql = SELECT ...
  }
}

# Mit Referenzen
person { 
  sql = ....
}

lecture { 
    sql = SELECT p.name, v.name
  stunden { 
    sql = SELECT ...
  }  
  PRINT {{stunden.id}}
}

PRINT {{person.name}} {{lecture.name}} {{lecture.stunden.titel}}

# Mit IF Statement
IF( {{form:SE}}=='' ) {
  person { 
    sql = ....
  }
} else {
    form = {{form:SE}}
}

#
# Option: Aufruf von PHP Funktionen via PRINT
# - Das QNL2BR im SELECT Statement ist nur da um den Status Quo zu zeigen.

news {
  sql = SELECT '...',  a.title, QNL2BR(a.title), '...' ...
  fbeg = <td>
  fend = </td>

  PRINT <td id="news_{{news.line.count}}">{{nl2br({{news.title:VR0}})}}</td>
}

# Wie unterscheidet QFQ bei '{{...}}' ob es sich um ein SQL Keyword, eine Variable, eine PHP Funktion handelt?
# - SQL ist eine definierte Liste, PHP Funktionen haben ein '(' ...')', alles andere sind Variablen


Related issues

Related to QFQ - Feature #8963: Setting values in a store: flexible wayPriorizeCarsten Rose29.08.2019

Actions
Related to QFQ - Feature #17251: Report Notation 2.0: Feature RequestsNewJan Haller08.11.2023

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

Actions
Actions #1

Updated by Carsten Rose over 4 years ago

  • Description updated (diff)
Actions #2

Updated by Carsten Rose over 4 years ago

  • Related to Feature #8963: Setting values in a store: flexible way added
Actions #3

Updated by Carsten Rose over 4 years ago

  • Tracker changed from Support to Feature
Actions #4

Updated by Carsten Rose over 4 years ago

  • Description updated (diff)
ME:
  • Vorschlaege sind ok
  • IF/THEN/ELSE: Implementierung scheint aufwendig zu sein.
  • Heute IF/THEN/ELSE, morgen LOOPs, uebermorgen ...
  • Nutzen von PHP Funktionen nicht klar.
Actions #5

Updated by Carsten Rose about 4 years ago

  • Status changed from New to Some day maybe
Actions #6

Updated by Carsten Rose about 4 years ago

  • Status changed from Some day maybe to New
Actions #7

Updated by Carsten Rose about 4 years ago

  • Assignee set to Carsten Rose
Actions #8

Updated by Carsten Rose about 4 years ago

  • Target version changed from 146 to 55
Actions #9

Updated by Carsten Rose about 4 years ago

  • Target version changed from 55 to next7
Actions #10

Updated by Jan Haller 12 months ago

  • File clipboard-202303230943-ovnjm.png added
  • Prio Planung set to No
Actions #11

Updated by Jan Haller 12 months ago

  • File deleted (clipboard-202303230943-ovnjm.png)
Actions #12

Updated by Carsten Rose 12 months ago

  • Subject changed from Report Notation: 2.0 to Report Notation: 2.0 - `10.sql` wird ersetzt durch `<name>.sql` resp `<name> { ...`
Actions #13

Updated by Carsten Rose 4 months ago

  • Subject changed from Report Notation: 2.0 - `10.sql` wird ersetzt durch `<name>.sql` resp `<name> { ...` to Report Notation: 2.0 - `10.sql` wird ersetzt durch `<name>.sql` resp `<name> { ...` - Merge Request
  • Priority changed from Normal to High
  • Target version changed from next7 to CodingWeek2023
Actions #14

Updated by Carsten Rose 4 months ago

  • Status changed from New to In Progress
Actions #15

Updated by Carsten Rose 4 months ago

  • Related to Feature #17251: Report Notation 2.0: Feature Requests added
Actions #16

Updated by Carsten Rose 4 months ago

  • Status changed from In Progress to Ready to sync (develop)
Actions #17

Updated by Carsten Rose 4 months ago

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

Updated by Carsten Rose about 2 months ago

  • Target version changed from CodingWeek2023 to 24.1.0.rc1
Actions #19

Updated by Carsten Rose about 2 months ago

  • Status changed from Ready to sync (develop) to Closed
Actions

Also available in: Atom PDF