Return statement not working with User defined functions in Arangodb? How to write an AQl query inside a function?

Question

require("@arangodb/aql/functions").register(
    "MYFUNCTIONS::VERTEX::INDEGREE", 
    function(vertex,edge, node) {
        "use strict"; 
        AQL_Query(
            (return( "for t in Transaction  collect vertex_count=t._from with into n return x"))
        )
    }
);

throws the following exception

JavaScript exception: SyntaxError: Unexpected token 'return'
!require("@arangodb/aql/functions").register("MYFUNCTIONS::VERTEX::INDEGREE", function(vertex,edge, node) {"use strict"; AQL_Query((return( "for t in Transaction  collect vertex_count=t._from with into n return x")))});
!                                                                                                                                   ^^^^^^
stacktrace: SyntaxError: Unexpected token 'return'

score 0 · Accepted Answer · 2022-09-19 10:55:52Z

0

Use the aql template string handler to assamble the query, something like this should get you started:

require("@arangodb/aql/functions").register(
    "MYFUNCTIONS::VERTEX::INDEGREE", 
    function(vertex,edge, node) {
        "use strict";
        let db = require('@arangodb').db;
        let aql = require('@arangodb').aql;
        
        let query = aql`
            for t in Transaction  
              collect vertex_count=t._from with into n 
              return n
        `;
        return db._query(query).toArray();
    }
);

edited Sep 19, 2022 at 10:55

answered Sep 19, 2022 at 8:46

user594138

Sign up to request clarification or add additional context in comments.

3 Comments

Chaitanya Srinevas Over a year ago

Also how to call a function in the Arangoshell?

user594138 Over a year ago

In AQL-statements; you register functions for use in aql statements...; db._query(aql`return MYFUNCTIONS::VERTEX::INDEGREE()`);. Maybe a foxx-service is what you really want to develop? (though a registered function can be a nice stepping stone).

user594138 Over a year ago

To call user functions from user functions see this Q/A: stackoverflow.com/questions/28366753/…

Collectives™ on Stack Overflow

Return statement not working with User defined functions in Arangodb? How to write an AQl query inside a function?

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related