camel-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Claus Ibsen (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (CAMEL-10348) Camel Salesforce - Unable to get aggregate query results
Date Wed, 15 Mar 2017 09:05:41 GMT

     [ https://issues.apache.org/jira/browse/CAMEL-10348?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Claus Ibsen resolved CAMEL-10348.
---------------------------------
    Resolution: Invalid

> Camel Salesforce - Unable to get aggregate query results
> --------------------------------------------------------
>
>                 Key: CAMEL-10348
>                 URL: https://issues.apache.org/jira/browse/CAMEL-10348
>             Project: Camel
>          Issue Type: Bug
>          Components: camel-salesforce
>    Affects Versions: 2.17.3
>            Reporter: Rajesh A
>
> Trying to get the maximum value by executing the below query:
> SELECT max(Replay_Id__c) maxReplayId FROM Streaming__c WHERE Status__c != 'New'
> Here is the camel route endpoint:
> {code:title=MyRouteBuilder.java|borderStyle=solid}
> .....
> from("timer://runOnce?repeatCount=1")
> .to("salesforce:query?sObjectQuery=SELECT max(Replay_Id__c) maxReplayId FROM Streaming__c
WHERE Status__c != 'New'&sObjectClass=" + QueryRecordsAggregateResult.class.getName())
> .process(this.initalProcessor);
> ....
> {code}
> But, I am not able to get the AggregateResult, this is what I see in QueryRecordsAggregateResult
> *BodyType:* org.apache.camel.salesforce.dto.QueryRecordsAggregateResult, Body: {"done":true,"totalSize":1,"records":[{"attributes":{"type":"AggregateResult"}}]},
Out: null:
> And the generated AggregateResult.java looks like this:
> {code:title=AggregateResult.java|borderStyle=solid}
> /**
>  * Salesforce DTO for SObject AggregateResult
>  */
> @XStreamAlias("AggregateResult")
> public class AggregateResult extends AbstractSObjectBase {
>  
> }
> {code}
> There is no documentation on how to pull aggregate results. I guess this is a defect
which prevents me from getting the aggregate result from salesforce. Could you please fix
this.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message