How to make Table Row Links

[nofue]

There's this table:

select 'table'             as component
     , 'Efforts'           as title
     , 'true'              as hover
     , 'Keine Einträge…'   as empty_description
     ,	'Edit' as markdown
;
-- Table-Rows
select  effort_date,
        effort_time,
        kind_term   as "Art",
        result_term as "Ergebnis",
        note        as "Notiz",
        '[✏️](prospects.sql?prospect_id=' || $prospect_id::text || '&effort_id=' || effort_id || '#effort_edit_modal)' as "Edit"
from app_api.get_efforts_extended($prospect_id::int, 0, null, 0, true);

Notice the line as "Edit"
This is meant to fire a modal which will hold the form to edit the row's content.
The code to fire the modal is this:

-- Modal Dialog / edit effort
select 
    'modal'              as component,
    'effort_edit_modal'  as id,
    'Effort bearbeiten'  as title,
    true                 as large,
    '/prospects_effort_cu.sql?_sqlpage_embed&prospect_id=' || $prospect_id::text || '&effort_id=' || coalesce($effort_id::text,'') as embed;

but it doesn't get triggered. Both snippets live in a file prospects.sql and when the "Edit-Pen" has been clicked, prospect.sql reloads with this URL:
http://localhost:8080/prospects.sql?prospect_id=100&effort_id=2559#effort_edit_modal

I shifted everything around several times, but never succeeded to trigger the modal. Using a simple button worked, but it seems button as component won't work for a table column… 

What am I missing here?

[lovasoa]

Hi ! The current implementation of the modal component does not allow doing what you are trying to do. It requires opening using the button component, or manually by writing your own javascript .

[nofue]

Do you have any source of a working solution?

[nofue]

Follow up for all who are in need -- this finally works

select
    'table' as component,
    'Efforts' as title,
    true     as hover,
    'No entries…' as empty_description,
    'Action' as markdown;  -- WATCH THIS NAME

-- Table Rows
select
    [all your columns go here ] 
    -- Markdown-Link for the modal
    case when ef.editable -- checking for a field which returns true/false whether the field is editable
         then '[✏️](/prospects_effort_cu.sql?prospect_id='              -- bonus tip below
              || $prospect_id::text           
              || '&effort_id='
              || ef.effort_id::text
              || ')'
         else '' -- all other fields aren't allowed an edit-action 
    end as "Action"   -- MUST BE THE SAME AS 'markdown' above
from app_api.get_efforts_extended_editable($prospect_id::int,0,null,0,true) ef; -- put your query here

Screenshot

prospects_effort_cu.sql is the file which gets opened by clicking the button

Bonus Tip: If you ever wondered where these fancy icons come from, these are HTML emojis you'll find in lots of fonts. Just google "HTML Emojis" and enjoy (using lesser space) ;)