[SOLVED] How do I run queries to search and filter data from 2 different collections

I have created 2 different collections within a same DB. And I want to run some query which finds same data and sorts that out. How can I achieve this?

There isn't a single API to return this kind of data. However, can you describe your use case? Maybe there's some other way to achieve what you're looking for

basically I want to find data values which are same in both the collections and return the username of the documents which are same(both the collection have a common attribute of username)

One method I found is to create a seperate function which retrieves the data and then compares it. But it is slow. From documentation I concluded that queries can run on collections I just need to figure out how to 'join' these collections and run the query.

Any help is appreciated.

Which attributes need to match? How many matches will there be?

there are 2 attributes in each collection one is 'username' and other one is 'topic' the 'topic' attributes need to be matched/compared and return the subsequent username of the document itself.

Perhaps you can have a function that triggers on document creation, update, delete in either collection. The function can check if there's a matching document in the other collection and then if there's a match create a document in a 3rd document with the topic. Then, you can list documents in that 3rd collection to get all the matching topics and fetch from the other 2 collections for documents with that topic

I was doing exactly that but I was not using a 3rd collection except I am getting undefined in the console itself. This means comparison is correct but the data being returned is not valid. here is my code if you want to take a look
if(method=='learn')
{
let mainuser = databases.listDocuments(
'647da37c3a08636bd3ad',
'647da20436fr493248ac',
[
Query.equal('TopicT',[topic])
]
)
mainuser.then(function(res){
const user = res.documents.username;
console.log(user); //here i am getting undefined
}, function (error) {
console.log(error);
});
}

Btw, it's best to use 3 back ticks with multi-line code. See https://www.markdownguide.org/extended-syntax/#syntax-highlighting

Documents is an array

ahhhh ok completely forgot about that

thanks a lot man

and thanks for the 3 back ticks tip

Happy to help!

Can we mark this as solved?

sure sure go ahead.

[SOLVED] How do I run queries to search and filter data from 2 different collections