aql Questions
2
Solved
I am having a problem querying ArangoDB in java for a value of Arrays. I have tried with both String[] and ArrayList, both with no success.
My query:
FOR document IN documents FILTER @categoriesA...
4
Solved
I have a sample input file as follows, with columns Id, Name, start date, end date, Age, Description, and Location:
220;John;23/11/2008;22/12/2008;28;Working as a professor in University;Hyderabad
...
2
If I need to filter by array of IDs, how would I do that using bindings?
Documentation does not provide any hints on that.
for c in commit
filter c.hash in ['b0a3', '9f0eb', 'f037a0']
return c
1
Solved
1
Solved
Given the following document structure:
{
"_key": "abc",
"_id": "abc",
"label": "Company ABC",
"departments": [
{
"name": "Department 123",
"id": "123"
},
{
"name": "Department 456",
"i...
1
Solved
I am trying to use AQL to update the whole node collection , named Nodes, depend on the type of edges they have
.
Requirement:
Basically, if 2 entity in Nodes has relation type= "Same", they wou...
2
Solved
I have a graph with three collections which items can be connected by edges.
ItemA is a parent of itemB which in turn is a parent of itemC.
Elements only can be connected by edges in direction
...
Bigelow asked 6/10, 2016 at 13:56
1
Solved
In my ArangoDB graph, I have a subject, message threads associated with that subject, and messages inside those message threads. I would like to traverse the graph in such a way that I return the d...
Decury asked 21/9, 2016 at 19:42
1
Part of my graph is constructed using a giant join between two large collections, and I run it every time I add documents to either collection.
The query is based on an older post.
FOR fromItem IN...
Theisen asked 18/10, 2016 at 23:47
1
Solved
db.query(aql `
FOR doc IN ${collection}
FILTER REGEX_TEST(CONCAT(VALUES(doc, true)), ${queryStr}, true)
SORT doc[${sortBy}] ${dir}
LIMIT ${start, count}
RETURN doc._key
`)
.then(cursor =&g...
Capelin asked 15/9, 2016 at 15:39
3
Solved
The scenario is this: I have an ArangoDB collection containing items, and another collection containing tags. I am using a graph, and I have an edge collection called "Contains" connecting the item...
1
Solved
I'm sure there is an easy and fast way to do this but it's escaping me. I have a large dataset that has some duplicate records, and I want to get rid of the duplicates. (the duplicates are uniquely...
1
Solved
Lets say we have a database of food items such as:
item1 = {name: 'item1', tags: ['mexican', 'spicy']};
item2 = {name: 'item2', tags: ['sweet', 'chocolate', 'nuts']};
item3 = {name: 'item3', tags:...
1
Solved
I'm trying to use ArangoDB to get a list of friends-of-friends. Not just a basic friends-of-friends list, I also want to know how many friends the user and the friend-of-a-friend have in common and...
Result asked 22/10, 2015 at 11:21
2
Solved
Is there a way to randomly return a document from a collection using AQL?
I would like to create a random graph for testing purposes.
I have not yet figured out how to select documents at random f...
2
Solved
I want to find the set of users not having a profile.
ArangoDB 2.4.3
LENGTH(users) -> 130k
LENGTH(profiles) -> 110k
users.userId -> unique hash index
profiles.userId -> unique hash ...
1
I have a collection. My collection has 30 000 000 documents. I want to receive all its by means AQL query. I do so:
FOR c FROM MyCollection
SORT c.value ASC LIMIT 30000000
RETURN c.id
But I re...
1
Solved
How can I group my data in ArangoDB with AQL? For example, my structure is:
[
{name: "karl", id: "1", timestamp: "11112"},
{name: "migele", id": "2", timestamp: "11114"},
{name: "martina", id":...
2
Solved
I have collection 'Notifier'.
Given the following example document of this collection:
{
"timestamp": 1413543986,
"message": "message",
"readed": {
"user_8": 0,
"user_9": 0,
"user_22": 0
},...
1
Solved
I'm attempting a fairly basic task in arangodb, using the SUM() aggregate function.
Here is a working query which returns the right data (though not yet aggregated):
FOR m IN pkg_spp_RegMem
FILTE...
1
Solved
Let's imagine I have a few simple docs stored in an Arango collection like so:
[
{"type":Cat, "quality":Fuzzy}
{"type":Dog, "quality":Barks}
{"type":Rabbit, "quality":Hoppy}
{"type":Pig, "qual...
Ichthyosis asked 19/2, 2014 at 20:44
1
I primarily intended to ask this question : "Is ArangoDB a true graph database ?"
But, this question would sound quite offending.
You, peoples at triAGENS, did a really great job in creating a "m...
Quandary asked 9/1, 2014 at 12:32
1
Solved
In the context of ArangoDB, there are different database shells to query data:
arangosh: The JavaScript based console
AQL: Arangodb Query Language, see http://www.arangodb.org/2012/06/20/querying...
1
© 2022 - 2024 — McMap. All rights reserved.