Cards
This is a separate table mode (card).
View an example of product cards.
For the card mode you need to do the following:
-
in SELECT 3 GetItems, set < b>ViewType= & rsquo; card & rsquo; and the card output type CardGroupType - deck, columns, group
-
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
- Management
- Falcon Space Foundation
- Basic components Falcon Space. Working with tables Falcon Space. Working with forms Falcon Space. Working with dashboards Falcon Space. Working with resources Falcon Space. Working with entities Falcon Space. Business processes Falcon Space. Generating Docx and Xlsx documents Falcon Space. Working with trees (hierarchy) Working with HTML blocks External actions (notifications, push, email, API call) Diagrams and Graphs Interactive tree Gantt Chart The Kanban Board Chartbar diagram Map with markers Cards Progress line Timeline The calendar Data output in the form of a graph on the site Output of the request movement by statusbar statuses Terminal - workspace with windows and tabs Вывод точек на карте Яндекс. Интеграция с Яндекс Карты
- Falcon Space Features
- Subsystems
- Additional component
- Integrations
- HOWTO
- HOWTO Tables
- HOWTO Forms
- Working with SQL
- HOWTO JS
- HOWTO CSS
- HOWTO Layout
- Solve problems
SQL-tool for creating personal accounts on the site
The essence of the approach and the history of the creation of Falcon Space

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

Note
- Falcon Space Video
- Platform features demo will allow you to understand how this or that component looks and works
- Have a question? Write to the chat at the bottom right