MSSQL table component custom actions #1190
Description
Hello everyone,
i have a problem with tablet component and buttons with MSSQL.
When i write the code with custom actions buttons, the button are not shown on the table.
No errors are logged.
This is an example written from documentation Page:
select
'table' as component,
'/examples/show_variables.sql?action=edit&update_id={id' as edit_url,
'/examples/show_variables.sql?action=delete&delete_id={id' as delete_url,
JSON_OBJECT('name':'history','tooltip':'View Standard History','link':'/examples/show_variables.sql?action=history&standard_id={id}','icon':'as') as custom_actions;
select
'CalStd' as name,
'PharmaCo' as vendor,
'P1234' as Product,
'T23523' as 'lot number',
'Available' as status,
'2026-10-13' as 'expires on',
32 as _sqlpage_id,
JSON_OBJECT('name':'View PDF','tooltip':'View Presentation','link':'https://sql-page.com/pgconf/2024-sqlpage-badass.pdf','icon':'file-type-pdf') as _sqlpage_actions,
JSON_OBJECT('name':'Action','tooltip':'Set In Use','link':'/examples/show_variables.sql?action=set_in_use&standard_id=32','icon':'caret-right') as _sqlpage_actions;
select
'CalStd' as name,
'PharmaCo' as vendor,
'P1234' as Product,
'T2352' as 'lot number',
'In Use' as status,
'2026-10-14' as 'expires on',
33 as _sqlpage_id,
JSON_OBJECT('name':'View PDF','tooltip':'View Presentation','link':'https://sql-page.com/pgconf/2024-sqlpage-badass.pdf','icon':'file-type-pdf') as _sqlpage_actions,
JSON_OBJECT('name':'Action','tooltip':'Retire Standard','link':'/examples/show_variables.sql?action=retire&standard_id=33','icon':'test-pipe-off') as _sqlpage_actions;
select
'CalStd' as name,
'PharmaCo' as vendor,
'P1234' as Product,
'A123' as 'lot number',
'Discarded' as status,
'2026-09-30' as 'expires on',
31 as _sqlpage_id,
JSON_OBJECT('name':'View PDF','tooltip':'View Presentation','link':'https://sql-page.com/pgconf/2024-sqlpage-badass.pdf','icon':'file-type-pdf') as _sqlpage_actions,
JSON_OBJECT('name':'Action') as _sqlpage_actions;
The result Is a Page without the custom actions.
Anyone can help me?
Thank you.
- OS: WS2022
- Database: Mssql 2022 Std
- Versione: 0.41.0