Skip to content

Collection attributes mapping to Spline UI #1044

@abhineet13

Description

@abhineet13

Background [Optional]

Hi
We are writing AQLs on Arango Spline db to read the execution plan in tabular format and could not find certain fields like
1.) "Type" (JDBC)
2.) "Destination" of "type" for jdbc, jdbc string shows on UI but could not figure which collection has this information.
3.) "Executed at" on spline UI

Question

Is there a document mapping Arango collection attributes to Spline UI.

AQL:

FOR a in operation
    FOR doc IN executionPlan 
        FOR b in progressOf
            FOR c in progress
                FILTER (DATE_FORMAT(DATE_ISO8601(a._created),"%yyyy-%mm-%dd")=='2022-03-21'
                    OR  DATE_FORMAT(DATE_ISO8601(a._created),"%yyyy-%mm-%dd")=='2022-03-22')
                   AND doc._id==a._belongsTo
                   AND doc._id==b._to
                   AND b._from==c._id
                SORT a._id desc
                RETURN DISTINCT {
                    "datev"         : DATE_FORMAT(DATE_FORMAT(DATE_ISO8601(a._created),"%yyyy-%mm-%dd %hh:%mm:%ss"),"%yyyy-%mm-%dd"),
                    "appName"       : doc.name,
                    "sourceType"    : a.extra.sourceType,
                    "inputSources"  : a.inputSources,
                    "appId"         : c.extra.appId,
                    "id"            : doc._id, 
                    "operation_name": a.name,
                    "operation_id"  : execution._id,
                    "writeCnt"      : c.extra.writeMetrics.numOutputRows,
                    "duration"      : c.durationNs,
                    "param"         : a.params
                } 

Thanks
Abhineet

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    Status

    Done

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions