ProcessMaker Forum | BPM Workflow Simplified

$("#FilterEscaped").hide(); //hide so the user doesn't see this text field

//function to escape strings for database queries 
function _escape(val) {
  val = val.replace(/[\0\n\r\b\t\\'"\x1a]/g, function (s) {
    switch (s) {
      case "\0":
        return "\\0";
      case "\n":
        return "\\n";
      case "\r":
        return "\\r";
      case "\b":
        return "\\b";
      case "\t":
        return "\\t";
      case "\x1a":
        return "\\Z";
      case "'":
        return "''";
      case '"':
        return '""';
      default:
        return "\\" + s;
    }
  });

  return val;
}

$("#Filter").setOnchange( function(newVal, oldVal) {
    var v = _escape(newVal);
    $("#FilterEscaped").setValue(v);
});

$(document).ready(function() {
	initSaleData();
});


function initSaleData(){
    $("#idYourControl").getControl().select2({
        ajax: {
            url: "your url",
            dataType: 'json',
            delay: 300,
            data: function(params) {                        
                return {
                    code: params.term.toUpperCase()
                };
            },
            processResults: function(data) {            
                //your code return data to drop down
            },
            cache: true
        },
        placeholder: 'Input data to search',
        minimumInputLength: 3,
        maximumInputLength: 20
    });
}