To filter to documents that are missing a field, use q.eq("fieldName", undefined).

To filter to documents that are missing a field, use q.eq("fieldName", undefined).

[CONVEX Q(posts.js:getPostsBySearchTerm)] [LOG] {
  paginationOpts: {
    cursor: null,
    id: 2,
    numItems: 10
  },
  term: 'Hello'
}

[CONVEX Q(posts.js:getPostsBySearchTerm)] [LOG] {
  paginationOpts: {
    cursor: null,
    id: 2,
    numItems: 10
  },
  term: 'Hello'
}

const posts: PaginationResult<{ _creationTime: number}> = await ctx.db
  .query('posts')
  .withIndex('by_user_id', q => q.eq('userId', args.userId))
  .order('desc')
  .paginate(args.paginationOpts);

posts.page = posts.page.map(({ _creationTime }) => ({ _creationTime }));
return posts;

const posts: PaginationResult<{ _creationTime: number}> = await ctx.db
  .query('posts')
  .withIndex('by_user_id', q => q.eq('userId', args.userId))
  .order('desc')
  .paginate(args.paginationOpts);

posts.page = posts.page.map(({ _creationTime }) => ({ _creationTime }));
return posts;

export const getUsersPostById = query({
  args: { userId: v.id('users'), paginationOpts: paginationOptsValidator },
  handler: async (ctx, args) => {
    const posts = await ctx.db
      .query('posts')
      .withIndex('by_user_id', q => q.eq('userId', args.userId))
      .order('desc')
      .paginate(args.paginationOpts);

    posts.page = posts.page.map(({ _id }) => _id);
    return posts;
  },
});

export const getUsersPostById = query({
  args: { userId: v.id('users'), paginationOpts: paginationOptsValidator },
  handler: async (ctx, args) => {
    const posts = await ctx.db
      .query('posts')
      .withIndex('by_user_id', q => q.eq('userId', args.userId))
      .order('desc')
      .paginate(args.paginationOpts);

    posts.page = posts.page.map(({ _id }) => _id);
    return posts;
  },
});