14 replies

Hey I wanted to ask, is there a way to

Hey I wanted to ask, is there a way to specify by which field you want to sort collection with index ?
for example
I have list of companies that have year revenue, and want to filter them based on the revenue, but I want to sort them based on creation date.

for example

export const getCompanies = query({
    args: {
        minRevenue: v.number(),
        maxRevenue: v.number()
    },
    handler: async (ctx, args) => {
        const companies = await ctx.db.query("companies").withIndex('revenue', (q) => q.and(q.lte(q.field("revenue"), args.maxRevenue), q.gte(q.field("revenue"), args.minRevenue)),order('desc');
        return companies;
    }
});

export const getCompanies = query({
    args: {
        minRevenue: v.number(),
        maxRevenue: v.number()
    },
    handler: async (ctx, args) => {
        const companies = await ctx.db.query("companies").withIndex('revenue', (q) => q.and(q.lte(q.field("revenue"), args.maxRevenue), q.gte(q.field("revenue"), args.minRevenue)),order('desc');
        return companies;
    }
});

Because now I understand that is going to be sorted by revenue, because its first field in index.

Convex Community•2y ago•

14 replies

maros.studenic

Hey I wanted to ask, is there a way to

export const getCompanies = query({
    args: {
        minRevenue: v.number(),
        maxRevenue: v.number()
    },
    handler: async (ctx, args) => {
        const companies = await ctx.db.query("companies").withIndex('revenue', (q) => q.and(q.lte(q.field("revenue"), args.maxRevenue), q.gte(q.field("revenue"), args.minRevenue)),order('desc');
        return companies;
    }
});

export const getCompanies = query({
    args: {
        minRevenue: v.number(),
        maxRevenue: v.number()
    },
    handler: async (ctx, args) => {
        const companies = await ctx.db.query("companies").withIndex('revenue', (q) => q.and(q.lte(q.field("revenue"), args.maxRevenue), q.gte(q.field("revenue"), args.minRevenue)),order('desc');
        return companies;
    }
});

Because now I understand that is going to be sorted by revenue, because its first field in index.

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

Hey I wanted to ask, is there a way to

Hey I wanted to ask, is there a way to

Continue the conversation

Convex Community

Continue the conversation

Convex Community

Similar Threads