How to do conditionally filtering with Directus Javascript SDK?

Question

Problem

I am not able to change the default AND operator in the curl call like explained in the directus api docs:

https://docs.directus.io/api/reference.html#filtering

Question

How can I enable the OR operator in order to filter based on different criteria like the code below?

Code

return client
      .getItems('privileges', {
        fields: ['*', 'image.filename', 'image.data.full_url', 'attachment.*', 'partner.*.*', 'location.*', 'category.*.*', 'type.icon.data.full_url'],
        meta: ['total_count', 'result_count'],
        sort: 'created_on',

    filter: {
      'location.city': {
        'contains': lowerQ
      },
      // 'location.title': {
      //   'contains': lowerQ
      // },
      category: {
        'eq': category,
      },
      available_from: {
        'lte': 'now'
      },
      available_until: {
        'gte': 'now'
      },
    },
    limit,
    offset,
  }).then(response => {
    dispatch(getPrivilegesSuccess(key, response))
  }).catch(error => {
    console.log(error);
    dispatch(getPrivilegesFail(key, error))
  });

So, the comments out code is a different criteria that should be able to match on inserted text using the or operator. Instead it is using the AND operator in the curl output api call at the moment.

Would appreciate any type of help!

Shea Lavington · Accepted Answer · 2019-09-10 09:01:45Z

4

filter: {
  field_one: {
    'eq': 'hello'
  },
  field_two: {
    'logical': 'or',
    'eq': 'world'
  },
},

Just add 'logical': 'or' to the object you'd like to use as your 'OR'

edited Sep 10, 2019 at 9:01

answered Sep 10, 2019 at 8:53

Shea Lavington

4952 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

KiwiCoder Over a year ago

WHy is the logical on the available_until?

KiwiCoder Over a year ago

Thanks for your help. Could you tell me where this is explained in the SDK docs?

Collectives™ on Stack Overflow

How to do conditionally filtering with Directus Javascript SDK?

Problem

Question

Code

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Problem

Question

Code

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related