glucinater•17mo ago

Data not being shown

Can't look at my data in dashboard, anyone know how to get around this?

42 Replies

Indy•17mo ago

Are you by any chance using the alpha release?

glucinaterOP•17mo ago

let me check, don't believe so though\ "convex": "^1.0.3", this is the version in my project

Indy•17mo ago

Thanks for checking. This is definitely a new bug. We're digging in now. Does your data by any chance have lots of different potential sub types for the same field?

glucinaterOP•17mo ago

no, i can send an example of the data though

glucinaterOP•17mo ago

instances_0.csv

glucinaterOP•17mo ago

This is 1/11 files uploaded to the big table none of my other documents are working though except for the default 1 that shows when i click the data tab I'm also getting a new error where this function is giving me an error

glucinaterOP•17mo ago

essentially it isn't letting me query 2 tables in 1 function

Indy•17mo ago

What does the error say when you hover over the instances

glucinaterOP•17mo ago

Argument of type '"instances"' is not assignable to parameter of type '"courses"'.ts(2345)

Argument of type '"instances"' is not assignable to parameter of type '"courses"'.ts(2345)

instances and courses are both table names

Indy•17mo ago

@glucinater can you check the dashboard and see if it works? We pushed a potential fix

glucinaterOP•17mo ago

Not yet

Indy•17mo ago

can you do a hard refresh? CMD+SHIFT+R if you're on Mac?

glucinaterOP•17mo ago

no change

Indy•17mo ago

ok thanks for checking we'll keep looking

glucinaterOP•17mo ago

any ideas on the second issue? This one's a hard blocker since I'm not able to even run the original query anymore

Indy•17mo ago

right, that's a confusing error for sure Are you able to query instances from another query function?

glucinaterOP•17mo ago

adding this temp schema seemed to fix it, a bit confused since it works without the define schema function

glucinaterOP•17mo ago

I thought schemas were optional? not sure why only defining some tables would lead to error

Indy•17mo ago

They are optional. I believe you hit a very specific bug for us on a change that we pushed out late last week.

Indy•17mo ago

Oh you probably need to do this and you should be fine: https://docs.convex.dev/database/schemas#stricttablenametypes-boolean

Schemas | Convex Developer Hub

Schema validation keeps your Convex data neat and tidy. It also gives you end-to-end TypeScript type safety!

Indy•17mo ago

If you're only defining some talbes and not others, we need to tell typescript that it shouldn't strictly enforce the table names in queries. The dashbord being broken is still something we're looking at, but hopefully you're unblocked to continue developing for the time being.

glucinaterOP•17mo ago

Gotcha, any ideas on how to add indexes on a table wihout defining the entire schema? If I can figure that out then i should be unblocked

Indy•17mo ago

So you don't have to define the fields at all. You can just say that the table body is any and can definte an index anyways. Let me dig up an example for you

glucinaterOP•17mo ago

like this? got this error

Type '"Catalog"' is not assignable to type 'ExtractFieldPaths<ObjectValidator<{ anyValue: Validator<any, false, string>; }>>'.

Type '"Catalog"' is not assignable to type 'ExtractFieldPaths<ObjectValidator<{ anyValue: Validator<any, false, string>; }>>'.

Indy•17mo ago

I believe you can just do this: messages: defineTable(v.any()).index(…)

glucinaterOP•17mo ago

got no overload matches this call for v.any() full error message

No overload matches this call.
  Overload 1 of 2, '(documentSchema: Validator<Record<string, any>, false, any>): TableDefinition<{ [x: string]: any; _creationTime: number; }, any, {}, {}>', gave the following error.
    Argument of type '{ v: { id<TableName extends string>(tableName: TableName): Validator<Id<TableName>, false, never>; null(): Validator<null, false, never>; number(): Validator<...>; ... 11 more ...; optional<T_4 extends Validator<...>>(inner: T_4): Validator<...>; }; "": any; }' is not assignable to parameter of type 'Validator<Record<string, any>, false, any>'.
      Object literal may only specify known properties, and 'v' does not exist in type 'Validator<Record<string, any>, false, any>'.
  Overload 2 of 2, '(documentSchema: Record<string, Validator<any

No overload matches this call.
  Overload 1 of 2, '(documentSchema: Validator<Record<string, any>, false, any>): TableDefinition<{ [x: string]: any; _creationTime: number; }, any, {}, {}>', gave the following error.
    Argument of type '{ v: { id<TableName extends string>(tableName: TableName): Validator<Id<TableName>, false, never>; null(): Validator<null, false, never>; number(): Validator<...>; ... 11 more ...; optional<T_4 extends Validator<...>>(inner: T_4): Validator<...>; }; "": any; }' is not assignable to parameter of type 'Validator<Record<string, any>, false, any>'.
      Object literal may only specify known properties, and 'v' does not exist in type 'Validator<Record<string, any>, false, any>'.
  Overload 2 of 2, '(documentSchema: Record<string, Validator<any

ah nvm had brackets still there

Indy•17mo ago

Yea no brackets @glucinater Confirming that this worked for you?

glucinaterOP•17mo ago

it seems so, about to test the indexes work

Indy•17mo ago

Great!

glucinaterOP•17mo ago

Thank you! Also while you're here I was trying to find how to do something similar to a sql join to return data from 2 tables, do you have any guidance? It worked btw

Indy•17mo ago

Great to hear! You'll find the following post helpful for joins: https://stack.convex.dev/functional-relationships-helpers

Functional Relationships: Helpers

In this post, we’ll look at some helper functions to help write code to traverse relationships in a readable, predictable, and debuggable way.

Indy•17mo ago

The solutions to the parts of our new tutorial get into this as well: https://docs.convex.dev/tutorial/client#index-likes-by-message-id

2: Convex and your app | Convex Developer Hub

Learn how to connect your project to Convex and quickly build out new fullstack features

glucinaterOP•17mo ago

Awesome, appreciate it Now fully unvlocked!

Indy•17mo ago

Perfect. Sorry to hear the dashboard is still broken. Folks will keep digging. But hopefully you can at least keep building your product. Good luck, and don't hesitate to create new support tickets if you have any other questions.

james•17mo ago

hi @glucinater, would you be able to try the dashboard again?

glucinaterOP•17mo ago

Working now, thanks for the quick fix!

james•17mo ago

no problems! we'd prefer an even quicker fix but saturday evenings aren't always the fastest of times 🙂 thanks for your patience

glucinaterOP•17mo ago

No worries, on an unrelated note were you at PennApps last year? I think we may have met if so

james•17mo ago

I was, it's great to have you on the platform!

glucinaterOP•17mo ago

Thanks, congrats on the recent 1.0 launch!

Data not being shown

Did you find this page helpful?