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).