Selecting Territory2

Question

I have the spring 15 version on my organization. In the Developer Console I wrote this query "Select Id, Name From Territory2", and I got the results (The Ids and the Names of Territories). But when I put this query "Select Id, Name From Territory2 Where Name = 'x' " (x : existing name of a territory), I didn't get any result but in fact I have a data for this query. I tried the query : "Select Id, Name From Territory2 Where Name like '%x%'", and no result too.(All queries returns data (The order by Name working fine too) except when I put the condition "Where Name [...]")

This happen in sandboxes with spring version(not production), in Production sandbox and the sandboxes with summer release everything is good (the two queries return results).

Did someone have this problem? Did someone find any solution? Please advice.

Thank you in advance

Answer 1

I use this query "Select Id, Name From Territory2" and I do my own filtering by code. Here the code :

Set setTerr = new Set(); //adding the names of territories setTerr.add('X');//...

//Select all existing territories Map mappingTerr = new Map([Select Id, Name From Territory2]);

List listTerr = new List();

//For each territory check if it contains the name of territory in the set
for(String territory_id : mappingTerr.keySet()){ if(setTerr.contains(mappingTerr.get(territory_id).Name)){ //Adding result in a list listTerr.add(mappingTerr.get(territory_id));
} }