Get root data via `$` or parent data via `..`

[tiam-bloom]

{
 "dep": 2,
 "gov": [
 {"name": "Chris", "age": 23, "city": "New York"},
 {"name": "Emily", "age": 19, "city": "Atlanta"},
 {"name": "Joe", "age": 32, "city": "New York"},
 {"name": "Kevin", "age": 19, "city": "Atlanta"},
 {"name": "Michelle", "age": 27, "city": "Los Angeles"},
 {"name": "Robert", "age": 45, "city": "Manhattan"},
 {"name": "Sarah", "age": 31, "city": "New York"}
 ]
}

如何通过JSON query转为

[
 {"name": "Chris", "age": 23, "city": "New York","dep": 2},
 {"name": "Emily", "age": 19, "city": "Atlanta","dep": 2},
 ......
 ]

形式

[josdejong]

Can you please use English? Do you mean to ask how to convert the first JSON example to the second one? You can retrieve the gov property using the following JSON Query:

.gov

[JamLin29]

I've been looking for a way to transform a structure like { dep: 2, gov: [...] } into a flat array where each item in gov contains the dep value. But this library prioritizes a small footprint over complex data manipulation. Without the .. operator (a method to get root), accessing properties across different scopes is a major pain point.

values() // step 1
 | flatten() // step 2
 | map({name: .name, age: .age, city: .city, dep: $.0}) // step 3
 | reverse() // step 4
 | limit(size() - 1) // step 5

Steps 3 and 5 are currently not achievable.

[josdejong]

Thanks for your feedback. Support for a way to get parent data (like with ..) or the root data (for example via $) would be very useful indeed. We already gave that some thought here #13 (comment) but we haven't yet implemented a solution.

I'll update the title of this issue to reflect this idea. Help implementing a solution would be welcome.

[josdejong]

As for support for something like limit(size() - 1) (step 5), we could either change something so that size() still can get the size of the array at hand, or implement support for a negative index so you can use limit(-1).