This is one of the table component modes.
An example of how the component works is resource load tracking.
Displays the table as chartbar bars.
To display chartbar, you must do the following:
Create a table with the columns id (PK),title, ord. These are the statuses of elements displayed at the top of the Kanban Board.
in SELECT 1 in GetItems select this table
declare @result TABLE (id nvarchar(128), title nvarchar(256), ord int) insert into @result select 'sun' id, 'sum 1' title, 1 ord union select 'mon' id, 'mon 1' title, 2 ord union select 'tue' id, 'tue 1' title, 3 ord union select 'wed' id, 'wed 1' title, 4 ord union select 'thu' id, 'thu 1' title, 5 ord union select 'fri' id, 'fri 1' title, 6 ord union select 'sat' id, 'sat 1' title, 7 ord select * from @result order by ord
In SELECT 3 in GetItems specify the output type viewType='chartbar'
In SELECT 4, we output data by bands in GetItems (instead of footer data) (with this data model).
-- SELECT 4 The field names must be exactly the same as in the example select '123' itemID, 'tue~' [from], 'wed' [to], 'Task 1' [title], 'Caption by name' [desc], '123' cssClass, '#b03532' color union select '123' itemID, 'wed' [from], 'wed' [to], 'Task 2' [title], '' [desc], '123' cssClass, '#33a8a5' color union select '123' itemID, 'sun' [from], 'tue' [to], 'Task 3' [title], '' [desc], '123' cssClass, '#30997a' color union select '123' itemID, 'tue~' [from], 'thu' [to], 'Task 4' [title], '' [desc], '123' cssClass, '#6a478f' color
- If you need to add a form, then embed the snippet layout in the title field.
- for fields, specify the cssClass format(not CssClass) in SELECT 4.
- All fields in SELECT are 4 - string (including itemID).
Examples of how Falcon Space platform components workExamples of convenient tables and forms Examples of dashboards Examples of graphs and charts Example of a calendar Table with API data Example of displaying a map with points Types of form fields Example of a statistics widget Example of a hierarchy tree Example of the Time line component Example of a product card Example of resource load tracking Example of a Kanban board Example of a master form Example of uploading Excel/Word documents Example of filling in TIN data
- 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
- Falcon Space Features
- Additional component
- HOWTO Tables
- HOWTO Forms
- HOWTO JS
- HOWTO CSS
- HOWTO Layout
- Solve problems
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