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

[Patrick Hochstenbach]

No, it will add to the already existing configuration options (as if you would put these things inline into the configuration store.yml file).
Configurations can be spread in many files and will be merged when running LibreCat programs.

> On 12 Mar 2018, at 16:24, Jonathan NORRIS <jnorris at ist.ac.at> wrote:
> 
> Thank you for your help. Will adding this overwrite the original index data in store.yml?
> 
> On 03/12/2018 04:15 PM, Patrick Hochstenbach wrote:
>> Please find in the attachment a correct configuration file
>> 
>> BR
>> Patrick
>> 
>> 
>> 
>> 
>>> On 12 Mar 2018, at 16:06, Patrick Hochstenbach <Patrick.Hochstenbach at UGent.be>
>>>  wrote:
>>> 
>>> 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/
>>> _______________________________________________
>>> 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/65f03ff0/attachment.asc>