Features / Usability

Posted by Tom Jarvis 26 Mar 2012 05:26 GMT-0000 posts: 215

In regards to show "pages that have been created by a certain user(s)", Wiki List Pages can show you the page creator and Last editor. To show those columns in the list pages report, go to Admin home, Wiki, Page Listings tab and select "Creator" and "Last modified by". Then go to Wiki, List Pages.

And there is a way to list all the things a particular user has contributed to.

First go to Admin home, Community, General Settings tab, and select "Show user's contribution on the user information page", and Change preferences.

Once that is set, go to Admin, Users. On the "Admin Users" page, at the right of the user's row there is an icon for User Information. Click on that Icon, and then, on the "User Information" page that comes up, click on the "User Contribution" tab.

Posted by seromine 27 Mar 2012 14:43 GMT-0000 posts: 130

Thanks for your quick response!

I was aware of the above, but looking more specifically to be able to filter by creator and/or modified date. So, on a wiki page and most likely using a plugin or module, I could show only wiki pages created and/or modified by a certain user?

Do you know of a way to get that specific?

Posted by Tom Jarvis 28 Mar 2012 01:51 GMT-0000 posts: 215

Table tiki_history has the history of wiki page updates. It is where the wiki page contributor information comes from. If you have the SQL plugin enabled then you can extract the information:

{SQL(db=>local)} 
SELECT pageName, version, FROM_UNIXTIME(lastModif) as Date, user
FROM tiki_history 
WHERE pageName = 'pagename' 
ORDER BY pageName, lastModif 
{SQL}

The user and lastModif for version 1 of the page is the same as the creator and created columns for the page in the tiki_pages table. And the user and lastModif columns in the tiki_pages table is the same as the user and lastModif of the last entry for that page in the tiki_history table.

{SQL(db=>local)} 
SELECT pageName, version, FROM_UNIXTIME(lastModif) as Date, user
FROM tiki_history 
WHERE user = 'user' 
ORDER BY pageName, lastModif 
{SQL}

The tiki_history table can get pretty large. Since I am mainly the only person that updates my pages, sometimes I truncate it. But if you do that, you loose the contributor information.