To check Reports in Private Folder

We can't extract Private Reports using package.xml  [because the Metadata API is for global metadata components only] but we can check using SOQL.

1. To Retrieve all private Reports, run the below SOQL

SELECT Id,Name,DeveloperName,Description,FolderName,Owner.Name,Owner.ISActive,CreatedBy.Name,CreatedDate,LastModifiedBy.Name,LastModifiedDate,LastRunDate,Format FROM Report USING SCOPE allPrivate

2. To Retrieve all private Reports owned by a Specific User
SELECT Id,Name,DeveloperName,Description,FolderName,Owner.Name,Owner.ISActive,CreatedBy.Name,CreatedDate,LastModifiedBy.Name,LastModifiedDate,LastRunDate,Format FROM Report USING SCOPE allPrivate WHERE Owner.Name LIKE 'Manju%' OR CreatedBy.Name LIKE 'Manju%'

Additional details :
1. KA
2. idea

Comments

  1. black titanium wedding band | titanium-arts.com
    black titanium wedding band. columbia titanium pants This beautiful wedding band titanium max has been designed titanium trim hair cutter reviews with titanium ring a beautiful red, diamond and gold ring on the top. The front is for the wedding ring. trex titanium headphones

    ReplyDelete

Post a Comment