How can we use lookup to get the data from another collection?
Hi Joy,
To join two collections in MongoDB using OutSystems, you can follow these steps:
1 . Use the "ApplyToEach" action to loop through one collection and find matching records in the other collection.
2. Combine the data from both collections into a single record.
3. Use the "CreateList" action to store the combined data into a list.
4. Use the "Return" action to return the list as the result of the operation.
Note: The specifics of the solution will depend on the structure of your data and the relationships between the collections.
Hello,
Thank you so much for your reply. Just a question, where can I see those actions? We are using the MongoDB component from Forge.
Joy