a field is breaking my page

  • 1
  • Problem
  • Updated 4 years ago
  • Solved
  • (Edited)
Page: Job_Detail_Master_FGeocodeProblem
Org ID: 00Di0000000co1i


Photo of mB Pat Vachon

mB Pat Vachon, Champion

  • 42,714 Points 20k badge 2x thumb

Posted 4 years ago

  • 1
Photo of Moshe Karmel

Moshe Karmel, Champion

  • 8,646 Points 5k badge 2x thumb
Check this out : http://salesforce.stackexchange.com/questions/21665/why-am-i-getting-an-oracle-exception-when-doing-... (For the record, that's the most awesome error message I've ever seen...)
Photo of mB Pat Vachon

mB Pat Vachon, Champion

  • 42,714 Points 20k badge 2x thumb
Yup. Certainly an eye opener! Not sure how a formula field can possible break a SOQL query.
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
Holy Cow. That is a great error message. 
Photo of mB Pat Vachon

mB Pat Vachon, Champion

  • 42,714 Points 20k badge 2x thumb
That's all me! :D
Photo of mB Pat Vachon

mB Pat Vachon, Champion

  • 42,714 Points 20k badge 2x thumb
The formula field itself was not producing the text I wanted, but this should not have broken the page if it worked without error on a page layout.

That said, after fixing the formula to produce the text I want, my page is no longer broken. Odd.
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
Glad you were able to get this fixed. Something about the formula made SOQL very unhappy. You should not assume that because fields show in standard layouts - they will show via Skuid.  Salesforce can do some trickery on the standard layouts that we cannot.