Hey there, I was FINALLY able to figure something out. I had such a hard time getting any help on this.
So what I ended up doing was adding a new rich text field to my primary table, and then setting up a hook to copy my multiple reference field data into the new rich text field. Then I made sure the query included the values of the rich text field. The tricky thing was trying to get the multiple reference data to copy over and actually retain its data rather than just showing up as an [object Object].
Here’s what I used for my hook. “search” is the rich text field, “categories” is the multiple reference field. Then you just include “search” in your query.
export function EventPhotos_afterQuery(item, context) {
item.search = JSON.stringify(item.categories)
return item
}
Good luck! I had such a hard time finding any answers or help for this, I’m sure this isn’t the best solution but it’s the best I could come up with. I was really discouraged with trying to get any answers on the forum.