modal component + custom_actions

[SebastiendOrnano]

I am not familiar with modal boxes and I am stuck with a basic problem : how to pass correctly a variable from a table to the iframe ?
I have a forum where the users can attached document (local ou online) to a post. I have table to show all the post with an custom_actions icon to open a window to show the document or documents attached to the post :

The modal and the table components are :

select 
    'modal'                  as component,
    'my_embed_table_modal2'  as id,
    'Documents attachés'     as title,
    'Close'                  as close,
    TRUE                     as large,
    '/e_project_forum/project_forum_doc_attach_table_4.sql?project_forum_message_id={id}' as embed;

SELECT 
    'table'                      AS component, 
    'View'                       AS markdown,
    TRUE                         AS sort,
    '/e_project_forum/project_forum_message_edit_4.sql?project_forum_message_id={id}' as edit_url,
    '/e_project_forum/project_forum_message_delete_0.sql?project_forum_message_id={id}' as delete_url,
    JSON('{"name":"Close","tooltip":"Fermer la discussion","link":"/c_workspaces/workforum_topic_close_0.sql?topic_id={id}","icon":"lock"}') as custom_actions, 
    JSON('{"name":"doc","tooltip":"Documents attachés","link":"#my_embed_table_modal2","icon":"book"}') as custom_actions,
    TRUE                         AS search;

SELECT
    project_forum_message_id             AS id,
    project_forum_message_id             AS _sqlpage_id,
    to_char(created_at AT TIME ZONE 'Europe/Paris', 'YYYY-MM-DD HH24:MI')             AS           Posted_At,
    (SELECT users.username FROM users WHERE users.user_id = project_forum_message_author_id::INTEGER )  AS Author,
    project_forum_message_status         AS Statut,
    project_forum_message_content        AS Message
FROM project_forum_messages
WHERE project_forum_topic_id = $project_forum_topic_id::INTEGER AND project_forum_message_rank!='main' AND project_forum_message_status='active'
ORDER BY created_at ASC;

and the file project_forum_doc_attach_table_4.sql :

SELECT 'table' AS component, 
    'Liste des documents'   AS title,
    'Titre'           AS markdown;

SELECT
    project_doc_id        AS Id,
    CASE 
    WHEN project_doc_local_cloud='local' THEN '['||project_doc_title||']('||project_doc_url||')' 
    WHEN project_doc_local_cloud='cloud' THEN '['||project_doc_title_link||']('||project_doc_cloud_url||')' 
    END   AS Titre,
    project_doc_category             AS Categorie,
    CASE 
    WHEN project_doc_local_cloud='local' THEN project_doc_format   
    WHEN project_doc_local_cloud='cloud' THEN project_doc_cloud_format  
    END                              AS Format,
    project_doc_type               AS Type,
    project_doc_local_cloud                AS LocalCloud
FROM project_docs
WHERE project_forum_message_id = $project_forum_message_id::INTEGER
ORDER BY created_at DESC;

any help is welcome and thanks in advance !

[lovasoa]

'id={id}' as embed is not supported. Currently there is no other way than creating one modal per line in your table.

[SebastiendOrnano]

I found a way to use the modal component with dynamic url, but I added to customize first the table component to introduce a new _sqlpage_modal_actions and then a customized modal component to produce the iframe with a dynamic url based on the {id}.

More explanation and links to the custom components can be found here