Hello, I have a map service that I am trying to return distinct values on using a query that utilizes greater than / less than operators. My first query appears as follows, and when executed, returns records.
Executing the same query with returnDistinctValues set to true returns 0 records.
Replacing the second part of the query with "1=1" also returns records
So the question is, what is it about the second part of my query that would cause the map service to return no records? It seems to be a problem with less than symbol but I have no way to confirm that.