zid•16mo ago

filtering with nested properties

is it possible to filter with nested properties?

    const users = await db
      .query("users")
      .withIndex("by_lastActiveAt")
      .filter((q) => q.eq(q.field("attributes.attribute"), {attributeName}))
      .paginate(paginationOpts);

    const users = await db
      .query("users")
      .withIndex("by_lastActiveAt")
      .filter((q) => q.eq(q.field("attributes.attribute"), {attributeName}))
      .paginate(paginationOpts);

2 Replies

lee•16mo ago

yes, and that is the correct syntax. are you observing problems? as an aside, the index is only being used for ordering here, not filtering. if you want to use it for both, you can define the index as .index("by_attribute_lastActiveAt", ["attributes.attribute", "lastActiveAt"]) and apply the filter with .withIndex("by_attribute_lastActiveAt", q => q.eq("attributes.attribute", {attributeName}))

zidOP•16mo ago

worded my question incorrectly, i meant to ask whether this will be supported in the future but i guess this does work! regarding the ordering, the index was intended for the ordering, but good aside/reminder on the [attributes.attribute]. Thank you that was helpful!

filtering with nested properties

Did you find this page helpful?