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 3.1
edited by bougault
on 2022/12/20 14:46
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -1,6 +1,18 @@
1 1  {{velocity}}
2 -#set($query = $services.query.xwql("from doc.object(XWiki.XWikiUsers) as users where users.email <> ''"))
2 +#set($query = $services.query.xwql("from doc.object(XWiki.XWikiUsers) as users"))
3 3  #set($users = $query.execute())
4 4  
5 -$users
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 + user $userId lastname does not match privacy rules
11 + #end
12 +
13 + #set($email = $obj.get("email"))
14 + #if($email != "")
15 + user $userId email does not match privacy rules
16 + #end
17 +#end
6 6  {{/velocity}}