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
JoeK.ax278JoeK.ax278 

Came across something in the SOQL BNF...

just now.  *http://wiki.developerforce.com/index.php/BNF_FOR_SOQL)

I was hoping this line:

FIELDEXPR ::= NAME OPERATOR VALUE | NAME MATHOPERATOR NAME OPERATOR VALUE

Indicated we could now do this:

    select id from object where x -  y > 0

as an alternative to

    select id from object where x > y

Is there an enhancement to SOQL that I've missed or that is in the works?

 

ArtabusArtabus

I just tried it, it does not work

select amount from opportunity where amount+1>50000

I tried even with API 18.0, without success

 

By the way, there is a mistake in that page, it is written THIS_QUERTER instead of THIS_QUARTER

=> this doc is probably human generated, with human errors...
adsfadsf

Thanks for the confirmation, Artabus.   I got the same result in my testing as well.

 

Note that what I've really been hoping for has been the ability to compare two FIELDNAME's in the same FIELDEXPR.  I suppose it's hard on the optimizer, but still, I hope!

 

Very observant of you to notice THIS_QUERTER. 

 

Think & Enjoy -- JoeK