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

SQL-tool for creating personal accounts on the site

The essence of the approach and the history of the creation of Falcon Space
Web platform for creating personal accounts

Falcon Space Platform

This is a reduction in the cost of ownership

at the expense of fewer people to support

This is a quick change

while using the program

This is a modern interface

full adaptation for mobile devices

MS SQL web applications. Affiliate program for developers and web studios

You can develop yourself or collaborate with us for web development on the Falcon Space platform using only SQL and HTML.
View examples with SQL code
Platform documentation
Working on MS SQL Server