SOQL List Reports Current User Can Access

Question

I have the following SOQL query:

SELECT Id, Name, Format, FolderName, LastModifiedDate
FROM Report
ORDER BY FolderName, Name

Which I am executing using this endpoint of the REST API:

/services/data/v35.0/query

Which works fine, except that it returns reports that the current user does not have access to.
How can I limit the results of this query to only include the reports that the user has access to?

The documentation mentions the UserRecordAccess object and how it can be used as a foreign key in your SOQL queries, and includes this example:

SELECT Id, Name, UserRecordAccess.HasReadAccess
FROM Account

This however does not appear to work for Reports, as this query:

SELECT Id, Name, UserRecordAccess.HasReadAccess
FROM Report

Yields the following error:

SELECT Id, Name, UserRecordAccess.HasReadAccess
                 ^
ERROR at Row:1:Column:18
Didn't understand relationship 'UserRecordAccess' in field path. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names.

Answer 1

The UserRecordAccess for reports can be accessed from the object itself. Try the following SOQL:

SELECT RecordId, HasReadAccess FROM UserRecordAccess WHERE UserId = '00524000001O6ME' AND RecordId = '00O24000004DCbL'

Above, the RecordId is the Report Id.

You must do this for a particular record or group of records (the report) and a particular user.