Cards

This is a separate table mode (card).
View an example of product cards.

For the card mode you need to do the following: 
  1. in SELECT 3 GetItems, set < b>ViewType= & rsquo; card & rsquo; and the card output type CardGroupType - deck, columns, group
  2. output card data in SELECT 1. 
Filters are applied to cards, as well as to other types of output.
DECLARE @result TABLE (id int, header nvarchar(512), footer nvarchar(512),
                       imgTop nvarchar(128), imgBottom nvarchar(128),
                       imgOverlay nvarchar(128), title nvarchar(512),
                       subtitle nvarchar(512), [text] nvarchar(max),
                       headerColor nvarchar(10), bgColor nvarchar(10),
                       cardClass nvarchar(10), link1 nvarchar(128),
                       linkUrl1 nvarchar(128), linkClass1 nvarchar(128),
                       link2 nvarchar(128), linkUrl2 nvarchar(128),
                       linkClass2 nvarchar(128), link3 nvarchar(128),
                       linkUrl3 nvarchar(128),
                       linkClass3 nvarchar(128))

INSERT INTO @result

SELECT TOP 20 id id, -- The element ID will be written in the card as data-itemID
           '' header,   -- card header block
           '' footer,  -- card basement block
           '/uploads/land/realty.jpg'  imgTop, -- output the image at the top
           '/uploads/land/finance.jpg' imgBottom,  -- output the image at the bottom
           '' imgOverlay,     -- background image for all cards
           'title 1' title,   -- title
           'subtitle 1' subtitle,   -- subtitle 
           'text 1' text,    -- basic layout of the card
           'primary' headerColor,  /* the color of the header and footer primary, warning,
                                              success, light, secondary. danger*/
           '' bgColor, /*фон карточки primary, warning, success,
                         light, secondary. danger*/
           '' cardClass, -- additional CSS classes for the card                 
           'link1' link1,  -- link text 1
           'url1' linkUrl1, -- link URL 1
           'class1' linkClass1, -- CSS link class 1
           'link2' link2, -- link text 2
           'url2' linkUrl2, -- link URL 1
           'class2' linkClass2, -- CSS link class 2
           'link3' link3, link text 3
           'url3' linkUrl3, -- link URL 1
           'class3' linkClass3 -- CSS link class 3
FROM as_trace
The request specifies all parameters that can be applied to cards. If this parameter is omitted, this part of the card is not output.
Falcon Space is a functional web development platform on a narrow stack MS SQL/Bootstrap. Falcon Space Gettting started
{sp-shortDemostandLinks}

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 on your own or collaborate with us on Falcon Space web development using only SQL and HTML.
See examples with SQL code
Platform documentation
Working on MS SQL Server
Note