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?