[MNT-15774] CLONE - REST Processes and Tasks API for parameters/variables allowed MATCHES operator, operator is not case-insensitive Created: 01-Mar-16 Updated: 03-Oct-16 Resolved: 10-Mar-16
|Project:||Service Packs and Hot Fixes|
|Component/s:||ACS REST API, Workflow|
|Affects Version/s:||5.0.1, 5.0|
|Type:||Service Pack Request|
|Reporter:||Harlin Seritt||Assignee:||Closed Bugs (Inactive)|
|Remaining Estimate:||0 minutes|
|Time Spent:||3 hours, 30 minutes|
|Original Estimate:||Not Specified|
According to http://docs.alfresco.com/5.0/pra/1/concepts/act-processes-get-processes.html there is a sample filtering of data:
where=( startUserId='kermit' AND businessKey='55' AND variables/nameB MATCHES('elmo%') ).
This is case sensitive, request is to make the MATCHES operator case insensitive.
[MER 10/03/2016 - Please note that this expected behaviour is not correct. The expected behaviour is that the query is case sensitive. Instead a new prefix was added to the query to enable a case insensitive search. Please see the linked issue for further details]
Alex Strachan noted that when looking through the code, the class org.alfresco.rest.workflow.api.impl.ProcessesImpl calls a generic class called WhereClauseParser(). This parser class seems to do a direct comparison of objects (there is no toLower() or anything called before comparisons).