Search query syntax for searching two fields

MeganWirth

Trying to perform a query task that searches two separate fields. The user text input can either be the Name field or a Docket field.

// Executes on each button click
function doQuery() {
// Set the search text to the value of the input box
document.getElementById("inputTxt").value
queryParams.where = "Name like '%" + document.getElementById("inputTxt").value + "%'";
layer.queryFeatures(queryParams).then(showResults);
}

Appreciate the help.

rscheitlin

Ryan,

   If you are searching the two fields for the same value from the user input then use code like this:

<SPAN class="keyword token">var</SPAN> userInput <SPAN class="operator token">=</SPAN> document<SPAN class="punctuation token">.</SPAN><SPAN class="token function">getElementById</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"inputTxt"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>value<SPAN class="punctuation token">;</SPAN>
queryParams<SPAN class="punctuation token">.</SPAN>where <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Name like '%"</SPAN> <SPAN class="operator token">+</SPAN> userInput <SPAN class="operator token">+</SPAN> <SPAN class="string token">"%' OR Docket like '%"</SPAN> <SPAN class="operator token">+</SPAN> userInput <SPAN class="operator token">+</SPAN> <SPAN class="string token">"%'"</SPAN><SPAN class="punctuation token">;</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>