Stack Overflow
Stack Overflow

Questions tagged [aql]

ArangoDB Query Language (or AQL) is a declarative querying language used inside the multi-model database ArangoDB.

448 questions
0
votes
1 answer

Graph query using AQL

I have 3 collections, 1st one is the list (vertices), 2nd one is the users (vertices) and the third one is the activity (edges). I plan to store any kind of activity done on a list in the activity collection (such as like, comment, flag and so…
Mustanish Altamash
  • 139
  • 1
  • 9
0
votes
1 answer

Sum of nulls to return null

How to make sum(array[*].value) to return NULL if all values are NULL or no values? Currently it returns 0 in both cases The best I can think of is first_document(array[*].value) ? sum(array[*].value) : null which needs to iterate collection…
irriss
  • 742
  • 2
  • 11
  • 22
0
votes
1 answer

AQL: Dynamic query with nested array dates

I have been trying to get this dynamic query to work with dates as shown below in ArangoDB 3.1. This works perfectly when I'm not trying to query dates, but returns an empty list as soon as I try to query with a date like below... { query: …
Glstunna
  • 1,993
  • 3
  • 18
  • 27
0
votes
1 answer

Artifactory API AQL with Jenkins environment variables

I try to perform the following code in a postbuild Jenkins task: curl -H "X-JFrog-Art-Api:***********" -X POST https://artifactory_url/artifactory/api/search/aql -H "Content-Type: text/plain" -d…
garci86
  • 67
  • 1
  • 4
0
votes
1 answer

How to run aerospike AQL from remote servers to query aerospike cluster data

I am trying to run AQL queries on my aerosike cluster from remote servers. Please let me know if there any any AQL web/Cli client or any way to achieve it.
MohitKgec
  • 21
  • 4
0
votes
0 answers

AQL Query returns a Promise

I have been trying to get a query result from Arangodb in to my front end service(Angular 4) using soap message. I am able to get a result of the query but printed out in console.log. But how can I get it under this function(myService). In other…
cantona_7
  • 1,127
  • 4
  • 21
  • 40
0
votes
0 answers

About arangodb cluster performance improvement

I would like to ask some questions about the cluster network.First of all, I want to know why my cluster log can not be used? Is it because my cluster is not configured? My cluster starts as follows: arangodb --starter.join…
feitianStyle
  • 119
  • 3
0
votes
1 answer

AQL for pattern matching

i want to write an AQL FOR arrangodb TO FETCH all the results matching with a particuler input i tried something like this for all the locations which starts with GR FOR con IN countries FILTER "%GR%" LIKE con.location RETURN { "name" :…
avi
  • 175
  • 2
  • 5
  • 17
0
votes
1 answer

How to calculate the mode in ArangoDB?

I have transactions like this {"cust_id": "593ec", "recorded": "2015-10-15T11:22:22", "account_id": 1, "account_status": "P"}, {"cust_id": "593ec", "recorded": "2016-03-06T02:00:11", "account_id": 2, "account_status": "A"}, ... I want to summarize…
Kevin Landon
  • 51
  • 3
0
votes
1 answer

Traversal Flow Control in Arangodb 3.0+

I am looking for a way to control the traversal flow in ArangoDB 3.0+ the same way we could do it with a filter functions through the TRAVERSAL in ArangoDB 2 to prevent unnecessary vertices exploration. Is there an alternative or is it still…
sowee15
  • 1,197
  • 7
  • 15
0
votes
1 answer

can arangoDB aql skip filters by condition?

i work for a bbs app recently, and when i use the aql, i got a problem, for example: //params:.com/t/123?&digest=true => FOR t IN threads FILTER t.digest == true && some conditions RETURN t and the result is as expected,but when the…
lzszone
  • 65
  • 1
  • 8
0
votes
1 answer

artifactory query language for listing file types in date range

I am trying to list file types from a particular date range, so these large files can be deleted from artifactory storage, how to do this is confusing for me, so I thought of utilising the frog cli way using --spec switch, I have an expression but…
user2742389
  • 3
  • 2
0
votes
1 answer

arangodb aql effectively tarversing from startvertex through the endvertex and find connection between them

i'm very new to graph concept and arangodb. i plan to using both of them in a project which related to communication analysis. i have set the data to fit the need in arangodb with one document collection named object and one edge collection named…
Guntur Santoso
  • 73
  • 12
0
votes
1 answer

ArangoDB: Search for a property and filter multiple values in the path

I want to do an expand and search for nodes with a certain label. But i want also to filter the nodes of the path with a certain label. the label column contains values like "Entity;Person", "Entity;Organization" What i have got so far LET source =…
mabr
  • 370
  • 4
  • 17
0
votes
1 answer

ArangoDB: Find all shortest paths with conditions

problem: I have a start node and i am searching for nodes with a certain property. But i want only the nodes connected with the shortest ones. Example: The green nodes have the property set, but i want only "A" and "C" back, because "E" has a longer…
mabr
  • 370
  • 4
  • 17
1 2 3
…
29 30