Unable to filter object based on a matching attribute in another object about jsonata HOT 7 CLOSED

This is failing because it is trying to find Account as a property of Order. Everything within the square brackets is evaluated in the context of each Order. So you need to tell it that Account is a property of the root of the JSON structure. You do this using the $$ syntax (see http://docs.jsonata.org/programming.html#built-in-variables). The following expression should do what you need:
Accounts.Order[OrderID = $$.Account.Shipping.OrderID]

from jsonata.

@andrew-coleman thanks for the quick response. Thanks helped.
I was earlier trying with $ and not the $$ which was my mistake.

from jsonata.

@andrew-coleman it looks like i had some cached response. when i tried what you suggested, it still is not working. I am getting no match even though i have the same OrderID in both.

from jsonata.

@raj-work Not sure if the difference between Accounts and Account both in your example and @andrew-coleman's suggestion is the key here...

I added a shipping object with an orderID and used Account.Order[OrderID=$$.Account.Shipping.OrderID] to successfully match only the order which was listed in the shipping object, which is what I'd interpreted your original query to be. See http://try.jsonata.org/rkEXhYt4b

If that's not what you're looking for, could you please share the structure of your data via the try.jsonata.org exerciser.

from jsonata.

@mattbaileyuk it works if there is only one Shipping object. But if I have more than one Shipping object, it doesnt work. So, I was not sure if that is something which is not supported.

from jsonata.

In that case, use
Accounts.Order[OrderID in $$.Account.Shipping.OrderID]

See http://docs.jsonata.org/operators.html#in

from jsonata.

@andrew-coleman That worked!! Seems like I was missing the "in" eventually. Thanks for all your support. Happy 4th 👍

from jsonata.