Failed to execute template. Cause: [Access denied when checking [script] access to [xwiki:Collaboratory.UX.HbpSkin.WebHome] for user [xwiki:XWiki.Admin]]. Click on this message for details.

Query Users - HBP Wiki

IAM21 instance, do not create collab nor modify a team, your changes will be lost


Changes for page Query Users

Last modified by bougault on 2023/09/28 17:01

From version 2.1
edited by bougault
on 2022/12/20 12:58
Change comment: There is no comment for this version
To version 10.1
edited by bougault
on 2022/12/20 14:52
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -1,6 +1,29 @@
1 -{{velocity}}
2 -#set($query = $services.query.xwql("from doc.object(XWiki.XWikiUsers) as users where users.email <> ''"))
1 +{{velocity output="no"}}
2 +#set($query = $services.query.xwql("from doc.object(XWiki.XWikiUsers) as users"))
3 3  #set($users = $query.execute())
4 +#set($warnings = [])
5 +#foreach($userId in $users)
6 + #set($userDoc = $xwiki.getDocument($userId))
7 + #set($obj = $userDoc.getObject("XWiki.XWikiUsers"))
8 + #set($lastName = $obj.get("last_name"))
9 + #if(!$lastName.matches('[A-Z]{1}\.'))
10 + $warnings.add("user $userId lastname does not match privacy rules")
11 + #end
4 4  
5 -$users
13 + #set($email = $obj.getValue("email"))
14 + #if($email != "")
15 + $warnings.add("user $userId email does not match privacy rules")
16 + #end
17 +#end
6 6  {{/velocity}}
19 +
20 +{{velocity}}
21 +
22 +{{html clean="false"}}
23 +<ul>
24 +#foreach($warning in $warnings)
25 + <li>$warning</li>
26 +#end
27 +</ul>
28 +{{/html}}
29 +{{/velocity}}