2 replies

Compound index

Hello everyone, I need some help with Convex database indexing. I have a table named 'skills' and I have two separate indexes on the

is_published

is_published

and

is_featured

is_featured

fields. I need to query the data based on both these fields. Initially, I thought of using a compound index, but it seems like the

withIndex

withIndex

method doesn't allow multiple

.eq()

.eq()

checks. Is there any way to efficiently filter by both these fields using the indexes? Any help would be greatly appreciated!