Devart Forums

Does anyone know if it is possible to use any of the CALENDAR_ functions available in the SOQL spec? I need to do the following

SELECT CALENDAR_YEAR(CloseDate), SUM(Amount)
FROM Opportunity
GROUP BY CALENDAR_YEAR(CloseDate)

To basically get a sum of all the amounts per year. Searched through the forum but cannot find any reference to these functions. They seem pretty useful to me and I would be surprised nobody else would need to do something similar. Below are the functions supported by SF on date

CALENDAR_MONTH()
CALENDAR_QUARTER()
CALENDAR_YEAR()
DAY_IN_MONTH()
DAY_IN_WEEK()
DAY_IN_YEAR()
DAY_ONLY()
FISCAL_MONTH()
FISCAL_QUARTER()
FISCAL_YEAR()
HOUR_IN_DAY()
WEEK_IN_MONTH()
WEEK_IN_YEAR()

dotConnect for Salesforce executes SQL statements, that are SQL-92 standard compliant: http://www.devart.com/dotconnect/salesf ... ement.html.

We will investigate the possibility of supporting different SOQL functions via interface of our provider and notify you about the result. Thank you for your suggestion.

Hi Shalex

Is there any movement on this? We have a customer who really needs to do things with dates and years and months etc.

Regards

Sean

The investigation is in progress. We will provide a timeframe for this feature (or notify you about its implementation) this Thursday.

This feature is on our roadmap for the next public build (approximate timeframe is two weeks).

That is great news. Thanks Shalex.

The new build of dotConnect for Salesforce 2.4.628 is available for download now: http://forums.devart.com/viewtopic.php?f=38&t=31737. Please try it and notify us about the result.