The Kanban Board
This is the table component mode
Allows you to display data in the form of a Kanban Board with a division by status and the ability to transfer the card to another status.
To display the Kanban Board, you must do the following:
Create a status table with the columns id (PK),name, and color. These are the statuses of elements displayed at the top of the Kanban Board.
In the second GetItems request, select the statuses
CREATE TABLE dbo.#result (id int, name nvarchar(256), color nvarchar(64)) declare @filterName nvarchar(128) select @filterName = Value from @filters where [Key] = 'name' insert into #result SELECT [id], [name], [color] FROM [demo].[dbo].[as_en_statuses] -- take statuses WHERE entityID in (select id from as_en_entities where code='order') ORDER BY ord
In the third select in GetItems specify the output type viewType='kanban'
In the fourth select, in GetItems (instead of footer data), we output data from Kanban cards (with exactly this data model).
SELECT ord_orders.id, as_en_entityInstances.statusID,-- The status of element is displayed in the middle of the card customerName name, customerContact text, -- If the form code is specified, then 'Comment of the customer: ' + customerComment tooltip, -- it will be a reference to the modal form convert(nvarchar, ord_orders.created, 120) bottomText, '' customClass--css class FROM ord_orders INNER JOIN as_en_entityInstances on as_en_entityInstances.id = ord_orders.instanceID
Additionally the following parameters can be configured in the 3 select query:
kanbanItemForm-form code. If specified, the form will be called when clicking on the Board card in the modal window
(the form with the specified code will need to be implemented separately, Itemid=ID of the entity from the 4 select
query is passed to it). You can also pass this parameter (kanbanItemForm -) in 4 requests for each card separately,
to output different forms for different cards.
kanbanItemFormTitle-title of the form dialog box.
To change the status, you must implement the updateField update method for the table. The transmitted field is set hard-statusID.
CREATE PROCEDURE [dbo].[crud_kanbanOrders_updateField] @itemID int, @field nvarchar(64), @value nvarchar(max), @username nvarchar(64) AS BEGIN if(@field = 'statusID') begin update as_en_entityInstances set statusID = cast(@value as int) where id in (select instanceID from ord_orders where id = @itemID) end else if(@field = 'YYY') begin update as_trace set code = @value where id = @itemID end else begin select 'Invalid property code' Msg, 0 Result return end select '' Msg, 1 Result END
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