Project

General

Profile

Actions

Bug #11195

open

Dynamic Update: Note not updated if new text is empty (v20.4)

Added by Nicola Chiapolini over 3 years ago.

Status:
New
Priority:
Low
Assignee:
-
Target version:
Start date:
25.09.2020
Due date:
% Done:

0%

Estimated time:
Discuss:
Prio Planung:
Vote:

Description

We had a dynamic updated note-Element with value

#!report
10.sql = SELECT notes FROM rooms WHERE building = '{{building:FSRD:alnumx}}' AND room = '{{room:FSRD:alnumx}}'
10.twig = {{ result.0.notes }}

The note-Element is not updated, if the notes is empty or the query does not return a row.
The following code works:

#!report
10.sql = SELECT notes, RAND() AS dummy FROM rooms WHERE building = '{{building:FSRD:alnumx}}' AND room = '{{room:FSRD:alnumx}}'
10.twig = <span>{{ result.0.notes }}</span>

(Since we only update via T3 Extension store, we are still running 20.4 so this might be fixed by now.)

No data to display

Actions

Also available in: Atom PDF