How to get the current page

[lukavia]

I'm trying to a navigation to my app. Going through the docs and examples it seams the most elegant solution is to create a table with the entries and then use tab component.

select 'tab' as component;
select title, file as link from nav; 

However I would like the current page to be active so I want to add a column like IF(sqlpage.url = file, true, false) as active

My question is how to get the current page (sqlpage.url if you will) ?

Thank you

[lovasoa]

Hello and welcome to SQLPage !

This is not yet implemented, but I created an issue here: #114

For the time being, you'll just have to duplicate in each page

select title, file as link, file='/my_page_xxx.sql' as active from nav; 

side note : IF(sqlpage.url = file, true, false) can be expressed as simply sqlpage.url = file

[lukavia]

Thank you very much.
In the meanwhile I've currently narrowed it down to one simple table:

CREATE TABLE nav(page VARCHAR(20));
INSERT INTO nav VALUES('transactions'),('accounts'),('this month');

And then one can use:

SELECT 'shell' as component, 'Transactions' as title, json_group_array(page) as menu_item from nav;

or

SELECT 'tab' as component;
SELECT page as title, page || '.sql' as link, (page = 'transactions') as active from nav; 

And then change only the string on each page.

[lovasoa]

I added sqlpage.path(), it will be released in v0.15 🙂