Is there a way to describe compound index for collection?
Use case:
Collection has two fields
title
and
value
Collection should have only unique pairs of title and value
Like:
title | value
------------|--------------
email | google
------------|--------------
email | yahoo
Not out of the box currently. An option would be to make an additional field that is readOnly, then write a beforeValidate hook that populates it with the 2 values concatenated.
I see, thank you
Compound indexes are quite common, any updates in 2025?
Currently, I'm sneaking in SQL commands in the migration files, and would like to have a more organized way to do this.
2 options:
- If on Postgres, you can use afterSchemaInit
https://payloadcms.com/docs/database/postgres#afterschemainit- You could combine the values of multiple fields into a single one made for searching, and index that one
Star
Discord
online
Get dedicated engineering support directly from the Payload team.