Chartbar diagram

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: 
  1. Create a table with the columns id (PK),title, ord. These are the statuses of elements displayed at the top of the Kanban Board. 
  2. 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
  3. In SELECT 3 in GetItems specify the output type viewType='chartbar'
  4. 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
       

    Note:
    1. If you need to add a form, then embed the snippet layout in the title field. 
    2. for fields, specify the cssClass format(not CssClass) in SELECT 4.
    3. All fields in SELECT are 4 - string (including itemID). 
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