Comments (7)
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.
Related Issues (20)
- How to return the value from jsonata instead of promise/async HOT 3
- Dry run, return expected schema for a given input schema
- How to handle undefined value HOT 2
- $formatDateTime(millis, picture [, timezone]) and $parseDateTime(timestamp, picture) HOT 1
- Clarification : Is there Any Feature for Apply Break or Continue in Looping HOT 1
- parallel map
- switch case or if else
- Truthiness of numbers is completely random
- Help resolve current pinning to 1.8.6 for JSONata-Wrapper (possibly ducktape compatibility)
- Reserved Tokens Documentation
- ($.some_non_existent_key != 'anything') evaluates to false HOT 3
- $string(number) capped at precision-15
- Error handling and asynchronous behavior in evaluate function
- Rounding number without "Round half to even"
- There isn't a uuid() function for JSONata HOT 2
- Hard spaces in documentation not rendered correctly
- Security contact for JSONata HOT 4
- default query on try.jsonata.org HOT 1
- is 2.0.4 a fake release? HOT 4
- Multi-level JSON processing: Unwrapping Objects
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from jsonata.