Zeroday
CCConvex Community
•Created by Zeroday on 3/23/2025 in #support-community
Search Advice
Hi, I have a table called profiles that has several fields Name (str), Username (str), Email (str), Rank (int), Tags (array(str)), Age (int), Gender (str), etc...
I want to be able to do full text search and typeahead while being able to filter and sort on name (a-z, z-a), username (a-z, z-a), rank (low-high, high-low), tags (filter by specific tags), age (range, high-low, low-high), gender (filter by Male, Female, Non-binary, etc...)
I have about 500k profiles and growing, I want some advice on how I would efficiently query this table with my needs.
Thanks!
3 replies
CCConvex Community
•Created by Zeroday on 3/22/2025 in #support-community
Array Contains
const profiles = await ctx.db
.query("profiles")
.filter((q) => q.contains(q.field("tags"), tag._id))
.order("asc") // Assuming lower rank is better
.take(4); // Get top 4 profiles
convex/queries/external/tags.ts:255:46 - error TS2339: Property 'contains' does not exist on type 'FilterBuilder<{ document: { _id: Id<"profiles">; _creationTime: number; location?: { city?: string; state?: string; country?: string; coordinates: number[]; }; description?: string; tagIds?: Id<"tags">[]; tags?: string[]; ... 23 more ...; hasDeals: boolean; }; fieldPaths: ExtractFieldPaths<...> | "_id"; indexes: { ....'.
255 .filter((q) => q.contains(q.field("tags"), tag._id))
~~~~
Found 1 error in convex/queries/external/tags.ts:255
tags is an array
2 replies
CCConvex Community
•Created by Zeroday on 3/18/2025 in #support-community
Migrations calling HTTP
Hi, I wanted some advice on how I would have a migration call an HTTP function.
For example:
Run migration on all documents that will
Call an API, wait for the API to return
Update the document with some info returned from API call
I'm not a typescript pro, so some help would be amazing.
7 replies
CCConvex Community
•Created by Zeroday on 3/17/2025 in #support-community
Comprehensive Searching
Hi there, I am switching from MongoDB to Convex for a number of reasons, but one reason is the integrated search. With search you usually have to have a main database and a search database that needs to be in sync. One of my main use cases is searching and having advanced search features in Convex would be amazing such as faceting, search synonyms, etc..
2 replies
CCConvex Community
•Created by Zeroday on 3/16/2025 in #support-community
Convex type errors and modular folder structure
3 replies
CCConvex Community
•Created by Zeroday on 3/3/2025 in #support-community
Sorting all my documents
Hi, I want to do a normal query where I have a rank field on all of my documents and I want to return the top 10 documents by rank. Rank is indexed. Am I not able to do this? When I try to do my query I get the "over 8mb" error. Would appreciate some help, thanks!
3 replies