SOQL Currency Condition Support

[Adam Stepanek]

Hi Scott,

could you please add a support for currency field condition in query? Here is documentation, with following example and how it looks in IC2.

SELECT Id, Name
FROM Opportunity
WHERE Amount > USD5000

with message <value> expected, got 'USD5000'. The query executes fine in the end.

[Scott Wells]

Fix committed for the next build. Interestingly I’d previously tried to add support for these to the Apex parser, but currency literals without a fractional component, e.g., USD100, are tokenized as Apex identifiers so there’s some parser trickery required to make it work. I commented out my first attempt with a note to myself to try again if/when someone actually asks for it.

[Scott Wells]

Delivered in 2.2.9.8.