Calling all developers! We invite you to provide your input on Feature Experimentation by completing this brief survey.

 

AI OnAI Off
Per Nergård
Per Nergård
Oct 17, 2016
  1796
(2 votes)

List editors and how many pages they have created.

Wouldn't it be fun to have a list wich presented all editors and how many pages they have created? Maybe not so fun but in one case this is what I wanted to present. So i whipped togheter a simple aspx page that does just that.

Image highscore.jpg

As usal code over at my Gist.

Oct 17, 2016

Comments

Henrik Fransas
Henrik Fransas Oct 18, 2016 08:28 AM

Nice, or you can play around with SQL and with this simple query get content per contenttype per user... ;-)

Select CreatorName, ct.[Name], COUNT(*) NrOfContent
From tblContent c inner Join tblContentType ct on c.fkContentTypeID = ct.pkID
Group by CreatorName, ct.[Name]
order by CreatorName, NrOfContent Desc, ct.[Name]

Oct 18, 2016 08:47 AM

I don't like SQL :)

This was a quick hack. Have been thinking of doing more of a dashboard thing with some charts and stuff.

Henrik Fransas
Henrik Fransas Oct 18, 2016 08:56 AM

I love SQL it is so powerful!

Ok, sounds great, add it as a gadget also so you can have it on the dashboard.

Aria Zanganeh
Aria Zanganeh Oct 18, 2016 01:23 PM

Great job mate.. It could be good idea to have another column for "Site" so you know per site! And another dashboard of number of awaiting pages for approval per user :D Motivate lazy people :)

May 15, 2017 02:07 PM

Please login to comment.
Latest blogs
Level Up with Optimizely's Newly Relaunched Certifications!

We're thrilled to announce the relaunch of our Optimizely Certifications—designed to help partners, customers, and developers redefine what it mean...

Satata Satez | Jan 14, 2025

Introducing AI Assistance for DBLocalizationProvider

The LocalizationProvider for Optimizely has long been a powerful tool for enhancing the localization capabilities of Optimizely CMS. Designed to ma...

Luc Gosso (MVP) | Jan 14, 2025 | Syndicated blog

Order tabs with drag and drop - Blazor

I have started to play around a little with Blazor and the best way to learn is to reimplement some old stuff for CMS12. So I took a look at my old...

Per Nergård | Jan 14, 2025

Product Recommendations - Common Pitfalls

With the added freedom and flexibility that the release of the self-service widgets feature for Product Recommendations provides you as...

Dylan Walker | Jan 14, 2025

See all blogs