Type: Bug Fix
Affects Version/s: None
KULRICE-11508 Ajax field query enhancement on load KULRICE-9958 Bad ids on subcollections KULRICE-7094 DocumentSearchGeneratorImpl creates bad SQL when UI date format is changed KULRICE-1651 When invoking ActionListImmediateEmailReminderService remotely, ActionItem.getRouteHeader is null KULRICE-7690 Date Approved Workflow Preference can cause an excessive amount of sql queries KULRICE-6790 ClassCastException when background KSB message processing invokes kimCacheAdminService (embedded mode) KULRICE-11712 Suggest queries should be case insensitive KULRICE-3575 when a new rule delegation is created, the document requeuer is never invoked KULRICE-11961 Ajax field queries do not work
In the case that the list of roleIds that are passed in are empty, the following sql is generated:
SELECT A0.DLGN_ID,A0.ROLE_ID,A0.ACTV_IND,A0.KIM_TYP_ID,A0.DLGN_TYP_CD,A0.VER_NBR,A0.OBJ_ID FROM KRIM_DLGN_T A0 WHERE (A0.ROLE_ID IN ()) AND A0.ACTV_IND = ?
This causes a confusing error from MySQL which is hard to figure out (makes it look like an issue with ACTV_IND instead).
Not sure if this is something that needs to be handled but wanted to be sure I recorded it in case it does.
|Fix Version/s||KFS Release 3.0 [ 12780 ]|
|Assignee||Ailish Byrne [ abyrne ]||Jonathan Keller [ jkeller ]|
|Priority||Major [ 3 ]||Critical [ 2 ]|
|Status||Open [ 1 ]||In Progress [ 3 ]|
|Status||In Progress [ 3 ]||Resolved [ 5 ]|
|Resolution||Complete [ 6 ]|
|Status||Resolved [ 5 ]||Closed [ 6 ]|
|Workflow||custom [ 60275 ]||Copy of custom for rice [ 210449 ]|
|Workflow||Copy of custom for rice [ 210449 ]||custom [ 220197 ]|
|Workflow||custom [ 220197 ]||Rice Workflow [ 229945 ]|