function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
miteshsuramiteshsura 

aggregate query not allowed with this api version

Hello! Gurus,

 

I saw the solution to similar issue on different thread, but did not help me much.

So I am trying to run aggregate funstion, and I get this error "aggregate query not allowed with this api version" both in Eclipse and Apex Explorer, how do I change the the API version number??

 

I see we can do that for Class/Trigger via the xml file, but just could not do it for +salesforce.schema file in Eclipse.

Apex explorer, I did not see any options that allows me to change the the version number.

 

Apart from force.com ide and apex explorer, are you aware of other tools I can use to querry SOQL??

 

Thanks in asvance.

Mitesh

Best Answer chosen by Admin (Salesforce Developers) 
dhoechstdhoechst

Apex Explorer uses a really old API. There is a new one called Force.com Explorer in beta. It can be found at http://wiki.developerforce.com/index.php/ForceExplorer. As far as in Eclipse, have you upgraded to the latest version (http://wiki.developerforce.com/index.php/Updating_the_Force.com_IDE)? Have you refreshed everything from the server?

All Answers

dhoechstdhoechst

Apex Explorer uses a really old API. There is a new one called Force.com Explorer in beta. It can be found at http://wiki.developerforce.com/index.php/ForceExplorer. As far as in Eclipse, have you upgraded to the latest version (http://wiki.developerforce.com/index.php/Updating_the_Force.com_IDE)? Have you refreshed everything from the server?

This was selected as the best answer
miteshsuramiteshsura

 

1. Updated the Force.com IDE,  but not the support, as it stoped on 36% forever!!

    Did refresh from server, still not able to run aggregate quries! I have Force.com IDE 9 on eclipse

 

2.  ForceExplorer beta>>Known Issues. it says: "Aggregation queries aren't working due to an "Id" field being inserted."

      and I want to run Aggregate queries!

       I went ahead and did the instal, ran the query and hurray, I was able to Run aggregate queries. Not sure what the           known issue was reffering to, bc I had Id field in my query. Anayways thanks for pointing me the right direction.

        btw beta version looks cool too!!

 

 

 
dhoechstdhoechst

There must be some special case with that bug because I just ran an aggregate query in the Force.com Explorer and no error was thrown. Give it a try and see if your query works.

 

If you are having a lot of issues with updating your IDE, then maybe you should just start over. I had a similar problem a while ago and ended up just downloading Eclipse again and reinstalling the Force.com plugin. Since everything should be on the Salesforce servers, you aren't losing any work.