Plugin: Kanban Dashboard

From iDempiere en
Jump to: navigation, search
KanbanConfig.jpg


Description

  • This plugin extends iDempiere with a new functionality to implement Kanban Boards
  • The kanban Board shows you an overview of the process you want.
  • You can define the states of a process based on a List or a Column.
  • You can move a card from one state to another by drag and drop.
  • You can sort the cards by priority.
  • See the cards on different colors according to their priority value.
  • Manage who can interact with the board and who can't.
  • Set the info that you want to see in each card.
  • Use the SQL Queue field to set a rule that sends every document that satisfies it to a queue until the condition is resolved
  • Control your WIP setting the max number of cards allowed in one status

The plugin adds three Windows: Kanban Board Configuration, Kanban Status Configuration, Kanban Board

Feedback

Please rate this plugin:

Current user rating: 99/100 (12 votes)

 You need to enable JavaScript to vote


TimeRatingUser
June 17, 2018, 5:28 pm100%Jose.orlando
September 28, 2016, 8:40 am99%Afildan
June 3, 2016, 10:04 am100%IDempierefr
October 2, 2015, 12:41 pm99%Syshamed
October 1, 2015, 10:00 pm100%Alan.lesc1
July 13, 2015, 6:05 pm100%Leyonce
February 25, 2015, 11:39 pm99%Sergo
November 13, 2014, 1:11 am100%Aguerrave
October 28, 2014, 2:41 pm100%Red1
October 28, 2014, 1:40 pm100%CarlosRuiz
October 28, 2014, 9:18 am100%Ocurieles
October 28, 2014, 2:59 am100%Diego.ruiz


If you want to provide additional comments, please use the Discussion page

Configuration

This window allows the user to create and configure kanban board. You must choose the process to be modeled in the Kanban Board (Ex: Invoice Process -> C_Invoice). Then you choose a ref List or a column to set the statuses. If you want to limit the results to display, you can do it with a sql statement in the "SQL WHERE" field. Ex: If you want to display the unpaid invoices, you must fill this field with: is Paid='N'

Config.jpg

    • NEW

New Sql Order By field. You can choose how to order the cards on your board. If you leave this field empty the order will be set by the priority rule.

Priority Rule Configuration

This field must be filled if you want to sort the cards by some rule or field, the value must be a valid sql statement associated with the process's table.

If you want to use the functionality to print cards by colors depending on its priority, this field must return a numeric value.

Kanban Card Content

To set the text that will be displayed in the cards, the field Kanban Board Text must be filled like this:

  • The text that is going to be displayed getting values from the data base must be between '@' with the name of the field.
  • If it is a field of a foreign table, you must type the name of that table followed by a '.' and the name of the field, all that between the '@'
  • Any other text that doesn't meet this parameters will be printed without format in the card

KanbanCardContent.jpg

In the case of fields with data type: Date and amount, you can also send the format you want to use for it between <> before the final @.

Prints: KanbanCard.jpg

Status

This window allows you to configure the different states of the board. You can create an Alias for the state, that alias will be printed instead of the name in the kanban board.

If you want you can limit the number of cards in a state, this limits the W.I.P. The Seq Value determines the order of the columns in the board. If you click isShowOver, the board will display all the cards in that state, even if they exceed the maximum amount defined prevously, in this case the column header will be painted red.

You can set a final state by setting isShowOver='N' and Max number of cards -1.

If you want to create a rule to place the cards in a queue instead of its column, the SQL Statement field does that. You can set any kind of rule that can be into a where clause in a sql statement. If you want to show in the queue all the cards that don't have a BPartner associated, you must fill the field with C_BPARTNER=null, it'll place all the cards in the status column but aditionally it will create a new column in the left that represents a queue from the actual state, the cards in the queue column can not be moved, it will move automatically once you satisfy the condition that was set for it. You can also set up that it will be send to the queue if the cards in that state exceeds the max number of cards allowed for it, in this case you must fill that field wth a C (Card).

Priority

Here you can configure the priority, you assign a color to each range defined by the priority rule.

Status Configuration

StatusConf.jpg

This window lets you sort and set the state's parameters, here you can modify the values of the columns in a friendly way.

You can change states order by drag and drop.

When you click a column, the right panel shows all the properties of that State, you can edit those values. If you drag a state and drop it in the trash can, this state will be deleted.

Usage

KanbanConfig.jpg

The Kanban Board window allows you to interact with the pre configured boards. A list of available boards is shown (if pre-configured).

When you select one of the boards, the associated kanban board is displayed with each column corresponding to a state, and each card to a record of this process that is currently on that state.

You can move the cards between different states if you want it, if it doesn't violates any workflow, the card state's value will be updated.

You can zoom into the document by double clicking on the card.

