ZComplex queries based off of items in an array
I'd like to be able to:
I have some complex query requirements and the above would help immensely!
But perhaps there's another way to efficiently accomplish this?
I have a
Each skills document has a type field that can hold one of three types
With this schema, it's challenging to write a complex query without a lot of application logic and costly ($$) additional reads. But if I could denormalize the data for users to have
.widthIndex("by_userId_primarySkills_secondarySkills", q => q.includes("primarySkills", arrayItem))I have some complex query requirements and the above would help immensely!
But perhaps there's another way to efficiently accomplish this?
I have a
users table and a separate table skillsEach skills document has a type field that can hold one of three types
primary, secondary, and lookingFor. Each user can have up to 3 primary types/docs, 3 secondary types/docs, and 6 lookingFor types/docs.With this schema, it's challenging to write a complex query without a lot of application logic and costly ($$) additional reads. But if I could denormalize the data for users to have
users.primarySkills where primarySkills is an array, and if I could query at the array item level, that would be a seamless solution
