Model condition 'includes' operator malforming SOQL query

  • 1
  • Problem
  • Updated 3 years ago
  • (Edited)
This is a continuation of a previous issue I had here: https://community.skuid.com/skuid/topics/cannot-use-userinfo-fields-for-includes-in-model-condition

I'm making changes to this page and am running into the same issue of my query being malformed. Here is the query that is being generated:

 SELECT Comments__c,Level_1__c,Level_2__c,Level_3__c,Recommendation__c,TBA_Selection__c,TBA_Selection__r.Name,Tags__c,Value__c,Score_Type__c,Probe_questions_for_in_person_interviews__c,Id FROM TBA_Score__c WHERE (Level_1__c = 'Activity')AND(Level_2__c = 'Written Assignment')AND(Level_3__c = 'Question 1')AND(Score_Type__c = 'Written Assessment')AND(TBA_Selection__c = 'a2A80000000SOS0EAO')AND(Question__c = '1')AND(Tags__c = 'Written#, Q1#')AND((TBA_Selection__r.X2nd_Reviewer__c includes 'Yinnie Tse')OR(TBA_Selection__r.Written_Focus_Reviewer_Q1__c includes 'Yinnie Tse'))AND(Reviewer__c = '005800000046Q0DAAU')  


And this is what it should look like (and what works when I test from the Developer Console), notice the added parentheses around my 'include' value:

SELECT Comments__c,Level_1__c,Level_2__c,Level_3__c,Recommendation__c,TBA_Selection__c,TBA_Selection__r.Name,Tags__c,Value__c,Score_Type__c,Probe_questions_for_in_person_interviews__c,Id FROM TBA_Score__c WHERE (Level_1__c = 'Activity')AND(Level_2__c = 'Written Assignment')AND(Level_3__c = 'Question 1')AND(Score_Type__c = 'Written Assessment')AND(TBA_Selection__c = 'a2A80000000SOS0EAO')AND(Question__c = '1')AND(Tags__c = 'Written#, Q1#')AND((TBA_Selection__r.X2nd_Reviewer__c includes('Yinnie Tse'))OR(TBA_Selection__r.Written_Focus_Reviewer_Q1__c includes ('Yinnie Tse')))AND(Reviewer__c = '005800000046Q0DAAU')


Again, I don't see an option to use 'contains' instead of 'include' or '='. Any updates on this?

Thanks!
Eulogio
Photo of Eulogio Gallo

Eulogio Gallo

  • 1,874 Points 1k badge 2x thumb
  • frustrated

Posted 3 years ago

  • 1

Be the first to post a reply!