Using
Oracle REST Data Services version : 23.3.0.r2891830
Oracle Database 23c Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.3.0.23.09
When trying to use $lookup (aggregation) as follows:
db.sb_user.aggregate([ { $lookup: {from:'sb_role', localField:'username', foreignField: 'username', as:'role'}} ])
The following error is returned:
MongoServerError: Stage $lookup is not supported.
In the docs, here:
https://docs.oracle.com/en/database/oracle/mongodb-api/mgapi/oracle-database-api-mongodb.pdf
Section, 3.5 lists $lookup as a supported stage, in 23c.
Is lookup supported, or is this a documentation error, or something else?