• Dileep Ratnayake
  • 0 Points
  • Member since 2020

  • Chatter
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 2
  • 0
Hi everyone,

I'm trying to run a query with LIKE condition but I get a null response when I add the LIKE condition.
SELECT Property__r.Geolocation__Latitude__s,Property__r.Geolocation__Longitude__s,Property__r.Name,Id,ListingHeadline__c,Name,PriceDisplayedWebsite__c,PropertySuburb__c,PropertyType__c,Property_Zone__c,Property__c,Reference__c,TotalFloorArea__c FROM Opportunity WHERE IsClosed=false AND PublishedToWebsite__c=true AND Reference__c LIKE '%JG%' AND Property__c IN (SELECT Id FROM Property__c WHERE PublishedToWebsite__c=true)

If I remove the 
Reference__c LIKE '%JG%'

part, it works fine I get the results.
And I can confirm it does have data that match the LIKE condition.

Any idea on what's wrong with the above query?
Hi everyone,

Fairly new to SalesForce.
I have been successfully retreiving information through SOQL with the help of workbench.
I need to figure out a way to retrieve files linked to an opportunity.

In short I'm trying to retrieve the photos uploaded against an opportunity.

I managed to get some output by running the below query.
SELECT ContentDocumentId,Id,IsDeleted,LinkedEntityId,ShareType,SystemModstamp,Visibility FROM ContentDocumentLink WHERE LinkedEntityId = 'THE_OPPORTUNITY_ID'
Seems like there is another table that this info needs to be retrieved from.
Is there a way to retrieve a publicly accessible URL for the above files?