Thanks for your reply, Michela,

The plot I want to make looks like this:

        R      R  
U <- M_/        \_M->U
       \        / 
        R      R 


Here are the records in JSON format that would be returned by the query. 
The edges that connect the records are HasAuthor (connects M and U) and 
HasMP (connects M and R).
The query finds all the proposals their authors, and the runs that used 
them where the proposal was used in more than one run.
Thanks,
john

[
    {
        "@type": "d",
        "@rid": "#-2:1",
        "@version": 0,
        "R": "#16:0",
        "R2brief": "MP#750 - Investigation of the mode structure of the WCM 
with a scanning",
        "R2run": 1150722,
        "R2entered": "2015-07-22 08:04:00",
        "R2dbkey": "2686",
        "R2username": "PFEIFFER",
        "R2out_HasMP": [
            "#17:0"
        ],
        "U": "#12:114",
        "U2hidden": 0,
        "U2active": 1,
        "U2EO": 0,
        "U2pager": null,
        "U2comment": null,
        "U2PO": 0,
        "U2in_HasAuthor": [
            "#15:64",
            "#15:85",
            "#15:86",
            "#15:163",
            "#15:169",
            "#15:173",
            "#15:182",
            "#15:216",
            "#15:268",
            "#15:279",
            "#15:280",
            "#15:299",
            "#15:308",
            "#15:367",
            "#15:375",
            "#15:391",
            "#15:392",
            "#15:455",
            "#15:460",
            "#15:473",
            "#15:516",
            "#15:517",
            "#15:542",
            "#15:555",
            "#15:578",
            "#15:687",
            "#15:697",
            "#15:718",
            "#15:743",
            "#15:744",
            "#15:768",
            "#15:775"
        ],
        "M": "#13:752",
        "M2in_HasMP": [
            "#17:0",
            "#17:4"
        ],
        "M2date_filed": "2014-07-11 00:00:00",
        "M2file_date": " 7/11/2014",
        "M2mp": 2269,
        "M2id": "750",
        "M2fullname": "B, Lab.",
        "M2title": "Investigation of the mode structure of the WCM with a 
scanning Mirror Langmuir probe",
        "M2status": "Open",
        "M2lastname": "Lab.",
        "M2out_HasAuthor": [
            "#15:743"
        ],
        "@fieldTypes": 
"R=x,R2entered=t,R2out_HasMP=g,U=x,U2in_HasAuthor=g,M=x,M2in_HasMP=g,M2date_filed=t,M2out_HasAuthor=g"
    },
    {
        "@type": "d",
        "@rid": "#-2:2",
        "@version": 0,
        "R": "#16:3",
        "R2out_HasMP": [
            "#17:4",
            "#17:5",
            "#17:6"
        ],
        "R2brief": "MP#750 - Investigation of the mode structure of the WCM 
with a scanning",
        "R2run": 1160929,
        "R2entered": "2016-09-29 06:24:00",
        "R2dbkey": "2832",
        "R2username": "engops",
        "U": "#12:114",
        "U2name": "Lab.",
        "U2hidden": 0,
        "U2active": 1,
        "U2EO": 0,
        "U2comment": null,
        "U2fullname": "B. Lab.",
        "U2PO": 0,
        "U2in_HasAuthor": [
            "#15:64",
            "#15:85",
            "#15:86",
            "#15:163",
            "#15:169",
            "#15:173",
            "#15:182",
            "#15:216",
            "#15:268",
            "#15:279",
            "#15:280",
            "#15:299",
            "#15:308",
            "#15:367",
            "#15:375",
            "#15:391",
            "#15:392",
            "#15:455",
            "#15:460",
            "#15:473",
            "#15:516",
            "#15:517",
            "#15:542",
            "#15:555",
            "#15:578",
            "#15:687",
            "#15:697",
            "#15:718",
            "#15:743",
            "#15:744",
            "#15:768",
            "#15:775"
        ],
        "M": "#13:752",
        "M2in_HasMP": [
            "#17:0",
            "#17:4"
        ],
        "M2date_filed": "2014-07-11 00:00:00",
        "M2file_date": " 7/11/2014",
        "M2mp": 2269,
        "M2id": "750",
        "M2fullname": "B. Lab.",
        "M2title": "Investigation of the mode structure of the WCM with a 
scanning Mirror Langmuir probe",
        "M2status": "Open",
        "M2out_HasAuthor": [
            "#15:743"
        ],
        "@fieldTypes": 
"R=x,R2out_HasMP=g,R2entered=t,U=x,U2in_HasAuthor=g,M=x,M2in_HasMP=g,M2date_filed=t,M2out_HasAuthor=g"
    },
    {
        "@type": "d",
        "@rid": "#-2:3",
        "@version": 0,
        "R": "#16:1",
        "R2brief": "MP826: Documenting high-performance EnhancingM-free 
plasma",
        "R2run": 1160830,
        "R2entered": "2016-08-30 06:04:00",
        "R2dbkey": "2812",
        "R2username": "engops",
        "R2out_HasMP": [
            "#17:1"
        ],
        "U": "#12:204",
        "U2name": "ssc",
        "U2hidden": 0,
        "U2active": 1,
        "U2EO": 0,
        "U2lastname": "Sc.",
        "U2comment": null,
        "U2PO": 1,
        "U2in_HasAuthor": [
            "#15:326",
            "#15:417",
            "#15:440",
            "#15:471",
            "#15:636",
            "#15:821"
        ],
        "M": "#13:831",
        "M2in_HasMP": [
            "#17:1",
            "#17:3"
        ],
        "M2date_filed": "2016-08-29 00:00:00",
        "M2file_date": " 8/29/2016",
        "M2mp": 2351,
        "M2id": "826",
        "M2title": "Documenting high-performance ELM-free plasmas",
        "M2status": "Open",
        "M2lastname": "Sc.",
        "M2out_HasAuthor": [
            "#15:821"
        ],
        "@fieldTypes": 
"R=x,R2entered=t,R2out_HasMP=g,U=x,U2in_HasAuthor=g,M=x,M2in_HasMP=g,M2date_filed=t,M2out_HasAuthor=g"
    },
    {
        "@type": "d",
        "@rid": "#-2:4",
        "@version": 0,
        "R": "#16:2",
        "R2out_HasMP": [
            "#17:2",
            "#17:3"
        ],
        "R2brief": "MP826: Documenting high-performance ELM-free plasmas",
        "R2run": 1160831,
        "R2entered": "2016-08-31 06:32:00",
        "R2dbkey": "2813",
        "R2username": "engops",
        "U": "#12:204",
        "U2hidden": 0,
        "U2active": 1,
        "U2EO": 0,
        "U2lastname": "Sc.",
        "U2comment": null,
        "U2PO": 1,
        "U2in_HasAuthor": [
            "#15:326",
            "#15:417",
            "#15:440",
            "#15:471",
            "#15:636",
            "#15:821"
        ],
        "M": "#13:831",
        "M2in_HasMP": [
            "#17:1",
            "#17:3"
        ],
        "M2date_filed": "2016-08-29 00:00:00",
        "M2file_date": " 8/29/2016",
        "M2mp": 2351,
        "M2id": "826",
        "M2title": "Documenting high-performance ELM-free plasmas",
        "M2status": "Open",
        "M2lastname": "Sc.",
        "M2out_HasAuthor": [
            "#15:821"
        ],
        "@fieldTypes": 
"R=x,R2out_HasMP=g,R2entered=t,U=x,U2in_HasAuthor=g,M=x,M2in_HasMP=g,M2date_filed=t,M2out_HasAuthor=g"
    }
]

On Thursday, 14 September 2017 16:56:22 UTC-4, [email protected] wrote:
>
> Hi John,
>
> can you provide an example of your structure?
>
> Thanks
>
> Regadrs,
>
> Michela
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to