Actions
Bug #11195
openDynamic Update: Note not updated if new text is empty (v20.4)
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