Web Dev Cody•4mo ago

Get all documents where storageId not null

How would I achieve this query? I have a table with an index on an optional storageId field, but when doing the withIndex I can't seem to pass gte('file', undefined)

5 Replies

Convex Bot•4mo ago

Thanks for posting in <#1088161997662724167>. Reminder: If you have a Convex Pro account, use the Convex Dashboard to file support tickets. - Provide context: What are you trying to achieve, what is the end-user interaction, what are you seeing? (full error message, command output, etc.) - Use search.convex.dev to search Docs, Stack, and Discord all at once. - Additionally, you can post your questions in the Convex Community's <#1228095053885476985> channel to receive a response from AI. - Avoid tagging staff unless specifically instructed. Thank you!

lee•4mo ago

yeah this is an issue with our typescript types, sorry. You should be able to do q.gte("file", null as any)

Web Dev CodyOP•4mo ago

ian•4mo ago

Probably just gt?

Web Dev CodyOP•3mo ago

yeah, just gt

const publicVideos = await ctx.db
      .query("videos")
      .withIndex("isPublic_index_videoFile", (q) =>
        q.eq("isPublic", true).gt("videoFile", null as any),
      )
      .order("desc")
      .take(20);

const publicVideos = await ctx.db
      .query("videos")
      .withIndex("isPublic_index_videoFile", (q) =>
        q.eq("isPublic", true).gt("videoFile", null as any),
      )
      .order("desc")
      .take(20);

Get all documents where storageId not null

Did you find this page helpful?