Hi, I have below query formation in mapd crossfilter which gives me a sql as below:
SELECT COUNT(*) as val FROM PLACES WHERE ((latitude >= 19.69089672512304 AND latitude <= 56.78083875041932)) AND ((longitude >= -142.97341062499999 AND longitude <= -4.985129374999985))
var latitudeArr = [
[bounds.minLat, bounds.maxLat]
];
var longitudeArr = [
[bounds.minLon, bounds.maxLon]
];
crossfilter.dimension('latitude').setDrillDownFilter(true).filterAll().filterMulti(latitudeArr, false, false, null).groupAll().getCrossfilter().dimension('longitude').setDrillDownFilter(true).filterAll().filterMulti(longitudeArr, false, false, null).groupAll().reduceCount().writeQuery();
The issue I am facing is that the latitudeArr and longitudeArr are dynamic in nature but I am seeing previous filters on latitude and longitude going on appending which I do not want in my sql
SELECT COUNT(*) as val FROM PLACES_VER_111_NO_X WHERE ((latitude >= 19.69089672512304 AND latitude <= 56.78083875041932)) AND ((longitude >= -142.97341062499999 AND longitude <= -4.985129374999985)) AND ((latitude >= 19.69089672512304 AND latitude <= 56.78083875041932)) AND ((longitude >= -142.97341062499999 AND longitude <= -4.985129374999985))
Can anyone review my above code and suggest me a fix for this issue.