Apex Code Development You need to sign in to do that
Don't have an account?
bond006 Querying reports from folders
hey guys, I have written a code using objects called "Folders" & "Reports" in such a way that I get the Id from Folders object and by using that I am getting reports from Reports Object. But I was supposed to show the reports which are accesible by the user who logged in. There is no option which shows whether the current user has access to reports or not?
My code:
for(Folder tmp:[SELECT AccessType,Id,IsReadonly,Name,DeveloperName,Type FROM Folder WHERE Type = 'Report']){
if(tmp.DeveloperName=='Referrals'){
refId = tmp.Id;
}
}
refrportlst = report(refId);
List<Report> tempreport = [SELECT Name, Id,OwnerId, description, DeveloperName, SystemModstamp FROM report where OwnerId=:refId order by name];
Note: now I need to show the reports which the current user can access to!
Please let me knowis there a way to do it.
My code:
for(Folder tmp:[SELECT AccessType,Id,IsReadonly,Name,DeveloperName,Type FROM Folder WHERE Type = 'Report']){
if(tmp.DeveloperName=='Referrals'){
refId = tmp.Id;
}
}
refrportlst = report(refId);
List<Report> tempreport = [SELECT Name, Id,OwnerId, description, DeveloperName, SystemModstamp FROM report where OwnerId=:refId order by name];
Note: now I need to show the reports which the current user can access to!
Please let me knowis there a way to do it.
Please refer to the link below to show only records that relate to the current user-
https://www.quickbase.com/help/default.html#curuser_views.html
Hope this helps.