{sql:dataSource=wiki|output=wiki}
select repo_group_code || '.' || repo_name as name, repo_size/1024/1024 as size from owl_repository where repo_group_code = 'svn' and repo_status <> 'deleted' order by repo_size desc limit 5
{sql}
Chart
3D
false
ylabel
Number of Revisions
timePeriod
Day
categoryLabelPosition
down45
type
line
dataOrientation
vertical
title
Top 5 Repository Revisions
colors
green
Wiki Markup
{sql:dataSource=wiki|output=wiki}
select d.repo_group_code || '.' || d.repo_name as name, max(d.repo_revision) as revision from owl_repository_data d JOIN owl_repository r ON d.repo_group_code = r.repo_group_code and d.repo_name = r.repo_name where r.repo_status <> 'deleted' and d.repo_group_code = 'svn' group by name order by revision desc limit 5
{sql}
...
Chart
3D
false
ylabel
Size in Megabytes
timePeriod
Day
categoryLabelPosition
down45
type
bar
dataOrientation
vertical
title
Top 5 Repository Sizes
colors
blue
Wiki Markup
{sql:dataSource=wiki|output=wiki}
select repo_group_code || '.' || repo_name as name, repo_size/1024/1024 as size from owl_repository where repo_group_code = 'it.svn' and repo_name <> 'subversion' and repo_status <> 'deleted' order by repo_size desc limit 5
{sql}
Chart
3D
false
ylabel
Number of Revisions
timePeriod
Day
categoryLabelPosition
down45
type
line
dataOrientation
vertical
title
Top 5 Repository Revisions
colors
green
Wiki Markup
{sql:dataSource=wiki|output=wiki}
select d.repo_group_code || '.' || d.repo_name as name, max(d.repo_revision) as revision from owl_repository_data d JOIN owl_repository r ON d.repo_group_code = r.repo_group_code and d.repo_name = r.repo_name where r.repo_status <> 'deleted' and d.repo_group_code = 'it.svn' and d.repo_name <> 'subversion' group by name order by revision desc limit 5
{sql}