[librecat-dev] cql query for record with no projects

[Patrick Hochstenbach]

Hi

I don’t think CQL supports these type of ‘null’ values or ‘exists’ queries. What you can do is do a raw query. E.g. the elastic search store can do this:


my $hits = $store->bag->search(
    query => {
        # All records that have a project field
        exists => {
            field => ‘project'
        }
    } ,
    limit => 1000);

BR 
Patrick

> On 27 May 2019, at 13:47, Jonathan NORRIS <jnorris at ist.ac.at> wrote:
> 
> Hey,
> 
> I am trying to retrieve all records with a project field but can't figure out the CQL for it. Does anybody know how to write CQL to get a result like "project != null"?
> 
> Thanks,
> Jonathan
> 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/