model condition using parent object's formula field not working in partner community unless lookup

Jack SanfordJack Sanford San Antonio, TX 💎💎
edited February 4, 2020 in Questions
This is a very strange problem that had an even stranger solution, but just in case anyone else comes across this, hopefully you don't have to spend 10 hours on it like I did.

Scenario: model on MyObject__c custom object has a condition "MyObject2__c.FormulaCheckbox__c != true". Works fine in standard salesforce, but in a Partner Community I was getting the error "java.sql.SQLException: ORA-00936: missing expression" 
Could be related to this known issue: https://success.salesforce.com/issues_view?id=a1p300000008XwYAAU&title=a-soql-from-a-community-p...

The error went away when I made the MyObject2__c field on the MyObject__c page layout a required field and then refreshed the fields on the MyObject__c model in the skuid page. 

Comments

  • Mark DeSimoneMark DeSimone 🛠️ 
    edited February 4, 2020
    Jack, thank you for sharing this with the Community. This might be obvious to some, but for my sake, do you mind clarifying whether you made the  MyObject2__c field required in Skuid page layout, or the Salesforce page layout? 
  • Jack SanfordJack Sanford San Antonio, TX 💎💎
    edited May 26, 2018
    Salesforce page layout, but that didn’t actually solve it like I thought. I had to make the relationship master-detail instead of lookup and then it worked. Also confirmed it’s a known issue in Spring ‘18, it appears to have been fixed in Summer ‘18 if results in that sandbox are accurate
  • Mark DeSimoneMark DeSimone 🛠️ 
    edited May 30, 2018
    Jack, thanks for closing the loop on the pending resolution in Summer '18! 
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!