Add the functionality to search process instances with like (and in) condition in variable value

[magrawa]

Looks like the latest upgrade in MDW has broken the search functionality in TOM.

When we initially developed the TOM Status Microservice (with MDW version 6.0.07), we had written code to filter MDW instances based on variable values using the Process Services API extended by MDW.
This is what the TOM code looked like-

          if ((USO_NUMBER).equalsIgnoreCase(entry.getKey())) {
                       variablesMap.put(USO_NUMBER, "like '%"+entry.getValue()+"%'");
                 }
   
          //Following filter is used to ignore the process instances used to GET the information                 
          variablesMap.put("Type", UPDATE);
          ProcessServices processServices = ServiceLocator.getProcessServices();

          //The following method lists out all processes based on the filters provided in the query.
          ProcessList processList = processServices.getInstances(criteria, variablesMap, 0,Query.MAX_ALL, "order by pis.create_dt desc");
          List<ProcessInstance> instancelist = processList.getProcesses();

With the recent update to mdw 6.0.10, this functionality stopped working as we no longer need to pass the conditional operator in the variablesMap that is passed to the API.
This is what the code looks like now-

   if ((USO_NUMBER).equalsIgnoreCase(entry.getKey())) {
                       variablesMap.put(USO_NUMBER, entry.getValue());
                 }
          variablesMap.put("Type", UPDATE);
          ProcessServices processServices = ServiceLocator.getProcessServices();
          //The following method lists out all processes based on the filters provided in the query.
          ProcessList processList = processServices.getInstances(criteria, variablesMap, 0,Query.MAX_ALL, "order by pis.create_dt desc");
          List<ProcessInstance> instancelist = processList.getProcesses();

[magrawa]

We are going to check if the variable value starts with like or in keywords and based on that we build the SQL query. If those two words are not present then we assume = condition. if like or in is specified in variable value then it would be the responsibility of the caller to formulate the SQL query properly.
Example for like
like '%a%'
For in
in ('a','b')

@jbrojdeCTL
@donaldoakes