Page breaks if any row of the ORDER BY field in model is null.

  • 1
  • Question
  • Updated 4 years ago
  • Answered
See title. Not sure if this is already known or should have been obvious, but I thought I would give everyone a heads-up.
Photo of Matt Sones

Matt Sones, Champion

  • 31,478 Points 20k badge 2x thumb

Posted 4 years ago

  • 1
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
Not exactly true.  You don't have to fill in the Order by field.  But if you have spaces in that field or other characters you will be creating bad SOQL and the page will blow up.  You can see what is going on by doing the following.

Open your browser console  (In Chrome  CMD - Option J (Mac) and CNTRL - Alt J (PC)). 
Then type the following:   skuid.$M('ModelName').soql   (Replace ModelName with your ModelID) 
This will show you the SOQL that is being presented as well as any error statements - which will help you debug...
Photo of Matt Sones

Matt Sones, Champion

  • 31,478 Points 20k badge 2x thumb
Awesome. Thanks for the tip, Rob!