36 replies

Query, filtering array of IDs

I have a jobsjobs schema which has a skillsskills property which is just an array of ID references.

jobs: defineTable({
  title: v.string(),
  clientId: v.id('users'),
  skills: v.optional(v.array(v.id('skills'))),
}).index('by_clientId', ['clientId'])

jobs: defineTable({
  title: v.string(),
  clientId: v.id('users'),
  skills: v.optional(v.array(v.id('skills'))),
}).index('by_clientId', ['clientId'])

In my application, I want to filter by skills. What is the best way to query a set union on skills and my args.

I know the following query won't work. I'm just wondering if something like this is possible:

let jobsQuery = ctx.db
  .query('jobs')
  .filter((q) => q.eq(q.field('status'), args.status))
  .filter((q) => {
    q.and(q.field('skills'), q.contains(q.field('skills'), args.skills))
  });

let jobsQuery = ctx.db
  .query('jobs')
  .filter((q) => q.eq(q.field('status'), args.status))
  .filter((q) => {
    q.and(q.field('skills'), q.contains(q.field('skills'), args.skills))
  });

Convex Community•15mo ago•

36 replies

wrux

Query, filtering array of IDs

I have a jobsjobs schema which has a skillsskills property which is just an array of ID references.

jobs: defineTable({
  title: v.string(),
  clientId: v.id('users'),
  skills: v.optional(v.array(v.id('skills'))),
}).index('by_clientId', ['clientId'])

jobs: defineTable({
  title: v.string(),
  clientId: v.id('users'),
  skills: v.optional(v.array(v.id('skills'))),
}).index('by_clientId', ['clientId'])

let jobsQuery = ctx.db
  .query('jobs')
  .filter((q) => q.eq(q.field('status'), args.status))
  .filter((q) => {
    q.and(q.field('skills'), q.contains(q.field('skills'), args.skills))
  });

let jobsQuery = ctx.db
  .query('jobs')
  .filter((q) => q.eq(q.field('status'), args.status))
  .filter((q) => {
    q.and(q.field('skills'), q.contains(q.field('skills'), args.skills))
  });

Continue the conversation

Join the Discord to ask follow-up questions and connect with the community

Convex Community

Join the Convex Discord! Explore Convex, the backend platform that keeps your app in sync.

15,960 Members

Join

Query, filtering array of IDs

Query, filtering array of IDs

Continue the conversation

Convex Community

Continue the conversation

Convex Community

Similar Threads