Non-grouped query that uses overall aggregate issue in skuid

  • 1
  • Question
  • Updated 4 years ago
  • Answered
  • (Edited)
Non-grouped query that uses overall aggregate issue in skuid
Photo of vijay

vijay

  • 70 Points

Posted 4 years ago

  • 1
Photo of Andy Forbes

Andy Forbes

  • 322 Points 250 badge 2x thumb
I am on the same team as Vijay (the OP). The issue is that we are not getting this error in our development sandbox, but when we move the Skuid pages to a production SFDC org - this error appears. Any suggestions on what to look for to sort this out would be appreciated!
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
Aggregate queries don't play well with Limits.  This is a known issue in Skuid.  We encourage you to remove limits in these models.  But what probably happened is that in your sandbox you didn't have the volume of data required to trigger the issue  - ie you didn't exceed the limit.   Whereas in Prod, you did...
Photo of Andy Forbes

Andy Forbes

  • 322 Points 250 badge 2x thumb
Rob - Actually, it is the opposite. We have a fair amount of data in our development sandbox and literally zero data in production since we haven't gone live yet. That said, thank you for your post and we'll remove the aggregate queries with limits. Andy
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
Let us know if this problem persists.