Hello fellow community members
Wanted to share with you few queries I worked on with a customer. We wanted to find:
- The amount of report outputs in the Users folders
- The different reports and file types (and counts)
Feel free to use and adapt the following SQL:
select jiresource.name, jiresourcefolder.uri from jiresource
join jiresourcefolder on jiresourcefolder.id = jiresource.parent_folder
where jiresource.id in (select id from jicontentresource where file_type = 'pdf')
select count(*)from jiresource
join jiresourcefolder on jiresourcefolder.id = jiresource.parent_folder
where jiresource.id in (select id from jicontentresource where file_type = 'pdf')
select jiresource.name, jiresourcefolder.uri from jiresource
join jiresourcefolder on jiresourcefolder.id = jiresource.parent_folder
where jiresourcefolder.uri like '%/users/%'
Hope this helps -Nika