apoc.mongodb.find
Procedure APOC Full Deprecated
apoc.mongodb.find(host-or-key,db,collection,query,projection,sort,[compatibleValues=false|true],skip-or-null,limit-or-null,[extractReferences=false|true],[objectIdAsMap=true|false]) yield value - perform a find,project,sort operation on mongodb collection
Signature
apoc.mongodb.find(host :: STRING?, db :: STRING?, collection :: STRING?, query :: MAP?, project :: MAP?, sort :: MAP?, compatibleValues = false :: BOOLEAN?, skip = 0 :: INTEGER?, limit = 0 :: INTEGER?, extractReferences = false :: BOOLEAN?, objectIdAsMap = true :: BOOLEAN?) :: (value :: MAP?)
Input parameters
Name | Type | Default |
---|---|---|
host |
STRING? |
null |
db |
STRING? |
null |
collection |
STRING? |
null |
query |
MAP? |
null |
project |
MAP? |
null |
sort |
MAP? |
null |
compatibleValues |
BOOLEAN? |
false |
skip |
INTEGER? |
0 |
limit |
INTEGER? |
0 |
extractReferences |
BOOLEAN? |
false |
objectIdAsMap |
BOOLEAN? |
true |
Install Dependencies
The Mongo procedures have dependencies on a client library that is not included in the APOC Library.
This dependency is included in apoc-mongodb-dependencies-4.4.0.34.jar, which can be downloaded from the releases page.
Once that file is downloaded, it should be placed in the plugins
directory and the Neo4j Server restarted.
Usage Examples
The examples in this section are based on a Mongo DB instance with a pre-populate twitter dataset. You can find instructions for setting this up at github.com/neo4j-examples/mongo-example.
CALL apoc.mongodb.find('mongodb://mongo:neo4j@mongo:27017', 'test', 'tweets', {`user.name`: "FC Barcelona"}, null, null) YIELD value
RETURN value.created_at, value.text, [item in value.entities.hashtags | item.text] AS hashtags
LIMIT 10;
value.created_at | value.text | hashtags |
---|---|---|
"Sat Apr 25 16:17:26 +0000 2015" |
"[CALENDAR] Barça have 5 league games left, 2 #UCL semi-final games, and the Spanish Cup final: http://t.co/mWKOzNEWFo http://t.co/cyN1ZZNsSx" |
["UCL"] |
"Sat Apr 25 16:13:58 +0000 2015" |
"\"The players understand the difficulty of every game we have left,\" says Luis Enrique. #FCBLive http://t.co/iASWBXiV8D" |
["FCBLive"] |
"Sat Apr 25 16:12:09 +0000 2015" |
"Luis Enrique says, \"That was the best first half we’ve played.\" #FCBLive #EspanyolFCB http://t.co/rhvaFNgmf6" |
["FCBLive", "EspanyolFCB"] |
"Sat Apr 25 16:09:15 +0000 2015" |
"[#MESSI, NEYMAR, SUÁREZ] Heat map of Barça’s Big 3 for all 90 minutes! http://t.co/Z5zYu82WLH #FCBLive #FCBLive http://t.co/3b3c2sHY59" |
["MESSI", "FCBLive", "FCBLive"] |
"Sat Apr 25 16:05:30 +0000 2015" |
"[MVP] Who do you think was the best player of the match? Vote for the MVP! http://t.co/JSHYGY8o1s http://t.co/oRjHwZQRCd" |
[] |
"Sat Apr 25 16:04:27 +0000 2015" |
"[LA LIGA TABLE] Barça move 5 points clear with today’s 2–0 win at Espanyol: http://t.co/jkqeVh52wX #FCBLive http://t.co/9yeP00ZL62" |
["FCBLive"] |
"Sat Apr 25 15:58:45 +0000 2015" |
"[STATISTICS] All the stats and more from the full 90 minutes of Barça’s 2–0 win at Espanyol! http://t.co/micLdI7xsk http://t.co/68Lw8F9hYU" |
[] |
"Sat Apr 25 15:59:54 +0000 2015" |
"Andrés Iniesta says \"We knew that to win this derby we had to play a complete game, and we did.\" #FCBLive #EspanyolFCB" |
["FCBLive", "EspanyolFCB"] |
"Sat Apr 25 15:55:28 +0000 2015" |
"[CALENDAR] Fixture list. These are the next games for Barça http://t.co/m9MF2YNOhG http://t.co/ZEbmbzNVyB" |
[] |
"Sat Apr 25 15:59:35 +0000 2015" |
"[STATS] Xavi makes 500th @LaLiga appearance. RT to support him! #Xavi500 #FCBLive http://t.co/ewuAlKcQDr" |
["Xavi500", "FCBLive"] |