Find articles currently in editing (locked)

Help / Discuss
1

Hi.

I’ want to see which articles are currently in editing (locked). I use this code:

== List users currently editing pages ==

{{velocity}}
## List users currently editing pages
#set($hql = "select lock from XWikiLock lock order by lock.date desc")
#set($results = $xwiki.search($hql))
|=#|=Name|=Article|=Date
#set($count = 1)
#foreach ($item in $results)
 |$count|[[$item.userName]]|$item.docId|$item.date
 #set($count = $count + 1)
#end
{{/velocity}}

What I am unable to do is convert the docId into a document title or something similar. I’m not so familiar with database queries.

Anyone able to help?

Thanks and regards, Simpel

2

3 comments:

Try this:

{{velocity}}
#set ($query = "select doc.fullName, lock.userName from Document as doc, XWikiLock as lock where doc.id = lock.docId")
$services.query.xwql($query).execute()
{{/velocity}}
1 Like