Eric,
In the eSearch Widget folder open the Widget.js and find the buildWhereClause function and add lines 38-40 as shown below:
buildWhereClause: function (layerIndex, expressIndex, theValue) {
var myPattern = /\[value\]/g;
var myPattern1 = /\[value1\]/g;
var myPattern2 = /\[value2\]/g;
var myPattern3 = /\[value\]/;
var expr = "";
var eVal;
var eVal1;
var eVal2;
var criteriaFromValue;
var content = theValue || this.paramsDijit.getSingleParamValues();
if (!content || content.length === 0 || !this.config.layers.length) {
return;
}
for (var s = 0; s < content.length; s++) {
var tOperator = (this.config.layers[layerIndex].expressions.expression[expressIndex].values.value[s] &&
typeof this.config.layers[layerIndex].expressions.expression[expressIndex].values.value[s].operator !== 'undefined') ? this.config.layers[layerIndex].expressions.expression[expressIndex].values.value[s].operator : 'OR';
var tOperation = this.config.layers[layerIndex].expressions.expression[expressIndex].values.value[s].operation;
var queryExpr = this.config.layers[layerIndex].expressions.expression[expressIndex].values.value[s].sqltext;
if (!content[s].hasOwnProperty('value') || content[s].value === null) {
if(!content[s].hasOwnProperty('value1') || content[s].value1 === null){
continue;
}
if (content[s].value1.toString() !== "NaN" && content[s].value2.toString() !== "NaN") {
eVal1 = content[s].value1.toString();
eVal2 = content[s].value2.toString();
criteriaFromValue = queryExpr.replace(myPattern1, eVal1);
criteriaFromValue = criteriaFromValue.replace(myPattern2, eVal2);
expr = this.AppendTo(expr, criteriaFromValue, tOperator);
continue;
} else {
continue;
}
}
if (tOperation === 'stringOperatorContains') {
if(content[s].value.toString() === ""){
continue;
}
var sa = content[s].value.toString().split(" "), word;
for(w=0; w < sa.length; w++){
word = sa[w];
criteriaFromValue = queryExpr.replace(myPattern, word);
expr = this.AppendTo(expr, criteriaFromValue, "AND");
}
continue;
}
And let me know if this solves your issue.