AnsweredAssumed Answered

eSearch Query on Multiple Fields

Question asked by tjlemahieu on Feb 10, 2016
Latest reply on Feb 15, 2016 by tjlemahieu

Can eSearch be configured to search on multiple fields from the same layer?  For example, in the configuration, can it search on both parcel number (PIN) and school?  I tried this but eSearch just hangs when I add the School Expression.

 

 

"expressions": {

  "expression": [

  {

  "alias": "PIN",

  "textsearchlabel": "Search by PIN",

  "values": {

  "value": [

  {

  "fieldObj": {

  "name": "PIN",

  "label": "PIN",

  "shortType": "string",

  "type": "esriFieldTypeString"

  },

  "valueObj": {

  "value": ""

  },

  "prompt": "PIN is",

  "textsearchhint": "enter PIN number here.",

  "sqltext": "Upper(PIN) = Upper('[value]') OR Upper(KEYPIN) = Upper('[value]')",

  "operation": "stringOperatorIs"

  }

  ]

  }

  },

   "alias": "SCHOOLDESCRIPTION",

  "textsearchlabel": "Search by CVT",

  "values": {

  "value": [

  {

  "fieldObj": {

  "name": "SCHOOLDESCRIPTION",

  "label": "SCHOOLDESCRIPTION",

  "shortType": "string",

  "type": "esriFieldTypeString"

  },

  "valueObj": {

  "value": ""

  },

  "prompt": "SCHOOLDESCRIPTION is",

  "textsearchhint": "enter SCHOOLDESCRIPTION number here.",

  "sqltext": "Upper(SCHOOLDESCRIPTION) like Upper('[value]')",

  "operation": "stringOperatorIs"

  }

  ]

  }

  }

  ]

},

Outcomes