You can set different types of boards (Even if they're not Kanban Boards), like sales report by vendor

Improvements In Recent Versions

The Kanban Board window presents the following improvements:

  • Now it is possible to see which components you can interact with, since the cursor changes when it is over a card that can be moved.
  • Each state has a menu that is displayed when clicking on the button located on the right side of the column, the menu shows the list of configured states for the board, when you click one of the items the corresponding column is hidden.


KanbanMenupopup.png


KanbanMenupopup2.png

Kanban Board 2.0

This is the new version of the Kanban Board, it has new features, it is in a beta version. Please feel free to use it, test it and any feedback that you want to share with me will be highly appreciated.

Summary

Now it is possible to have a summary in every status, let’s say you configured your kanban to check the different invoices in different status. With this new feature you can see any information that you want to see in the header of the status. The field is filled by a SQL clause you can do anything there! In the image below you can see a kanban for the invoices that summarize the total amount of all the invoices in every status.

How to do it? Fill the Summary SQL with a query like this: Select Something1, Something2 FROM (The table you defined for the Kanban) JOIN … WHERE (StatusColumn) = @KanbanStatus@ AND …
Fill the Summary message with the corresponding message, it is filled like the message text field in the Message window, you must parse the columns that the summary sql return with {#column}.

Do not use alias for the main table in the FROM clause

    • StatusColumn must be replace with the corresponding column that was chosen to set the statuses.
    • @KanbanStatus@ must be written exactly like that to parse the real values for every status.

e.g. @SQL=SELECT SUM(totallines) || ' €' AS totalamount FROM C_Order WHERE DocStatus = @KanbanStatus@
edit: In the new version the @SQL= is optional

SummaryKDB.png

The result will be something like the following

SummaryResKDB.png

Process within Kanban

This feature is intended to make things simpler, you already can see your info in a general way, but what if you want to process it (individually or in batch) from the kanban Board. It is now possible. For this new feature you will be able to configure process that can affect cards in the whole board, cards in a single status, or a single card.

You can set them up in the new tab Kanban Associated Process

KDBProcessTab.png

Select the process you want to run within the Kanban in the process field.

In the scope field you can select if the process will be run for the board - status - or card.

KDBProcessScope.png

KDBProcessScopeStatus.png

The process work the same as in Info Window depending on the T table. to use the process you must do something like

KDBTTABLE.png

The process will open the normal dialog as every other process in iDempiere and will ask for parameters if needed.

Configurable text color on cards

This feature can be used to add contrast to text, if you set a priority color to identify certain cards easily, but the background color of the card is to dark, the black color for the text can be hard to read. Now you can choose the text color also to create a nicer contrast in the cards.

Just fill the 'Text color' field in the Kanban Priority tab.

KDBTextColor.png

And you will be able to see the new text color in your board.

KanbanCardsTextColor.png

Setting the standard card size

Now you can configure the size of the cards in a Kanban board. You can set the Height and the Width, thus, all the cards will be displayed with the same size in the board. Just fill the fields 'Standard Column Width' and 'Standard Card Height' with the desired values.

KDBCardSize.png


If the card content exceeds the chosen size, a scroll bar will be placed in the card to navigate through the content. If you don't fill this values, the cards will behave as default in ZK.

KDBCardScrollBar.png

Kanban Board Auto Refresh

Sometimes you want to let a screen open and check from time to time how your processes are performing on a day. With this new functionality (contributed by Alan Lescano), you can configure the Kanban board to auto refresh every certain amount of time. Allowing you to see changes in the process flow without interacting directly with the system.

Configure a SysConfig 'KDB_KanbanBoard_RefreshInterval' with the time set in milliseconds as shown in the image below.

KDBAutoRefresh.png

Kanban Board Parameters

This new feature (Sponsored by cloudempiere.com) allows the user to set parameters in the Kanban Board and have quick filters on the existing boards, from now on you can set your kanban as usual and configuring the parameters you have more flexibility on filtering the cards you want to see.

In order to configure the parameters, navigate to the new Kanban Parameter tab and fill the fields:

  • Sequence: in which order you want to see the parameters.
  • Column Table: Select the column that you want to use to filter the results.
  • Query Operator: here you can select which kind of comparison you want to make against the selected column (equal, less than, greater than,...).
  • Range: Checkbox to define if a parameter has a range.
  • Default Logic: You can set the default logic of the parameter, for example, the login date with @#Date@. This field does not support SQL statements

KDB Parameter.png

Once the parameters are configured, open the kanban board, if you configured just one parameter, you will see it next to the refresh button.

KDBParam1.png

When there is more than one parameter, you'll see a button "Quick Filter" that opens a dialog with all the parameters for you to set them.

KDBParam2.png

If you don't want to group all the parameters in a single button, set the SysConfif 'KDB_GROUP_PARAMETERS' to N and the parameters will be shown in the top panel.

KDBNoGroup.png

When you change the parameters, the board will show only the cards that satisfy the selected parameters.

How to Install

Felix console

To install the plugin using the felix console you can download the plugin jar kanbanBoard_1.0.0.201410271927.jar* directly from here and use the felix console to install as usual.

Auto Setup