[SalesForce] Notes & Attachments Cant find using soql

I did not get any result from querying notes and attachment.

Setup
I create a custom object. I added notes and attachment to the custom object
I created soql that filter by parentId and it looks like this.

I created a record on the custom object named 'record1', and on the related tab, I upload notes and attachments named attachment1.

I created a query that looks like this

Select name from attachment where parentId =:(record1 Id);

same with note

Select title from Notes where parentId =:(recordthe 1 Id);

result is 0 record.

Best Answer

In Spring'16 release Salesforce introduced Files uploaded to the Attachments related list on records are uploaded as Salesforce Files, not as attachments in Salesforce Files Settings:

Files that you upload to the Notes & Attachments related list on records in Salesforce Classic are now Salesforce Files objects, rather than the old attachment objects. A new org pref in Salesforce Files Settings controls this behavior, and is enabled by default for new orgs.

The following SOQL query would allow you to get Ids of Files (Attachments) and New Notes related to the record

SELECT ContentDocumentId,Id,LinkedEntityId,ShareType 
FROM ContentDocumentLink WHERE LinkedEntityId = 'YourRecordId'

Related Solutions

[SalesForce] Uploading attachments using ForceTk

You will need ParentId to associate to ,

Here is sample code for same

function uploadattachment(files,parentId){
    var client = new forcetk.Client();
    // Get the token from Visualforce
    client.setSessionToken('{!$Api.Session_ID}');
    var file =files[0];
     $('#loadingmessage').show();
     client.createBlob('Attachment', {
        'ParentId': parentId,
        'Name': file.name,
        'ContentType': file.type
        }, file.name, 'Body', file, function(response){
        console.log(response);
      }, function(request, status, response){
          $("#message").html("Error: " + status);
     });
}

You will call this function above with parent Id and file object

var file = $("#file")[0].files[0];
uploadattachment(file,'pass your parent Id here');

[SalesForce] SOQL Query – Parent Child Query Related to Specific Object

Try your SOQL from Attachment instead of doing it from Case

SELECT Id,ParentId From Attachment 
WHERE ParentId IN (
SELECT Id FROM Case
WHERE Case_Consumer_Contract_CC__c != null 
AND CreatedDate > 2016-02-01T00:00:00.000Z
) 
AND (NOT Description LIKE 'Redaction Audit%')
AND Parent.Type = 'Case'

Note:

ParentId field will have Case objects Id

Update:

Added AND Parent.Type = 'Case' since Attachment is polymorphic table and free selects with loose conditions might have huge impact on your performance

Best Answer

Related Solutions

[SalesForce] Uploading attachments using ForceTk

[SalesForce] SOQL Query – Parent Child Query Related to Specific Object

Related Topic