- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
zoql error
Hi All,
When I try to run the following query using the zoql
Select sum(Amount) as PaymentAmount,Account.ISNID__c as advertiser_id
from Payment
where CreatedDate >= 'today- 45 days'
and YEAR(CreatedDate)=2017
group by Account.ISNID__c
limit 20
I get an error from the zuora engine saying:
{
"errorCode" : "90007",
"message" : "null, ErrorCode=90007,Message=",
"batches" : [ {
"localizedStatus" : "pending",
"recordCount" : 0,
"batchId" : "2c92c0f95e5e8bf8015e7092eb4d351c",
"apiVersion" : "58.0",
"batchType" : "zoqlexport",
"full" : true,
"status" : "pending",
"query" : "Select sum(Amount) as PaymentAmount,Account.ISNID__c as advertiser_id\r\nfrom Payment \r\nwhere CreatedDate >= 'today- 45 days'\r\nand YEAR(CreatedDate)=2017\r\ngroup by Account.ISNID__c\r\nlimit 20"
} ],
"useLastCompletedJobQueries" : false,
"encrypted" : "none",
"version" : "1.0",
"startTime" : "2017-09-11T06:53:51-0400",
"status" : "aborted",
"format" : "CSV",
"name" : "IConductQuery",
"id" : "2c92c0f95e5e8bf8015e7092eb49351b"
}
when I remove the and YEAR(CreatedDate)=2017 condition the query works fine.
@Viktor Maybe you can help me also on this one?
Thanks for your help,
Mike.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: zoql error
I'll take a look at this @_mikeSmith - ping me again if you would not hear from me tomorrow!
If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: zoql error
Hi @_mikeSmith I've done some testing around this, and it seems to me this is actually a bug as I've managed to capture some errors in our internal logs.
Could you open a Support Ticket regarding this please, as this will need more in-depth investigation? You can address the ticket to me and I can continue working on this.
If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: zoql error
Hi @Viktor,
Thanks for your quick response. Can you please reffer me to the page where I can open the ticket?
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: zoql error
@_mikeSmith you can register and log a case at support.zuora.com !
If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: zoql error
Hi @_mikeSmith I have not seen a ticket from you (might have just avoided my attention), but I wanted to let you know this has been reported to our Developers already, as this seems to be affecting all Date-related functions like quarter() or month(). We expect this to be fixed shortly!
If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √