Pages. How to add bread crumbs

How to add Breadcrumbs to a page (and how to add Title, Keywords, Description)

Creating a procedure named pg_crumbs_{pageCode}.

If the page is a child, the URL parameter itemID is passed to the stored procedure.

Examples of such stored procedures can be found in the pg_ prefix in the Data base.

In the second select in this procedure, you can assign additional parameters for the page SEO Title, Meta Keywords, Meta Description, and redirectUrl (if specified, the page will immediately redirect to this address).  

CREATE PROCEDURE [dbo].[pg_crumbs_Projects]
@roles nvarchar(128),
@itemID nvarchar(128) = ",
@urlParameters CRUDFilterParameter READONLY
declare @result TABLE (title nvarchar(256), link nvarchar(256), tooltip nvarchar(256), ord int)

insert into @result
select 'Home','/',", 1
select 'my account', '/home/p/customerCabinet',", 2
select 'project so-and-so',", ", 3

-- 1 SELECT data for bread crumbs
select * from @result order by ord

-- 2 SELECT advanced page settings
select 'documents' Title, "Description," Keywords, -- SEO Title, Description, keywords
"RedirectUrl -- if set, it will redirect to this address when you visit the page< / pre>

This procedure can be edited via the interface on the page editing page (the button on the right Breadcrumbs & Title).

Falcon Space is a functional web development platform on a narrow stack MS SQL/Bootstrap. Falcon Space Gettting started