Jay, Sure, in the eSearchWidget.mxml find the queryFeaturesText function, then look for the block of code like this and add the lines in red: if(queryLayer){
var query:Query = new Query();
var myPattern:RegExp = /\[value\]/g;
var expr:String = "";
var eVal:String = "";
var criteriaFromValue:String;
for(var sg:Number = 0; sg < searchGroup.numElements; sg++){
sItemVal = searchGroup.getElementAt(sg) as SearchExpValueItem;
queryExpr = configSearchText.expr.values[sg].expression;
if (queryExpr == "[value]" || queryExpr.toLowerCase().indexOf(" in (") > 0){
//meaning an open SQL expression or an SQL with an IN Statement
eVal = sItemVal.textValue;
}else{
eVal = sItemVal.textValue.replace(/'/g,"''");
};
/*If the expression is an IN Statement and the the value is a string then
replace the user defines comma seperated values with single quoted values*/
if(queryExpr.toLowerCase().indexOf(" in (") > 0 && queryExpr.toLowerCase().indexOf("'[value]'") > -1){
//replace the begining and trailing single qoutes if they exist
eVal = eVal.replace(/^'|'$/g, "").replace(/,|','/g, "','");
}
if (sItemVal.isValueRequired && !sItemVal.hasAValue()){
// no value specified so skip this part of where clause
continue;
};
if (queryExpr == "ADDRESS LIKE '[value]%' OR STREET LIKE '%[value]%'"){
queryExpr = "ADDRESS LIKE '" + eVal.replace(" ", "%") + "%' OR STREET LIKE '%[value]%'";
}
