// 过滤很多东西 例如pro_id=12345789&JCRQ=2020-12-31
// arr: [
// ["pro_id", "12345789"],
// ["JCRQ", "2020-12-31"]
// ]
toQuery.queryWithUrlAndMore = function (url, arr) {
return new Promise((resolve, reject) => {
esriLoader.loadModules([
"esri/tasks/QueryTask", "esri/tasks/support/Query"
]).then(([QueryTask, Query]) => {
var layerUrl = url
var queryTask = new QueryTask({
url: layerUrl
});
var query = new Query();
query.returnGeometry = true;
query.outFields = ["*"];
// where 格式 "pro_id='1398a4ee-9a11-4b38-946e-01a6268eca4b"
// console.log('这是js内的id',id);
var string = ""
arr.forEach((item, index) => {
if (index == 0) {
console.log('这是item', item);
string = string + item[0] + '=' + "'" + item[1] + "'"
} else {
console.log('这是其他的加', );
string = string + " and " + item[0] + '=' + "'" + item[1] + "'"
}
})
let newString = String(string)
console.log('这是string', string);
query.where = newString
queryTask.execute(query).then(function (results) {
console.log('这是通过项目条件过滤的==================results====================', results);
resolve(results)
}).catch(err => {
console.log('这是err', err);
reject(err)
});
})
})
}
arcgis Query 查询例如pro_id=12345789&JCRQ=2020-12-31 的sql语句该怎么写
最新推荐文章于 2023-04-24 09:41:35 发布