Thanks Romiko, will look into it first time when I have time. How critical is it for you?
Cheers, /peter neubauer GTalk: neubauer.peter Skype peter.neubauer Phone +46 704 106975 LinkedIn http://www.linkedin.com/in/neubauer Twitter http://twitter.com/peterneubauer brew install neo4j && neo4j start heroku addons:add neo4j On Wed, Nov 30, 2011 at 1:31 AM, Romiko Derbynew <romiko.derby...@readify.net> wrote: > Hi, > > New bugged logged at: https://github.com/neo4j/community/issues/114 > > Details below for others to peruse. > > Gremlin Table Projections - Column Order Incorrect when using chained > .As('x').As('y') > > EXPECTED Order: Createdy, ReferralGroup, ReferralId, ReferralData > > When AS statements appear next to each other. > Consider A (WORKS - But not logical - have to reverse order when more than 1 > AS statement is chained together right after each other for column array to > match): > {"script":"g.v(0).outE[[label:'HOSTS']].inV.filter{ it.Key == 'romikoagency' > }.inE[[label:'USER_BELONGS_TO']].outV.filter{ it.Username == > 'romiko.derbynew' > }.as('CreatedBy').outE[[label:'USER_LINKED_TO_PROGRAM']].inV.as('ReferralGroup').inE[[label:'HAS_SUGGESTED_PROGRAM']].outV.inE[[label:'REFERRAL_HAS_DECISIONS_SECTION']].outV.as('ReferralDate').as('ReferralId').table(new > Table()){it.Username}{it.Name}{it.UniqueId}{it.DateInitiatedUtc}.cap" > } > > notice: as('ReferralDate').as('ReferralId') and then notice the column order > below is opposite this: "columns" .... "ReferralId", "ReferralDate" ] > > Results > [ [ { > "data" : [ [ "romiko.derbynew", "Testa", 331, "/Date(1322007153048+1100)/" ], > [ "romiko.derbynew", "Testa", 321, "/Date(1322003375637+1100)/" ]], > "columns" : [ "CreatedBy", "ReferralGroup", "ReferralId", "ReferralDate" ] > } ] ] > > > Consider B (Does not work - this is more LOGICAL from gremlin perspective but > is bugged, the Chained AS right after each other gets reversed in the column > array.) > {"script":"g.v(0).outE[[label:'HOSTS']].inV.filter{ it.Key == 'romikoagency' > }.inE[[label:'USER_BELONGS_TO']].outV.filter{ it.Username == > 'romiko.derbynew' > }.as('CreatedBy').outE[[label:'USER_LINKED_TO_PROGRAM']].inV.as('ReferralGroup').inE[[label:'HAS_SUGGESTED_PROGRAM']].outV.inE[[label:'REFERRAL_HAS_DECISIONS_SECTION']].outV.as('ReferralId').as('ReferralDate').table(new > Table()){it.Username}{it.Name}{it.UniqueId}{it.DateInitiatedUtc}.cap" > } > > Notice: .as('ReferralId').as('ReferralDate') and then the columns "columns" > .... "ReferralDate", "ReferralId" ] > > Results > [ [ { > "data" : [ [ "romiko.derbynew", "Testa", 331, "/Date(1322007153048+1100)/" ]], > "columns" : [ "CreatedBy", "ReferralGroup", "ReferralDate", "ReferralId" ] > } ] ] > > > _______________________________________________ > Neo4j mailing list > User@lists.neo4j.org > https://lists.neo4j.org/mailman/listinfo/user _______________________________________________ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
