I'm getting the above error when I run the following query. I can visit the link provided to create an index, but if I understand this correctly I don't think that is feasible since the query is searching through the "members" map for the current users ID which will obviously change depending on the user. Is there some kind of workaround to this issue or would I need to restructure my database?
const subscribeChats = () => {
const chatsQuery = query(
collection(db, "chats"),
where(`members.${getAuth().currentUser.uid}.inChat`, "==", true),
where(`members.${getAuth().currentUser.uid}.isHidingChat`, "==", false),
orderBy("lastActive", "desc")
);
return onSnapshot(chatsQuery, (snapshot) => {
setChatsList(
snapshot.docs.map((doc) => {
return { id: doc.id, data: doc.data() };
})
);
});
};