d-ruiz / kdb_idempiere

Kanban Board plugin for iDempiere

kdb_idempiere's Issues

Column SQL for Kanban Status

Swimlane Date column support

i want to define new swimlane rule, by date column. ATM this is not possible, @d-ruiz check the code.

solution: add support for date, datetime column types i.)allow select ii.)allow format the date by sql function.
eg. to_char(timestamp_column, 'YYYY-MM')

Kanban Date Editor Parameter cause Stack Overflow

After IDEMPIERE-5467, changing Kanban Date Editor Parameter is Causing StackOverflow Error.
WKanbanBoard:1125

			if (mapEditorParameter.containsKey(changedEditor)) {
				MKanbanParameter changedParam = mapEditorParameter.get(changedEditor);
-				changedEditor.setValue(value);
				changedParam.setValue(value);
			} else if (mapEditorToParameter.containsKey(changedEditor)) {
				MKanbanParameter changedParamTo = mapEditorToParameter.get(changedEditor);
-				changedParamTo.setValueTo(value);
				changedParamTo.setValueTo(value);
			}

Kanban Swimlane Summary not visible

hi,
the swim-lane summary is not visible, we changed only 1 line which fixed. not sure you have the same vision.

Range parameters not consistent with normal iDempiere behavior

Normally range parameters are managed like this:

• when the first editor is filled and the second editor is empty - operation >= firsteditor
• when the second editor is filled and the first editor is empty - operation <= secondeditor
• when both editors are filled - operation >= firsteditor and <= secondeditor

Also, the parameter is working for Date, but not for Date+Time, because is truncating the time

AD_PrintColor has no caching in Kanban

pgstat report hundred thousands +queries to AD_PrintColor.
we found AD_PrintColor has no caching in Kanban

solution: use cached AD_PrintColor

Kanban swimlane rendered empty.

Hello I found issue with swimlane rendering when no cards are in this swim lane. I added sqlWhere to swim lane to get only existing groups, but in Kanban Status we also added max Cards which is from total 250 records rendering only 10, so swim lane is rendered empty and not removed.

Suggestion to use kanban parameter name in search filter instead column name

In some cases it is useful to add a parameter more than once, but with a different operator to search the records.
Considering the column name, we wouldn't know which parameter is

Using kanban parameter name

Column SQL for Kanban Status

Hello good morning, Is it possible to do something to filter the columns of the kanba board in relation to the parameters of the kamba?

The idea would be to add a mark to the parameters tab in the configuration that indicates if that parameter, in addition to filtering the cards, also filters the columns?

Kanban Board is always showing a generic message when moving without document status

The kanban board always shows the generic This status transition is not allowed. when an error occurs.

This is wrong, as the transition between draft and complete is valid but a different error might happen. For instance, close period, no lines, etc ...

Convert to maven project and osgi feature

I created the following plugins:

• org.kdb.idempiere
• org.kdb.idempiere.extensions.p2
• org.kdb.idempiere.extensions.parent
• org.kdb.idempiere.extensions.server.feature

The above plugins was created following the approach and naming convention used in rest-api

Installing kanban in a clean system is reverting stuff to old dictionary

For example, the element AD_Client_ID has been renamed to "Tenant" in recent iDempiere, but when installing kanban the name is set back to "Client"

Cache for priorities and parameters

There is a possibility to improve the cache of priorities and parameters avoiding unnecessary visits to the database.

Actually the validations visit the database when there are no records, so, when there are not really records configured, the database is checked every time.

The following proposed patch (untested) improves that avoiding that visit:
kanban_cache.patch.txt

Kanban Card Parse Variable NPE

Issue: When Parsing Sub Record ex. "@SalesRep.Name@" and SalesRep_ID Column contains Dynamic Validation/Reference Validation and value is not valid for selected validation, then PO.java:1594 show Severe Log NO Data found for ...
And Kanban Cart takes this PO Object and uses it after code below.

kdb_idempiere/src/org/kanbanboard/model/MKanbanCard.java

Line 360 in ef970cd

PO subPo = table.getPO(subRecordId, null);

After this we receive NullPointer Exception.

This issue will happen when we change validation on Column and some of its data become invalid.

Allow use sql in kanban parameter

issue: atm it is not possible to format date parameter by sql: @Sql=SELECT date_trunc('day', NOW()) => as result: 2023-03-15 00.00.00

change request: implement sql support allow define sql instead context @Date@

Kanban - setting wrong columnname

In MKanbanBoard.java, method setPrintableNames() the table.get_Translation method is used incorrectly, generates Column not found - [columnname] error logs

Instead of table.get_Translation(column.getName()) there should be table.get_Translation(MColumn.COLUMNNAME_Name)