Re: [xwiki-devs] Question about User Query with Solr

Hi Fitz, The group membership information is stored on the group page while the user profile (last modification date) is on a separate page. This means you need to query information that is stored on two separate (database or index) "rows" (the row that corresponds to the group and the row that corresponds to the user). This requires performing a join, either on the database (using HQL or XWQL) or on the Solr index. The main difference between the two is that a database query targets a single wiki (so if you need the users from all the wikis then you need to iterate over all the wikis and perform the query on each of them) while a Solr query targets all the wikis (so you can get all the users from all the wikis in one single query). (A) Database Query Unfortunately the search REST resource doesn't support XWQL ( http://jira.xwiki.org/browse/XWIKI-13458 ) so you'll have to rely on HQL. For the record, the XWQL query would look like: from doc.object(XWiki.XWikiUsers) as userObj, Document as groupDoc, groupDoc.object(XWiki.XWikiGroups) as groupObj where groupObj.member = doc.fullName and groupDoc.fullName = 'XWiki.XWikiAdminGroup' and doc.date > :date The equivalent HQL query is a lot more complex. I'll let you figure it out. See http://extensions.xwiki.org/xwiki/bin/view/Extension/Query+Module . Once you have it you can use /wikis/{wikiName}/query?q={query}&type=hql (B) Solr Query In order to perform a (useful) join on the Solr index you need to be able to specify both the query (q) and the filter query (fq). Unfortunately the Solr REST resource doesn't support specifying the filter query so you can't use that. Fortunately there is a Solr service used by the search suggest which supports specifying the filter query. This is how you could build the URL from JavaScript (to give you an idea): new XWiki.Document('SuggestSolrService', 'XWiki').getURL('get', jQuery.param({ outputSyntax: 'plain', query: [ 'q={!join from=property.XWiki.XWikiGroups.member_string to=fullname}fullname:XWiki.XWikiAdminGroup', 'fq=date:[NOW/DAY TO *]' ].join('\n'), input: '*', nb: 8, })) This computes the URL to retrieve the users from the AdminGroup that have been modified today. The response is XML by default but you can get JSON with media=json in the query string. Hope this helps, Marius On Tue, Jun 14, 2016 at 3:56 PM, fitz <leefits(a)gmail.com> wrote: