🕷️ Crawler Inspector

URL Lookup

Direct Parameter Lookup

Raw Queries and Responses

1. Shard Calculation

Query:

Response:

Calculated Shard: 143 (from laksa154)

2. Crawled Status Check

Query:

curl -X POST \
  'http://laksa143.int.ahrefs:8124/' \
  -H 'Content-Type: text/plain' \
  -H 'X-ClickHouse-Database: crawler3' \
  -H 'Authorization: Basic YXBpOg==' \
  -d 'SELECT getAhrefsURLFromUnparsed(src_unparsed) AS found_url, ifNull(toUnixTimestamp(download_stamp), 0) AS crawl_time, ifNull(toUnixTimestamp(props_url_first_seen), 0) AS first_indexed_time, download_http_code AS http_code, src_unparsed AS src_unparsed, src_root_hash AS src_root_hash, history_drop_reason AS history_drop_reason, meta_title AS meta_title, meta_descriptions AS meta_descriptions, attrs_boilerpipe_text AS attrs_boilerpipe_text, attrs_markdown AS attrs_markdown, attrs_readable_markdown AS attrs_readable_markdown, meta_canonical AS meta_canonical FROM crawler3.page_info_local FINAL PREWHERE (src_root_hash, src_unparsed) IN ((getAhrefsRootHashFromUnparsed(getAhrefsUnparsedNoserviceFromURL(\'https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/utilities/collection-list-functions/\')), getAhrefsUnparsedNoserviceFromURL(\'https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/utilities/collection-list-functions/\'))) FORMAT JSONEachRow'

Response:

{"found_url":"https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/utilities\/collection-list-functions\/","crawl_time":1774460599,"first_indexed_time":1552343062,"http_code":200,"src_unparsed":"io,github!neo4j-contrib,\/neo4j-apoc-procedures\/3.5\/utilities\/collection-list-functions\/ s443","src_root_hash":"2566890010099092343","history_drop_reason":null,"meta_title":"10.3. Collection Functions - Chapter 10. Utility Functions","meta_descriptions":[],"attrs_boilerpipe_text":"apoc.coll.sum([0.5,1,2.3])\nsum of all values in a list\napoc.coll.avg([0.5,1,2.3])\navg of all values in a list\napoc.coll.min([0.5,1,2.3])\nminimum of all values in a list\napoc.coll.max([0.5,1,2.3])\nmaximum of all values in a list\napoc.coll.sumLongs([1,3,3])\nsums all numeric values in a list\napoc.coll.partition(list,batchSize)\npartitions a list into sublists of\nbatchSize\napoc.coll.zip([list1],[list2])\nall values in a list\napoc.coll.pairs([1,2,3]) YIELD value\n[1,2],[2,3],[3,null]\napoc.coll.pairsMin([1,2,3]) YIELD value\n[1,2],[2,3]\napoc.coll.toSet([list])\nreturns a unique list backed by a set\napoc.coll.sort(coll)\nsort on Collections\napoc.coll.sortNodes([nodes], 'name')\nsort nodes by property, ascending sorting by adding ^ in front of the sorting field\napoc.coll.sortMaps([maps], 'key')\nsort maps by map key, ascending sorting by adding ^ in front of the sorting field\napoc.coll.reverse(coll)\nreturns the reversed list\napoc.coll.contains(coll, value)\nreturns true if collection contains the value\napoc.coll.containsAll(coll, values)\noptimized contains-all operation (using a HashSet) returns true or false\napoc.coll.containsSorted(coll, value)\noptimized contains on a sorted list operation (Collections.binarySearch) (returns true or false)\napoc.coll.containsAllSorted(coll, value)\noptimized contains-all on a sorted list operation (Collections.binarySearch) (returns true or false)\napoc.coll.union(first, second)\ncreates the distinct union of the 2 lists\napoc.coll.subtract(first, second)\nreturns unique set of first list with all elements of second list removed\napoc.coll.removeAll(first, second)\nreturns first list with all elements of second list removed\napoc.coll.intersection(first, second)\nreturns the unique intersection of the two lists\napoc.coll.disjunction(first, second)\nreturns the disjunct set of the two lists\napoc.coll.unionAll(first, second)\ncreates the full union with duplicates of the two lists\napoc.coll.split(list,value)\nsplits collection on given values rows of lists, value itself will not be part of resulting lists\napoc.coll.indexOf(coll, value)\nposition of value in the list\napoc.coll.shuffle(coll)\nreturns the shuffled list\napoc.coll.randomItem(coll)\nreturns a random item from the list\napoc.coll.randomItems(coll, itemCount, allowRepick: false)\nreturns a list of\nitemCount\nrandom items from the list, optionally allowing picked elements to be picked again\napoc.coll.containsDuplicates(coll)\nreturns true if a collection contains duplicate elements\napoc.coll.duplicates(coll)\nreturns a list of duplicate items in the collection\napoc.coll.duplicatesWithCount(coll)\nreturns a list of duplicate items in the collection and their count, keyed by\nitem\nand\ncount\n(e.g.,\n[{item: xyz, count:2}, {item:zyx, count:5}]\n)\napoc.coll.occurrences(coll, item)\nreturns the count of the given item in the collection\napoc.coll.frequencies(coll)\nreturns a list of frequencies of the items in the collection, keyed by\nitem\nand\ncount\n(e.g.,\n[{item: xyz, count:2}, {item:zyx, count:5}, {item:abc, count:1}]\n)\napoc.coll.frequenciesAsMap(coll)\nreturn a map of frequencies of the items in the collection, keyed by\nitem\nand\ncount\n(e.g.,\n{1: 2, 3: 2}\n)\napoc.coll.sortMulti\nsort list of maps by several sort fields (ascending with ^ prefix) and optionally applies limit and skip\napoc.coll.flatten\nflattens a nested list\napoc.coll.combinations(coll, minSelect, maxSelect:minSelect)\nReturns collection of all combinations of list elements of selection size between minSelect and maxSelect (default:minSelect),\n                              inclusive\nCALL apoc.coll.elements(list,limit,offset) yield _1,_2,..,_10,_1s,_2i,_3f,_4m,_5l,_6n,_7r,_8p\ndeconstruct subset of mixed list into identifiers of the correct type\napoc.coll.set(coll, index, value)\nset index to value\napoc.coll.insert(coll, index, value)\ninsert value at index\napoc.coll.insertAll(coll, index, values)\ninsert values at index\napoc.coll.remove(coll, index, [length=1])\nremove range of values from index to length\napoc.coll.different(values)\nreturns true if value are different","attrs_markdown":"[![Neo4j Logo](https:\/\/neo4j.com\/wp-content\/themes\/neo4jweb\/assets\/images\/neo4j-logo-2015.png)](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/utilities\/collection-list-functions\/)\n\n- [Operations Manual](https:\/\/neo4j.com\/docs\/operations-manual\/current)\n- [Developer Manual](https:\/\/neo4j.com\/docs\/developer-manual\/current\/)\n- [OGM Manual](https:\/\/neo4j.com\/docs\/ogm-manual\/current\/)\n- [Graph Algorithms](https:\/\/neo4j.com\/docs\/graph-algorithms\/current\/)\n- [APOC](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/)\n- [Java Reference](https:\/\/neo4j.com\/docs\/java-reference\/current\/)\n\n[Map Functions](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/utilities\/map-functions\/)\n\n10\\.3. Collection Functions\n\n[Text Functions](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/utilities\/text-functions\/)\n\nTable of Contents\n\n- [1\\. Introduction](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/)\n  - [1\\.1. Documentation Overview](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/#_documentation_overview)\n  - [1\\.2. Installation: With Neo4j Desktop](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/#_installation_with_neo4j_desktop)\n  - [1\\.3. Feedback](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/#_feedback)\n  - [1\\.4. Calling Procedures & Functions within Cypher](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/#_calling_procedures_functions_within_cypher)\n- [2\\. Built in Help](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/help\/)\n  - [2\\.1. Procedure & Function Signatures](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/help\/#_procedure_function_signatures)\n- [3\\. Installation in Neo4j Server & Docker](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/installation\/)\n  - [3\\.1. Manual Installation: Download latest release](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/installation\/#_manual_installation_download_latest_release)\n  - [3\\.2. Using APOC with the Neo4j Docker image](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/installation\/#_using_apoc_with_the_neo4j_docker_image)\n- [4\\. Overview of APOC Procedures & Functions](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/overview\/)\n- [5\\. Configuration Options](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/config\/)\n- [6\\. User Defined Functions](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/utilities\/collection-list-functions\/#_user_defined_functions)\n- [7\\. Export \/ Import](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/export-import\/)\n  - [7\\.1. Loading Data from Web-APIs](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/export-import\/#_loading_data_from_web_apis)\n  - [7\\.2. Load JSON](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/export-import\/load-json\/)\n  - [7\\.3. Load CSV](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/export-import\/load-csv\/)\n  - [7\\.4. Import CSV](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/export-import\/import-csv\/)\n  - [7\\.5. Loading Excel (XLS)](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/export-import\/load-xls\/)\n  - [7\\.6. Load XML](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/export-import\/load-xml\/)\n  - [7\\.7. Export to CSV](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/export-import\/#export-csv)\n  - [7\\.8. Export to Json File](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/export-import\/#export-json)\n  - [7\\.9. Export to Cypher Script](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/export-import\/#export-cypher)\n  - [7\\.10. GraphML Import \/ Export](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/export-import\/graphml\/)\n- [8\\. Database Integration](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/database-integration\/)\n  - [8\\.1. Load JDBC](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/database-integration\/load-jdbc\/)\n  - [8\\.2. Database Modeling](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/database-integration\/database-modeling\/)\n  - [8\\.3. ElasticSearch Integration](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/database-integration\/elasticsearch\/)\n  - [8\\.4. Interacting with MongoDB](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/database-integration\/mongodb\/)\n  - [8\\.5. Interacting with Couchbase](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/database-integration\/couchbase\/)\n  - [8\\.6. Bolt](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/database-integration\/bolt-neo4j\/)\n  - [8\\.7. Load LDAP](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/database-integration\/load-ldap\/)\n- [9\\. Schema Information and Operations](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/schema\/)\n  - [9\\.1. Meta Graph](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/schema\/meta-graph\/)\n- [10\\. Utility Functions](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/utilities\/)\n  - [10\\.1. Conversion Functions](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/utilities\/conversion-functions\/)\n  - [10\\.2. Map Functions](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/utilities\/map-functions\/)\n  - [10\\.3. Collection Functions](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/utilities\/collection-list-functions\/)\n  - [10\\.4. Text Functions](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/utilities\/text-functions\/)\n  - [10\\.5. Math Functions](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/utilities\/math-functions\/)\n  - [10\\.6. Spatial](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/utilities\/spatial\/)\n  - [10\\.7. Static Value Storage](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/utilities\/static-values\/)\n  - [10\\.8. Utilities](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/utilities\/utility-functions\/)\n  - [10\\.9. Phonetic Text Functions](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/utilities\/phonetic-functions\/)\n  - [10\\.10. Extract Domain](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/utilities\/data-extraction-functions\/)\n  - [10\\.11. Date and Time Conversions](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/utilities\/datetime-conversions\/)\n  - [10\\.12. Temporal Functions](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/utilities\/temporal-conversions\/)\n  - [10\\.13. Number Format Conversions](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/utilities\/number-conversions\/)\n  - [10\\.14. Exact Math](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/utilities\/exact-math-functions\/)\n  - [10\\.15. Fingerprinting](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/utilities\/fingerprinting\/)\n  - [10\\.16. Bitwise operations](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/utilities\/bitwise-operations\/)\n  - [10\\.17. Atomic](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/utilities\/atomic-updates\/)\n  - [10\\.18. Atomic Examples](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/utilities\/#_atomic_examples)\n  - [10\\.19. Log](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/utilities\/#_log)\n- [11\\. Node, Relationship and Path Functions and Procedures](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/nodes-relationships\/)\n  - [11\\.1. Path Functions](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/nodes-relationships\/path-functions\/)\n  - [11\\.2. Lookup and Manipulation Procedures](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/nodes-relationships\/node-lookup\/)\n  - [11\\.3. Node Functions](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/nodes-relationships\/node-functions\/)\n  - [11\\.4. Creating Data](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/nodes-relationships\/data-creation\/)\n  - [11\\.5. Locking](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/nodes-relationships\/locking\/)\n  - [11\\.6. Generating Graphs](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/nodes-relationships\/graph-generators\/)\n  - [11\\.7. Parallel Node Search](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/nodes-relationships\/parallel-node-search\/)\n- [12\\. Path Finding](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/path-finding\/)\n  - [12\\.1. Path Expander](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/path-finding\/path-expander\/)\n  - [12\\.2. Expand to a subgraph and return all nodes and relationships within the subgraph](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/path-finding\/#_expand_to_a_subgraph_and_return_all_nodes_and_relationships_within_the_subgraph)\n  - [12\\.3. Expand a spanning tree](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/path-finding\/#_expand_a_spanning_tree)\n  - [12\\.4. Neighbor Functions](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/path-finding\/neighbourhood-search\/)\n- [13\\. Cypher Execution](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/cypher-execution\/)\n  - [13\\.1. Running Cypher fragments](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/cypher-execution\/running-cypher\/)\n  - [13\\.2. Job management and periodic execution](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/cypher-execution\/job-management\/)\n  - [13\\.3. apoc.periodic.iterate](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/cypher-execution\/commit-batching\/)\n  - [13\\.4. apoc.periodic.commit](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/cypher-execution\/periodic-commit\/)\n  - [13\\.5. apoc.periodic.countdown](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/cypher-execution\/#_apoc_periodic_countdown)\n  - [13\\.6. Custom, Cypher Based Procedures and Functions](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/cypher-execution\/cypher-based-procedures-functions\/)\n- [14\\. Virtual Nodes & Relationships (Graph Projections)](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/virtual\/)\n  - [14\\.1. Use Cases](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/virtual\/#_use_cases)\n  - [14\\.2. Virtual Nodes\/Rels](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/virtual\/virtual-nodes-rels\/)\n  - [14\\.3. Nodes collapse](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/virtual\/#_nodes_collapse)\n  - [14\\.4. Nodes collapse example](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/virtual\/#_nodes_collapse_example)\n  - [14\\.5. Virtual Graph](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/virtual\/virtual-graph\/)\n  - [14\\.6. Graph Grouping](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/virtual\/graph-grouping\/)\n- [15\\. Graph Refactoring](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/graph-refactoring\/)\n  - [15\\.1. Clone nodes](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/graph-refactoring\/clone-nodes\/)\n  - [15\\.2. Clone subgraph](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/graph-refactoring\/clone-subgraph\/)\n  - [15\\.3. Merge Nodes](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/graph-refactoring\/merge-nodes\/)\n  - [15\\.4. Redirect relationships](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/graph-refactoring\/redirect-relationship\/)\n  - [15\\.5. Invert relationship](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/graph-refactoring\/invert-relationship\/)\n  - [15\\.6. Set Relationship Tsype](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/graph-refactoring\/set-relationship-type\/)\n  - [15\\.7. Extract node from relationships](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/graph-refactoring\/extract-node-from-relationship\/)\n  - [15\\.8. Collapse node to relationship](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/graph-refactoring\/collapse-node-to-relationship\/)\n  - [15\\.9. Normalize As Boolean](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/graph-refactoring\/#_normalize_as_boolean)\n  - [15\\.10. Categorize](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/graph-refactoring\/categorize\/)\n  - [15\\.11. Using Cypher and APOC to move a property value to a label](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/graph-refactoring\/#_using_cypher_and_apoc_to_move_a_property_value_to_a_label)\n  - [15\\.12. Rename](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/graph-refactoring\/rename-label-type-property\/)\n- [16\\. Operational](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/operational\/)\n  - [16\\.1. Time To Live (TTL) - Expire Nodes](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/operational\/#_time_to_live_ttl_expire_nodes)\n  - [16\\.2. Triggers](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/operational\/triggers\/)\n  - [16\\.3. Cypher init script](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/operational\/init-script\/)\n  - [16\\.4. Config](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/operational\/#neo4j-config)\n  - [16\\.5. Warmup](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/operational\/warmup\/)\n  - [16\\.6. Monitoring](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/operational\/monitoring\/)\n- [17\\. Text and Lookup Indexes](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/indexes\/)\n  - [17\\.1. Schema Index Procedures](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/indexes\/schema-index-operations\/)\n  - [17\\.2. Deprecated: Manual Indexes](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/indexes\/manual-indexes\/)\n  - [17\\.3. Manual Index Examples](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/indexes\/#_manual_index_examples)\n  - [17\\.4. Deprecated: Full Text Search](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/indexes\/fulltext-index\/)\n- [18\\. Deprecated: Graph Algorithms](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/algorithms\/)\n  - [18\\.1. Similarity](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/algorithms\/similarity\/)\n  - [18\\.2. Community Detection via Label Propagation](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/algorithms\/community-detection\/)\n  - [18\\.3. Centrality Algorithms](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/algorithms\/centrality\/)\n  - [18\\.4. PageRank Algorithm](https:\/\/neo4j-contrib.github.io\/neo4j-apoc-procedures\/3.5\/algorithms\/pagerank\/)\n\n## 10\\.3. Collection Functions\nAPOC has a wide variety of Collection and List functions.\n\n|   |   |\n|---|---|\n| `apoc.coll.sum([0.5,1,2.3])` | sum of all values in a list |\n| `apoc.coll.avg([0.5,1,2.3])` | avg of all values in a list |\n| `apoc.coll.min([0.5,1,2.3])` | minimum of all values in a list |\n| `apoc.coll.max([0.5,1,2.3])` | maximum of all values in a list |\n| `apoc.coll.sumLongs([1,3,3])` | sums all numeric values in a list |\n| `apoc.coll.partition(list,batchSize)` | partitions a list into sublists of `batchSize` |\n| `apoc.coll.zip([list1],[list2])` | all values in a list |\n| `apoc.coll.pairs([1,2,3]) YIELD value` | \\[1,2\\],\\[2,3\\],\\[3,null\\] |\n| `apoc.coll.pairsMin([1,2,3]) YIELD value` | \\[1,2\\],\\[2,3\\] |\n| `apoc.coll.toSet([list])` | returns a unique list backed by a set |\n| `apoc.coll.sort(coll)` | sort on Collections |\n| `apoc.coll.sortNodes([nodes], 'name')` | sort nodes by property, ascending sorting by adding ^ in front of the sorting field |\n| `apoc.coll.sortMaps([maps], 'key')` | sort maps by map key, ascending sorting by adding ^ in front of the sorting field |\n| `apoc.coll.reverse(coll)` | returns the reversed list |\n| `apoc.coll.contains(coll, value)` | returns true if collection contains the value |\n| `apoc.coll.containsAll(coll, values)` | optimized contains-all operation (using a HashSet) returns true or false |\n| `apoc.coll.containsSorted(coll, value)` | optimized contains on a sorted list operation (Collections.binarySearch) (returns true or false) |\n| `apoc.coll.containsAllSorted(coll, value)` | optimized contains-all on a sorted list operation (Collections.binarySearch) (returns true or false) |\n| `apoc.coll.union(first, second)` | creates the distinct union of the 2 lists |\n| `apoc.coll.subtract(first, second)` | returns unique set of first list with all elements of second list removed |\n| `apoc.coll.removeAll(first, second)` | returns first list with all elements of second list removed |\n| `apoc.coll.intersection(first, second)` | returns the unique intersection of the two lists |\n| `apoc.coll.disjunction(first, second)` | returns the disjunct set of the two lists |\n| `apoc.coll.unionAll(first, second)` | creates the full union with duplicates of the two lists |\n| `apoc.coll.split(list,value)` | splits collection on given values rows of lists, value itself will not be part of resulting lists |\n| `apoc.coll.indexOf(coll, value)` | position of value in the list |\n| `apoc.coll.shuffle(coll)` | returns the shuffled list |\n| `apoc.coll.randomItem(coll)` | returns a random item from the list |\n| `apoc.coll.randomItems(coll, itemCount, allowRepick: false)` | returns a list of `itemCount` random items from the list, optionally allowing picked elements to be picked again |\n| `apoc.coll.containsDuplicates(coll)` | returns true if a collection contains duplicate elements |\n| `apoc.coll.duplicates(coll)` | returns a list of duplicate items in the collection |\n| `apoc.coll.duplicatesWithCount(coll)` | returns a list of duplicate items in the collection and their count, keyed by `item` and `count` (e.g., `[{item: xyz, count:2}, {item:zyx, count:5}]`) |\n| `apoc.coll.occurrences(coll, item)` | returns the count of the given item in the collection |\n| `apoc.coll.frequencies(coll)` | returns a list of frequencies of the items in the collection, keyed by `item` and `count` (e.g., `[{item: xyz, count:2}, {item:zyx, count:5}, {item:abc, count:1}]`) |\n| `apoc.coll.frequenciesAsMap(coll)` | return a map of frequencies of the items in the collection, keyed by `item` and `count` (e.g., `{1: 2, 3: 2}`) |\n| `apoc.coll.sortMulti` | sort list of maps by several sort fields (ascending with ^ prefix) and optionally applies limit and skip |\n| `apoc.coll.flatten` | flattens a nested list |\n| `apoc.coll.combinations(coll, minSelect, maxSelect:minSelect)` | Returns collection of all combinations of list elements of selection size between minSelect and maxSelect (default:minSelect), inclusive |\n| `CALL apoc.coll.elements(list,limit,offset) yield _1,_2,..,_10,_1s,_2i,_3f,_4m,_5l,_6n,_7r,_8p` | deconstruct subset of mixed list into identifiers of the correct type |\n| `apoc.coll.set(coll, index, value)` | set index to value |\n| `apoc.coll.insert(coll, index, value)` | insert value at index |\n| `apoc.coll.insertAll(coll, index, values)` | insert values at index |\n| `apoc.coll.remove(coll, index, [length=1])` | remove range of values from index to length |\n| `apoc.coll.different(values)` | returns true if value are different |","attrs_readable_markdown":null,"meta_canonical":null}

3. Robots.txt Check

Query:

Response:

4. Spam/Ban Check

Query:

Response:

5. Seen Status Check

ℹ️ Skipped - page is already crawled

📄

INDEXABLE

✅

CRAWLED

22 days ago

🤖

ROBOTS ALLOWED

Page Info Filters

Filter	Status	Condition	Details
HTTP status	PASS	`download_http_code = 200`	HTTP 200
Age cutoff	PASS	`download_stamp > now() - 6 MONTH`	0.8 months ago
History drop	PASS	`isNull(history_drop_reason)`	No drop reason
Spam/ban	PASS	`fh_dont_index != 1 AND ml_spam_score = 0`	ml_spam_score=0
Canonical	PASS	`meta_canonical IS NULL OR = '' OR = src_unparsed`	Not set

Page Details

Property	Value
URL	https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/utilities/collection-list-functions/
Last Crawled	2026-03-25 17:43:19 (22 days ago)
First Indexed	2019-03-11 22:24:22 (7 years ago)
HTTP Status Code	200
Meta Title	10.3. Collection Functions - Chapter 10. Utility Functions
Meta Description	null
Meta Canonical	null
Boilerpipe Text	apoc.coll.sum([0.5,1,2.3]) sum of all values in a list apoc.coll.avg([0.5,1,2.3]) avg of all values in a list apoc.coll.min([0.5,1,2.3]) minimum of all values in a list apoc.coll.max([0.5,1,2.3]) maximum of all values in a list apoc.coll.sumLongs([1,3,3]) sums all numeric values in a list apoc.coll.partition(list,batchSize) partitions a list into sublists of batchSize apoc.coll.zip([list1],[list2]) all values in a list apoc.coll.pairs([1,2,3]) YIELD value [1,2],[2,3],[3,null] apoc.coll.pairsMin([1,2,3]) YIELD value [1,2],[2,3] apoc.coll.toSet([list]) returns a unique list backed by a set apoc.coll.sort(coll) sort on Collections apoc.coll.sortNodes([nodes], 'name') sort nodes by property, ascending sorting by adding ^ in front of the sorting field apoc.coll.sortMaps([maps], 'key') sort maps by map key, ascending sorting by adding ^ in front of the sorting field apoc.coll.reverse(coll) returns the reversed list apoc.coll.contains(coll, value) returns true if collection contains the value apoc.coll.containsAll(coll, values) optimized contains-all operation (using a HashSet) returns true or false apoc.coll.containsSorted(coll, value) optimized contains on a sorted list operation (Collections.binarySearch) (returns true or false) apoc.coll.containsAllSorted(coll, value) optimized contains-all on a sorted list operation (Collections.binarySearch) (returns true or false) apoc.coll.union(first, second) creates the distinct union of the 2 lists apoc.coll.subtract(first, second) returns unique set of first list with all elements of second list removed apoc.coll.removeAll(first, second) returns first list with all elements of second list removed apoc.coll.intersection(first, second) returns the unique intersection of the two lists apoc.coll.disjunction(first, second) returns the disjunct set of the two lists apoc.coll.unionAll(first, second) creates the full union with duplicates of the two lists apoc.coll.split(list,value) splits collection on given values rows of lists, value itself will not be part of resulting lists apoc.coll.indexOf(coll, value) position of value in the list apoc.coll.shuffle(coll) returns the shuffled list apoc.coll.randomItem(coll) returns a random item from the list apoc.coll.randomItems(coll, itemCount, allowRepick: false) returns a list of itemCount random items from the list, optionally allowing picked elements to be picked again apoc.coll.containsDuplicates(coll) returns true if a collection contains duplicate elements apoc.coll.duplicates(coll) returns a list of duplicate items in the collection apoc.coll.duplicatesWithCount(coll) returns a list of duplicate items in the collection and their count, keyed by item and count (e.g., [{item: xyz, count:2}, {item:zyx, count:5}] ) apoc.coll.occurrences(coll, item) returns the count of the given item in the collection apoc.coll.frequencies(coll) returns a list of frequencies of the items in the collection, keyed by item and count (e.g., [{item: xyz, count:2}, {item:zyx, count:5}, {item:abc, count:1}] ) apoc.coll.frequenciesAsMap(coll) return a map of frequencies of the items in the collection, keyed by item and count (e.g., {1: 2, 3: 2} ) apoc.coll.sortMulti sort list of maps by several sort fields (ascending with ^ prefix) and optionally applies limit and skip apoc.coll.flatten flattens a nested list apoc.coll.combinations(coll, minSelect, maxSelect:minSelect) Returns collection of all combinations of list elements of selection size between minSelect and maxSelect (default:minSelect), inclusive CALL apoc.coll.elements(list,limit,offset) yield _1,_2,..,_10,_1s,_2i,_3f,_4m,_5l,_6n,_7r,_8p deconstruct subset of mixed list into identifiers of the correct type apoc.coll.set(coll, index, value) set index to value apoc.coll.insert(coll, index, value) insert value at index apoc.coll.insertAll(coll, index, values) insert values at index apoc.coll.remove(coll, index, [length=1]) remove range of values from index to length apoc.coll.different(values) returns true if value are different
Markdown	[![Neo4j Logo](https://neo4j.com/wp-content/themes/neo4jweb/assets/images/neo4j-logo-2015.png)](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/utilities/collection-list-functions/) - [Operations Manual](https://neo4j.com/docs/operations-manual/current) - [Developer Manual](https://neo4j.com/docs/developer-manual/current/) - [OGM Manual](https://neo4j.com/docs/ogm-manual/current/) - [Graph Algorithms](https://neo4j.com/docs/graph-algorithms/current/) - [APOC](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/) - [Java Reference](https://neo4j.com/docs/java-reference/current/) [Map Functions](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/utilities/map-functions/) 10\.3. Collection Functions [Text Functions](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/utilities/text-functions/) Table of Contents - [1\. Introduction](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/) - [1\.1. Documentation Overview](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/#_documentation_overview) - [1\.2. Installation: With Neo4j Desktop](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/#_installation_with_neo4j_desktop) - [1\.3. Feedback](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/#_feedback) - [1\.4. Calling Procedures & Functions within Cypher](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/#_calling_procedures_functions_within_cypher) - [2\. Built in Help](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/help/) - [2\.1. Procedure & Function Signatures](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/help/#_procedure_function_signatures) - [3\. Installation in Neo4j Server & Docker](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/installation/) - [3\.1. Manual Installation: Download latest release](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/installation/#_manual_installation_download_latest_release) - [3\.2. Using APOC with the Neo4j Docker image](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/installation/#_using_apoc_with_the_neo4j_docker_image) - [4\. Overview of APOC Procedures & Functions](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/overview/) - [5\. Configuration Options](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/config/) - [6\. User Defined Functions](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/utilities/collection-list-functions/#_user_defined_functions) - [7\. Export / Import](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/export-import/) - [7\.1. Loading Data from Web-APIs](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/export-import/#_loading_data_from_web_apis) - [7\.2. Load JSON](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/export-import/load-json/) - [7\.3. Load CSV](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/export-import/load-csv/) - [7\.4. Import CSV](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/export-import/import-csv/) - [7\.5. Loading Excel (XLS)](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/export-import/load-xls/) - [7\.6. Load XML](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/export-import/load-xml/) - [7\.7. Export to CSV](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/export-import/#export-csv) - [7\.8. Export to Json File](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/export-import/#export-json) - [7\.9. Export to Cypher Script](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/export-import/#export-cypher) - [7\.10. GraphML Import / Export](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/export-import/graphml/) - [8\. Database Integration](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/database-integration/) - [8\.1. Load JDBC](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/database-integration/load-jdbc/) - [8\.2. Database Modeling](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/database-integration/database-modeling/) - [8\.3. ElasticSearch Integration](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/database-integration/elasticsearch/) - [8\.4. Interacting with MongoDB](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/database-integration/mongodb/) - [8\.5. Interacting with Couchbase](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/database-integration/couchbase/) - [8\.6. Bolt](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/database-integration/bolt-neo4j/) - [8\.7. Load LDAP](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/database-integration/load-ldap/) - [9\. Schema Information and Operations](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/schema/) - [9\.1. Meta Graph](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/schema/meta-graph/) - [10\. Utility Functions](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/utilities/) - [10\.1. Conversion Functions](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/utilities/conversion-functions/) - [10\.2. Map Functions](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/utilities/map-functions/) - [10\.3. Collection Functions](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/utilities/collection-list-functions/) - [10\.4. Text Functions](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/utilities/text-functions/) - [10\.5. Math Functions](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/utilities/math-functions/) - [10\.6. Spatial](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/utilities/spatial/) - [10\.7. Static Value Storage](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/utilities/static-values/) - [10\.8. Utilities](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/utilities/utility-functions/) - [10\.9. Phonetic Text Functions](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/utilities/phonetic-functions/) - [10\.10. Extract Domain](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/utilities/data-extraction-functions/) - [10\.11. Date and Time Conversions](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/utilities/datetime-conversions/) - [10\.12. Temporal Functions](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/utilities/temporal-conversions/) - [10\.13. Number Format Conversions](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/utilities/number-conversions/) - [10\.14. Exact Math](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/utilities/exact-math-functions/) - [10\.15. Fingerprinting](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/utilities/fingerprinting/) - [10\.16. Bitwise operations](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/utilities/bitwise-operations/) - [10\.17. Atomic](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/utilities/atomic-updates/) - [10\.18. Atomic Examples](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/utilities/#_atomic_examples) - [10\.19. Log](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/utilities/#_log) - [11\. Node, Relationship and Path Functions and Procedures](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/nodes-relationships/) - [11\.1. Path Functions](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/nodes-relationships/path-functions/) - [11\.2. Lookup and Manipulation Procedures](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/nodes-relationships/node-lookup/) - [11\.3. Node Functions](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/nodes-relationships/node-functions/) - [11\.4. Creating Data](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/nodes-relationships/data-creation/) - [11\.5. Locking](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/nodes-relationships/locking/) - [11\.6. Generating Graphs](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/nodes-relationships/graph-generators/) - [11\.7. Parallel Node Search](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/nodes-relationships/parallel-node-search/) - [12\. Path Finding](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/path-finding/) - [12\.1. Path Expander](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/path-finding/path-expander/) - [12\.2. Expand to a subgraph and return all nodes and relationships within the subgraph](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/path-finding/#_expand_to_a_subgraph_and_return_all_nodes_and_relationships_within_the_subgraph) - [12\.3. Expand a spanning tree](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/path-finding/#_expand_a_spanning_tree) - [12\.4. Neighbor Functions](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/path-finding/neighbourhood-search/) - [13\. Cypher Execution](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/cypher-execution/) - [13\.1. Running Cypher fragments](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/cypher-execution/running-cypher/) - [13\.2. Job management and periodic execution](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/cypher-execution/job-management/) - [13\.3. apoc.periodic.iterate](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/cypher-execution/commit-batching/) - [13\.4. apoc.periodic.commit](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/cypher-execution/periodic-commit/) - [13\.5. apoc.periodic.countdown](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/cypher-execution/#_apoc_periodic_countdown) - [13\.6. Custom, Cypher Based Procedures and Functions](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/cypher-execution/cypher-based-procedures-functions/) - [14\. Virtual Nodes & Relationships (Graph Projections)](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/virtual/) - [14\.1. Use Cases](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/virtual/#_use_cases) - [14\.2. Virtual Nodes/Rels](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/virtual/virtual-nodes-rels/) - [14\.3. Nodes collapse](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/virtual/#_nodes_collapse) - [14\.4. Nodes collapse example](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/virtual/#_nodes_collapse_example) - [14\.5. Virtual Graph](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/virtual/virtual-graph/) - [14\.6. Graph Grouping](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/virtual/graph-grouping/) - [15\. Graph Refactoring](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/graph-refactoring/) - [15\.1. Clone nodes](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/graph-refactoring/clone-nodes/) - [15\.2. Clone subgraph](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/graph-refactoring/clone-subgraph/) - [15\.3. Merge Nodes](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/graph-refactoring/merge-nodes/) - [15\.4. Redirect relationships](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/graph-refactoring/redirect-relationship/) - [15\.5. Invert relationship](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/graph-refactoring/invert-relationship/) - [15\.6. Set Relationship Tsype](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/graph-refactoring/set-relationship-type/) - [15\.7. Extract node from relationships](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/graph-refactoring/extract-node-from-relationship/) - [15\.8. Collapse node to relationship](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/graph-refactoring/collapse-node-to-relationship/) - [15\.9. Normalize As Boolean](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/graph-refactoring/#_normalize_as_boolean) - [15\.10. Categorize](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/graph-refactoring/categorize/) - [15\.11. Using Cypher and APOC to move a property value to a label](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/graph-refactoring/#_using_cypher_and_apoc_to_move_a_property_value_to_a_label) - [15\.12. Rename](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/graph-refactoring/rename-label-type-property/) - [16\. Operational](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/operational/) - [16\.1. Time To Live (TTL) - Expire Nodes](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/operational/#_time_to_live_ttl_expire_nodes) - [16\.2. Triggers](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/operational/triggers/) - [16\.3. Cypher init script](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/operational/init-script/) - [16\.4. Config](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/operational/#neo4j-config) - [16\.5. Warmup](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/operational/warmup/) - [16\.6. Monitoring](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/operational/monitoring/) - [17\. Text and Lookup Indexes](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/indexes/) - [17\.1. Schema Index Procedures](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/indexes/schema-index-operations/) - [17\.2. Deprecated: Manual Indexes](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/indexes/manual-indexes/) - [17\.3. Manual Index Examples](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/indexes/#_manual_index_examples) - [17\.4. Deprecated: Full Text Search](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/indexes/fulltext-index/) - [18\. Deprecated: Graph Algorithms](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/algorithms/) - [18\.1. Similarity](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/algorithms/similarity/) - [18\.2. Community Detection via Label Propagation](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/algorithms/community-detection/) - [18\.3. Centrality Algorithms](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/algorithms/centrality/) - [18\.4. PageRank Algorithm](https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/algorithms/pagerank/) ## 10\.3. Collection Functions APOC has a wide variety of Collection and List functions. \| \| \| \|---\|---\| \| `apoc.coll.sum([0.5,1,2.3])` \| sum of all values in a list \| \| `apoc.coll.avg([0.5,1,2.3])` \| avg of all values in a list \| \| `apoc.coll.min([0.5,1,2.3])` \| minimum of all values in a list \| \| `apoc.coll.max([0.5,1,2.3])` \| maximum of all values in a list \| \| `apoc.coll.sumLongs([1,3,3])` \| sums all numeric values in a list \| \| `apoc.coll.partition(list,batchSize)` \| partitions a list into sublists of `batchSize` \| \| `apoc.coll.zip([list1],[list2])` \| all values in a list \| \| `apoc.coll.pairs([1,2,3]) YIELD value` \| \[1,2\],\[2,3\],\[3,null\] \| \| `apoc.coll.pairsMin([1,2,3]) YIELD value` \| \[1,2\],\[2,3\] \| \| `apoc.coll.toSet([list])` \| returns a unique list backed by a set \| \| `apoc.coll.sort(coll)` \| sort on Collections \| \| `apoc.coll.sortNodes([nodes], 'name')` \| sort nodes by property, ascending sorting by adding ^ in front of the sorting field \| \| `apoc.coll.sortMaps([maps], 'key')` \| sort maps by map key, ascending sorting by adding ^ in front of the sorting field \| \| `apoc.coll.reverse(coll)` \| returns the reversed list \| \| `apoc.coll.contains(coll, value)` \| returns true if collection contains the value \| \| `apoc.coll.containsAll(coll, values)` \| optimized contains-all operation (using a HashSet) returns true or false \| \| `apoc.coll.containsSorted(coll, value)` \| optimized contains on a sorted list operation (Collections.binarySearch) (returns true or false) \| \| `apoc.coll.containsAllSorted(coll, value)` \| optimized contains-all on a sorted list operation (Collections.binarySearch) (returns true or false) \| \| `apoc.coll.union(first, second)` \| creates the distinct union of the 2 lists \| \| `apoc.coll.subtract(first, second)` \| returns unique set of first list with all elements of second list removed \| \| `apoc.coll.removeAll(first, second)` \| returns first list with all elements of second list removed \| \| `apoc.coll.intersection(first, second)` \| returns the unique intersection of the two lists \| \| `apoc.coll.disjunction(first, second)` \| returns the disjunct set of the two lists \| \| `apoc.coll.unionAll(first, second)` \| creates the full union with duplicates of the two lists \| \| `apoc.coll.split(list,value)` \| splits collection on given values rows of lists, value itself will not be part of resulting lists \| \| `apoc.coll.indexOf(coll, value)` \| position of value in the list \| \| `apoc.coll.shuffle(coll)` \| returns the shuffled list \| \| `apoc.coll.randomItem(coll)` \| returns a random item from the list \| \| `apoc.coll.randomItems(coll, itemCount, allowRepick: false)` \| returns a list of `itemCount` random items from the list, optionally allowing picked elements to be picked again \| \| `apoc.coll.containsDuplicates(coll)` \| returns true if a collection contains duplicate elements \| \| `apoc.coll.duplicates(coll)` \| returns a list of duplicate items in the collection \| \| `apoc.coll.duplicatesWithCount(coll)` \| returns a list of duplicate items in the collection and their count, keyed by `item` and `count` (e.g., `[{item: xyz, count:2}, {item:zyx, count:5}]`) \| \| `apoc.coll.occurrences(coll, item)` \| returns the count of the given item in the collection \| \| `apoc.coll.frequencies(coll)` \| returns a list of frequencies of the items in the collection, keyed by `item` and `count` (e.g., `[{item: xyz, count:2}, {item:zyx, count:5}, {item:abc, count:1}]`) \| \| `apoc.coll.frequenciesAsMap(coll)` \| return a map of frequencies of the items in the collection, keyed by `item` and `count` (e.g., `{1: 2, 3: 2}`) \| \| `apoc.coll.sortMulti` \| sort list of maps by several sort fields (ascending with ^ prefix) and optionally applies limit and skip \| \| `apoc.coll.flatten` \| flattens a nested list \| \| `apoc.coll.combinations(coll, minSelect, maxSelect:minSelect)` \| Returns collection of all combinations of list elements of selection size between minSelect and maxSelect (default:minSelect), inclusive \| \| `CALL apoc.coll.elements(list,limit,offset) yield _1,_2,..,_10,_1s,_2i,_3f,_4m,_5l,_6n,_7r,_8p` \| deconstruct subset of mixed list into identifiers of the correct type \| \| `apoc.coll.set(coll, index, value)` \| set index to value \| \| `apoc.coll.insert(coll, index, value)` \| insert value at index \| \| `apoc.coll.insertAll(coll, index, values)` \| insert values at index \| \| `apoc.coll.remove(coll, index, [length=1])` \| remove range of values from index to length \| \| `apoc.coll.different(values)` \| returns true if value are different \|
Readable Markdown	null
Shard	143 (laksa)
Root Hash	2566890010099092343
Unparsed URL	io,github!neo4j-contrib,/neo4j-apoc-procedures/3.5/utilities/collection-list-functions/ s443