chart component : link parameter

[lovasoa]

feature suggestion by @SebastiendOrnano

Discussed in https://github.com/sqlpage/SQLPage/discussions/944

^{Originally posted by SebastiendOrnano June 24, 2025} Could it be possible to add a link parameter to the chart component ?

It is a common feature in most of Gantt chart apps since it gives a nice interactivity and a way to modify quickly data.

The link is accessible/clikable in the popup when passing over a bar. In the example below (based on example 9 in the Documentation), the idea would be able to open an edit form for the workpackage : workpackage_edit.sql?workpackage_name='||workpackage_name

SELECT 
    'chart'            AS component,
    'Workpackage Timeline' AS title,
    'rangeBar'         AS type,
    TRUE               AS time,
    'green'            AS color;

SELECT 
    w.workpackage_name                       AS series,
    w.workpackage_name  ||'    Planififié'    AS label,
    w.workpackage_date_start_scheduled        AS value,
    w.workpackage_date_end_scheduled          AS value
  FROM project_workpackage AS w
  left join (SELECT project_id FROM project) AS p
  on w.project_id=p.project_id
  WHERE p.project_id=$project_id::INTEGER
  ORDER BY w.workpackage_date_start_scheduled ASC;