"Manage Picklist" errors out with MS-Sql when there is more than 1 pick list
----------------------------------------------------------------------------
Key: OFBIZ-2396
URL: https://issues.apache.org/jira/browse/OFBIZ-2396
Project: OFBiz
Issue Type: Bug
Components: product
Affects Versions: Release Branch 4.0
Reporter: Brian Sanders
Fix For: Release Branch 4.0
This may not affect other DBMS', but it definitely affects MS-Sql. Even though
a "workaround" would be to only have 1 picklist at a time, I don't exactly
consider that acceptable. Fortunately, it's an easy fix. It looks like this
issue still lurks in the trunk as well. To sum it up,
getPicklistSingleInfoInline is called for each picklist. In the method there is
an "orderBy" list to which "sequenceId" is added. The first pass works fine, on
the second pass, "sequenceId" is added to the list again and MS-Sql complains
because the column is in the "order by" clause twice. The solution is to clear
the field before-hand.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
