Any way to query data from multiple nodes and return it all as one row?

[hewhofreeks]

For example, in our data structure we have Areas related to our business model which contain many ZipCodes and then each ZIpCode is associated with a City which is associated with a State. I would like to be able to take in a single Area Uid and then return a list of ZipCodes, the City Name it's in, and the state abbreviation.

What I'm looking for it to do something like this:

                var zipQuery = Transaction.CompiledQuery.Match(Node.ZipCode.Alias(out var zipCode)
                    .In.ZIPCODE_LOCATED_IN_CITY.Out.City.Alias(out var city).In.CITY_LOCATED_IN_STATE.Out.State.Alias(out var state))
                    .Match(Node.ContractorServiceArea.Alias(out var serviceArea).Out.INCLUDES_ZIP.In.ZipCode.Alias(out zipCode))
                    .Where(serviceArea.Uid == Parameter.New<string>("serviceAreaUid"))
                    .Return(zipCode.Zip, state.Abbr, city.Name)
                    .Compile();

Which generates the exact cypher I'd like to be able to run, but cannot figure out a way to run this query which might return the correct anonymous data types. I only see the
.LoadWhere()

queries on the created OGM objects.

I also honestly cannot tell the benfits of putting in multiple values in the .Return method either. It always seems like the return values are going to be attempted to be parsed into whatever static method you're running the .LoadWhere from.

Am I missing something or is this just a limitation of blueprint41?

[circles-arrows]

You can do something like this:

QueryExecutionContext context = zipQuery.GetExecutionContext();
context.SetParameter("serviceAreaUid", <Your Uid Here>);
List<dynamic> resultSet = context.Execute();

[hewhofreeks]

Awesome, thanks. Had no idea you could do this.

[ngallegos]

@circles-arrows , using the resultSet above, how would one go about getting the same objects that are returned from the LoadWhere() method. For example, if we had .Return(zipCode, state, city) instead of .Return(zipCode.Zip, state.Abbr, city.Name), how would I go about extracting the actual ZipCode, State, and City objects that would have come from ZipCode.LoadWhere(), State.LoadWhere() and City.LoadWhere() respectively?

[circles-arrows]

In the next version of Blueprint41 this will be available, however in the current version of Blueprint41 you will get a Neo4j “INode” object instead. From: ngallegos [mailto:notifications@github.com] Sent: Saturday, 29 August 2020 12:42 am To: circles-arrows/blueprint41 <blueprint41@noreply.github.com> Cc: CIRCLES ARROWS LIMITED <info@circles-arrows.com>; Mention <mention@noreply.github.com> Subject: Re: [circles-arrows/blueprint41] Any way to query data from multiple nodes and return it all as one row? (#5) @circles-arrows <https://github.com/circles-arrows> , using the resultSet above, how would one go about getting the same objects that are returned from the LoadWhere() method. For example, if we had .Return(zipCode, state, city) instead of .Return(zipCode.Zip, state.Abbr, city.Name), how would I go about extracting the actual ZipCode, State, and City objects that would have come from ZipCode.LoadWhere(), State.LoadWhere() and City.LoadWhere() respectively? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#5 (comment)> , or unsubscribe <https://github.com/notifications/unsubscribe-auth/AHROZP5CWRXFUKKZKQHVTFDSC7M4NANCNFSM4OHBWE2Q> . <https://github.com/notifications/beacon/AHROZPY5QJM5NHCJDO4IP3TSC7M4NA5CNFSM4OHBWE22YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOFCZZEVI.gif>

[ngallegos]

Sounds good. Thank you!