Clever Tagline
Clever Tagline
PostsComments
CCConvex Community
Created by Clever Tagline on 3/28/2025 in #support-community
Paginated indexed query with multiple index choices?
@Lee Just discovered that using .withSearchIndex on a stream is indicating a type error with the search filter: Parameter 'q' implicitly has an 'any' type. FWIW, in this particular case it's not a paginated query. I was using my original method of running multiple queries and adding all of the results to an array, but I thought I'd try to optimize it using streams and ran into this issue.
8 replies
CCConvex Community
Created by Clever Tagline on 3/28/2025 in #support-community
Paginated indexed query with multiple index choices?
Me too. It's working perfectly! Thanks for adding those stream features!
8 replies
CCConvex Community
Created by Clever Tagline on 3/28/2025 in #support-community
Paginated indexed query with multiple index choices?
I might have just rubberducked this. While finishing my original post I was thinking, "I wonder if there's a way to merge queries," so I searched the docs for "merge" and found this Stack article: https://stack.convex.dev/merging-streams-of-convex-data If I'm reading it correctly, I could stream the queries for each region, merge them, then return the pagination of the result. Something like this: 
import { stream, mergedStream } from "convex-helpers/server/stream";
import schema from "./schema";

export const getRegionContacts = query({
  args: {
    regions: v.array(v.id("regions")),
  },
  handler: async (ctx, args) => {
    const contactStreams = new Array() // figure out the stream type
    for (const regionId of args.regions) {
      contactStreams.push(await stream(ctx.db, schema)
        .query("contacts")
        .withIndex("by_region", q => q.eq("region", region))
        .order("desc")
        .collect()
      )
    }
    return mergedStream(contactStreams, ["_creationTime"]).paginate(args.paginationOpts)
  }
})
import { stream, mergedStream } from "convex-helpers/server/stream";
import schema from "./schema";

export const getRegionContacts = query({
  args: {
    regions: v.array(v.id("regions")),
  },
  handler: async (ctx, args) => {
    const contactStreams = new Array() // figure out the stream type
    for (const regionId of args.regions) {
      contactStreams.push(await stream(ctx.db, schema)
        .query("contacts")
        .withIndex("by_region", q => q.eq("region", region))
        .order("desc")
        .collect()
      )
    }
    return mergedStream(contactStreams, ["_creationTime"]).paginate(args.paginationOpts)
  }
})
Am I interpreting that correctly?
8 replies
CCConvex Community
Created by AlphaOmega on 3/21/2025 in #support-community
Why no unions as function validators?
Gotcha. Curious, what's the use case where this would be used?
14 replies
CCConvex Community
Created by AlphaOmega on 3/21/2025 in #support-community
Why no unions as function validators?
Could you elaborate? Maybe I'm not understanding what you're referring to. I use unions on occasion inside function argument validators without any issues.
14 replies
CCConvex Community
Created by anne013. on 3/20/2025 in #support-community
App Disabled: How to Fix Convex Storage Issues
That figure in the stats represents how much was used in total during the month. Even though you removed files and brought the current usage below the threshold, there was still a time earlier in the month when the usage exceeded the limit. You'll probably need to speak with Convex support directly to see about removing the restriction.
2 replies
CCConvex Community
Created by Clever Tagline on 3/11/2025 in #support-community
Tracking document changes
@lee I've got a feature request for this component. Would it be okay to discuss it here, or would you prefer that I start a new thread?
44 replies
CCConvex Community
Created by Clever Tagline on 3/13/2025 in #general
general table history
For example, I'm running all of these early tests on my contacts table. One of the fields in that table is: 
deals: v.optional(v.array(v.id("deals")))
deals: v.optional(v.array(v.id("deals")))
7 replies
CCConvex Community
Created by Clever Tagline on 3/13/2025 in #general
general table history
Yeah, that's kinda what I figured. As a side question, will that logic with the field path also work if the ID is in an array, or inside an object that's part of an array? Do I need to adjust how I'm building the path array to account for cases like that?
7 replies
CCConvex Community
Created by Clever Tagline on 3/13/2025 in #general
general table history
Thank you! This works perfectly even though the type checker indicates an error with schema.tables[tableName]: 
Element implicitly has an 'any' type because expression of type 'string' can't be used to index type '{ afterHours: TableDefinition<VObject<{ number: string; }, { number: VString<string, "required">; }, "required", "number">, { by_number: ["number", "_creationTime"]; }, {}, {}>; ... 20 more ...; links: TableDefinition<...>; }'.
  No index signature with a parameter of type 'string' was found on type '{ afterHours: TableDefinition<VObject<{ number: string; }, { number: VString<string, "required">; }, "required", "number">, { by_number: ["number", "_creationTime"]; }, {}, {}>; ... 20 more ...; links: TableDefinition<...>; }'.ts(7053)
Element implicitly has an 'any' type because expression of type 'string' can't be used to index type '{ afterHours: TableDefinition<VObject<{ number: string; }, { number: VString<string, "required">; }, "required", "number">, { by_number: ["number", "_creationTime"]; }, {}, {}>; ... 20 more ...; links: TableDefinition<...>; }'.
  No index signature with a parameter of type 'string' was found on type '{ afterHours: TableDefinition<VObject<{ number: string; }, { number: VString<string, "required">; }, "required", "number">, { by_number: ["number", "_creationTime"]; }, {}, {}>; ... 20 more ...; links: TableDefinition<...>; }'.ts(7053)
I can add a @ts-ignore comment above that line for now, but I'm curious if there's another way to satisfy the type checker for that line.
7 replies