I m trying to do a semi complicated filter of getting users Prisma #orm-help

I’m trying to do a semi-complicated filter of gett...

cfree

03/15/2019, 1:00 AM

I’m trying to do a semi-complicated filter of getting users that DON’T have an Office assigned, but it’s not giving me the results I expect… There are users in my database that have no Office set Inside resolver:

Copy code

const offices = [
    'PRESIDENT': 'President',
    'VICE_PRESIDENT': 'Vice President',
    'SECRETARY': 'Secretary',
    'TREASURER': 'Treasurer',
];

return ctx.db.query.users(
      {
        where: {
          AND: [
            // Works fine
            { accountStatus: 'ACTIVE' },
            // Works fine
            { accountType_in: args.accountTypes },
            // Returns nothing
            { office_not_in: Object.keys(offices) },
          ],
        },
      },
      info,
    );

Schema:

Copy code

enum Office {
  PRESIDENT
  VICE_PRESIDENT
  SECRETARY
  TREASURER
}

type User {
  ...
  office: Office
}

cfree

03/15/2019, 1:02 AM

I’ve tried numerous combinations of

AND

OR

NOT

office_in

office_not

, and

office_not_in

, but I can’t crack this one

cfree

03/15/2019, 1:02 AM

Thoughts? Suggestions?

cfree

03/15/2019, 1:19 AM

office: null,

works 🤦

jblevins

03/15/2019, 2:20 AM

Is there a stack trace or does it just not give you the correct results?

lawjolla

03/15/2019, 7:05 AM

‘Offices’ is an array, not an object.

cfree

03/15/2019, 2:11 PM

@lawjolla I’m grabbing the keys to make an array

cfree

03/15/2019, 2:12 PM

@jblevins No stack trace, no error, just didn’t return any results

cfree

03/15/2019, 2:12 PM

I got it working with this:

Copy code

return ctx.db.query.users(
      {
        where: {
          AND: [
            { accountStatus: 'ACTIVE' },
            { accountType_in: args.accountTypes },
            { office: null },
          ],
        },
      },
      info,
    );

2 Views

Open in Slack

Previous Next