camel-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rajesh A (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CAMEL-10348) Camel Salesforce - Unable to get aggregate query results
Date Tue, 27 Sep 2016 15:58:20 GMT
Rajesh A created CAMEL-10348:
--------------------------------

             Summary: 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.4#6332)

Mime
View raw message