How to configure a model to be compatible with the USING SCOPE soql clause

  • 1
  • Question
  • Updated 3 years ago
  • Answered
In the Winter 15 release, they added the SOQL clause called "USING SCOPE" (see: https://help.salesforce.com/apex/HTViewSolution?id=000204543&language=en_US)

Is there any way of making a Model with this feature? If it's not yet supported by Skuid, can anyone tell me how I can access the SOQL generator so I can override the skuid function until it's supported?

Thanks

Mat
Photo of Mathieu

Mathieu

  • 156 Points 100 badge 2x thumb

Posted 3 years ago

  • 1
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
While Skuid might not yet directly support this additional SOQL clause,  I believe you should be able to query the data directly using our REST API model services.  Here is how: 

Set up a model service to query your salesforce domain:   Important factors here are the Domain URL,  the Authentication method and the Request Header where the API sessionID is passed. 



Then on your skuid page build models that use this REST Model Service.   Your service URL will look somthing like this: 

/services/data/v34.0/query?q={{#encodeUrl}}SELECT Name, ID, OtherFields FROM sObjectName  WHERE {{#name}}(Name LIKE '{{#name}}{{#decodeUrl}}{{name}}{{/decodeUrl}}{{/name}}'){{#FieldTwo}}AND (FieldTwo LIKE '{{#decodeUrl}}{{FieldTwo city}}{{/decodeUrl}}'){{/city}} USING SCOPE Mine 

This model service can be both Read and Write. 
Photo of Mathieu

Mathieu

  • 156 Points 100 badge 2x thumb
Thank you, this is very useful!