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
Vipin PulinholyVipin Pulinholy 

Will I be able to query MAX value of a field in sforce DB?

Hi,

   I want to get the maximum value of a Number type data type field in the sforce databse (Custom field) using api. Iam using MXML ,Javascript Is it possible to use like select  MAX(FeildName) from Table name. If not how do I do this??

Please help...

das 

adamgadamg
We do not support aggregate functions at this time, so unfortuately you cannot do that via the API.
SaaSGuruSaaSGuru
Any update on this? Do you support aggregate functions now?
SuperfellSuperfell
There are no aggregate functions, but MAX in particular is easily done by using "order by XXX limit 1"