Hi Arnaud,
On Sep 24, 2009, at 5:51 PM, Arnaud bourree wrote:
Hello,
I test it also in velocity without success.
I try an other code
{{groovy}}
def sql = ""
count = 0
for (item in xwiki.searchDocuments(sql)) {
u = xwiki.getDocument(item)
xu = u.getObject('XWikiUsers')
if (null == xu) continue
count++
print item+"\n"
}
print "**Total "+count+"**\n"
{{/groovy}}
I still not found jdoe
But if I edit XWiki.jdoe page in object mode there is XWikiUsers
object !!!
My take is that you're using MySQL as the database and in default mode
which doesn't differentiate lowercase and uppercase.
Could that be it?
Thanks
-Vincent
Arnaud.
2009/9/24 Oana Tabaranu <oana.tabaranu(a)xwiki.com>om>:
> Hi Arnaud,
>
> I have tested your query in velocity and it works fine for me:
> #set($users =$xwiki.searchDocuments(", BaseObject obj where
> obj.name =
> doc.fullName and obj.className = 'XWiki.XWikiUsers' and
> doc.fullName <>
> 'XWiki.Admin' and doc.fullName <> 'XWiki.TEST' and doc.fullName
<>
> 'XWiki.dummy'"))
> #foreach ($u in $users)
> $u
> #end
> My result is:
> XWiki.JDOE
> XWiki.jdoe
>
> Oana
>
> Arnaud bourree wrote:
>> Hello,
>>
>> I'm building a migration to LDAP page for my company on one XWiki
>> 2.0
>> RC1 instance.
>> For this I need to list all users registered in.
>> I used the following code to list users:
>> for(u in xwiki.wrapDocs(xwiki.searchDocuments(", BaseObject obj
>> where
>> obj.name = doc.fullName and obj.className = 'XWiki.XWikiUsers' and
>> doc.fullName <> 'XWiki.Admin' and doc.fullName <>
'XWiki.TEST' and
>> doc.fullName <> 'XWiki.dummy'"))) {
>> ...
>> }
>>
>> That looks good, most of my users are listed.
>> But at least one user is missing: one user register as JDOE one time
>> and one other time as jdoe
>> So there are two John Doe users: XWiki.jdoe and XWiki.JDOE but my
>> loop
>> only find JDOE and not jdoe
>>
>> What it is wrong in my request?
>>
>> Arnaud.