[librecat-dev] cql query to get users by department

[Patrick Hochstenbach]

Hello

The ‘department’ index is not defined in the default configuration files for user queries.

You need to add it in your layer in  a new configuration file (e.g. myindexes.yml) with content:

store:
 search:
   options:
     bags:
       user:
         cql_mapping:
           indexes:
             department:
                op:
                  'all': true
                  'any': true
                  '=': true
                  'exact': {field: 'department.name.exact'}
                field: ['department._id', 'department.name’]

Then reindex your data ‘./index.sh’ index.

Now you can find all the users with a affiliation:

$ bin/librecat user list 'department = 9999’

Or as you wrote in your Perl code

Best regards
Patrick

> On 12 Mar 2018, at 12:30, Jonathan NORRIS <jnorris at ist.ac.at> wrote:
> 
> Hello,
> 
> I haven't been able to find an example of this in the source code. Basically I just want to query for all users of a particular department. My attempt here is not working:
> 
> get '/groups/:group' => sub {
> 
>     my $group_name = params->{group};
> 
>     my %search_params = (cql => ["department=$group_name"]);
> 
>     my $users = LibreCat->searcher->search('user', \%search_params);
> 
>     template 'groups/group', {
>       group_name => $group_name,
>       users => $users
>     };
> };
> 
> My user looks like this:
> 
> _id: A0E86400-1266-11E8-9236-8266539212D2
> account_status: active
> date_created: 2018-02-15T15:41:03Z
> date_updated: 2018-03-12T09:20:08Z
> department:
> - _id: NiBa
> email: james.wallace at ist.ac.at
> first_name: James
> full_name: James Wallace
> last_name: Wallace
> But when I run the query with 'NiBa' as the group name then I get no results. Is my syntax or cql query correct?
> 
> Thanks,
> 
> Jonathan Norris
> 
> IST Austria
> _______________________________________________
> librecat-dev mailing list
> - send list mails to librecat-dev at lists.uni-bielefeld.de
> - to unsubscribe or change options, visit https://lists.uni-bielefeld.de/mailman2/cgi/unibi/listinfo/librecat-dev
> - project website: http://librecat.org/

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 488 bytes
Desc: Message signed with OpenPGP
URL: <http://lists.uni-bielefeld.de/mailman2/unibi/public/librecat-dev/attachments/20180312/8c6e94f9/attachment.asc>