url = `${conn.get('spatialUsergeomUrl')}&LAYERS=` + username + '%3A' + datasetNme + '&SRS='+
srs + '&BBOX=' + bbox + '&WIDTH=' + width + '&height=' + height + '&TRANSPARENT=' +
transparent + '&buffer=' + buffer
I am loading important components it returns a response. After that I want one postGis query to be merged in above url in a format so that I may get proper response in request. I am adding postgis query.
if (cql_filter !== null) {
url = url + `&${geoDetails.get('GeometricFunctionBasedSingleWithQuery')}` +
'&viewparams=comparisonValue%3A' + comparisonValue +
'%3BcomparisonOperator%3A' + comparisonOperator + '%3Bquery%3A' + cql_filter +
'%3BdatasetNme%3A' + datasetNme +'%3BcomparisonFunction%3A' +
comparisonFunction + '%3Busername%3A' + username
}
postgis query is
select distinct "%username%"."%datasetNme%".geom from "%username%"."%datasetNme%" where ST_%comparisonFunction%("%username%"."%datasetNme%".geom) %comparisonOperator% %comparisonValue% and %query%