Component Tracking and recursive layout #313
-
Beta Was this translation helpful? Give feedback.
Replies: 2 comments 1 reply
-
Hi @DSMejantel ! I see you are pushing SQLPage to the edge of its capabilities. The problem in the code you are giving above is that the component selections are not at the right place. You are doing select 'dynamic' as component,
'[' ||
json_object(
'component', 'tracking',
'title', 'y=' || y
) || ',' ||
group_concat(json_object(
'title', 'x=' || x
)) ||
']' as properties
from t GROUP BY y ORDER BY y; |
Beta Was this translation helpful? Give feedback.
-
Hi, select 'dynamic' as component,
'[' ||
json_object(
'component', 'tracking',
'title', 'Rangée ' || rang,
'width', 4
) || ',' ||
group_concat(json_object(
'title', 'Ruche '||numero,
'color', case tracing when 3 then 'red' when 2 then 'orange' else 'green' end
)) ||
']' as properties
from colonie WHERE colonie.rucher_id=$id and disparition::int<>1 and $tab='1' GROUP BY rang ORDER BY rang; |
Beta Was this translation helpful? Give feedback.
Hi,
Dynamic component is magic ! Just like you ! Thanks.