I am attempting to sort my Search widget's suggestionTemplate's return in ascending order. The widget is looking at 4 fields all in a single feature class. This is an employee locator app and the Search fields in this feature class are for Employee Name, Room, Office Phone, and Cell phone. Using orderByFields for Employee Name technically works but if a room is empty (Null value for Employee Name) it is now at the top of the return. I am looking to have occupied rooms return first and then empty rooms. Basically Null values for Employee Name at the bottom of the suggestions.
const searchWidget = new Search({
view: view,
allPlaceholder: "Search for Rooms, People, Last 4 of Phone ",
includeDefaultSources: false,
locationEnabled: false,
sources: [{
layer: SearchSpace,
// searchTemplate: ["KNOWNAS", "SPACEID","PHONE_EXT","MOBILE"],
searchFields: ["KNOWNAS", "SPACEID","PHONE_EXT","MOBILE"],
suggestionTemplate: {
replaceAll: function(a, b) {
var piecesIn = [
["{KNOWNAS}", ""],
["{SPACEID}", ""],
["Ext: {PHONE_EXT}", "Ext: "],
["Cell: {MOBILE}", "Cell: "],
["(Building {BUILDING})", " "]
];
var piecesOut = [];
console.log(piecesOut + "piecesOut1")
piecesIn.forEach(function(pieceIn) {
var pieceOut = pieceIn[0].replaceAll(a, b);
if (pieceOut !== pieceIn[1])
piecesOut.push(pieceOut);
console.log(piecesOut + "piecesOut2")
});
if (piecesOut.length === 0)
return "";
else if (piecesOut.length === 1)
return piecesOut[0];
else
return piecesOut.join(", ");
},
},
//suggestionTemplate: "Name: {KNOWNAS}, Room: {SHORTNAME}, Phone: {PHONE}, Cell: {MOBILE}, {WORKSITE} ",
exactMatch: false,
maxResults: 50,
minSuggestCharacters: 0,
maxSuggestions: 50,
outFields: ["*"],
orderByFields: ["KNOWNAS ASC"],
localSearchDisabled: true,
placeholder: "Search for Rooms, People, Last 4 of Phone",
zoomScale: 500
},
]
});
//Add Wildcard to Search widget
esriConfig.request.interceptors.push({
urls: /\/query/,
before({ requestOptions }) {
if (/LIKE '[^%]/g.test(requestOptions.query?.where)) {
('like request intercepted', requestOptions);
requestOptions.query.where = requestOptions.query.where.replace(/ LIKE \'/g, ' LIKE \'%');
}
}
})
// Create the Search Expand widget
const SCExpand = new Expand({
view: view,
content: searchWidget,
expandIconClass: "esri-icon-search",
expandTooltip: "Open Search",
collapseTooltip: "Close Search",
group: "Widgets",
autocollapse: true,
closeOnEsc: function() {
return searchWidget.activeMenu === "none"
},
expanded: false
})
// close the expand whenever a search is complete
searchWidget.watch("activeBookmark", () => {
SCExpand.collapse();
}),
//-------------------------------------------------------
searchWidget.on("select-result", function(event){
view.goTo({
scale: 50
});
