10 Dec
2010
10 Dec
'10
9:23 p.m.
Hi,
I'm looking to build a script that will delete all registered users from our XWiki
that did not complete the registration by replying to the email and look like SPAM
registration (firstname = lastname)
The property of the object of XWiki.XWikiUsers -> active (of type boolean) is false
Now this is my first attempt to HQL and i need some help
#foreach($result in $xwiki.search("
select distinct doc.fullName,
prop.value
from XWikiDocument as doc,
BaseObject as obj,
StringProperty as prop,
BooleanProperty as acti
where obj.className='XWiki.XWikiUsers'
and obj.name=doc.fullName
and prop.id.id=obj.id
and prop.name='first_name'
and prop.value is not empty
and prop.value in (
select prop.value
from StringProperty as prop2
where prop2.id.id=obj.id
and prop2.name='last_name'
and prop2.value=prop.value)
and acti.id.id=obj.id
and acti.name='active'
and acti.value=false
"))
* $result.get(0) - $result.get(1)
#end
BooleanProperty is a wild guess of me looking at StringProperty as a example
The query should look for users where first-name = last-name and active is false
If possible I would like to check if the document creation date/time is more then 8 hours
old
Gerritjan