How can I filter javascript objects with an expression that has array in it with jmesPath?

Question

I have an array of users and each user has couple of roles. The example of the array is shown below.

[
    {
        id: 1,
        username: 'john',
        roles: [
            {id: 500, name: 'Admin'},
            {id: 501, name: 'Owner'}
        ]
    },
    {
        id: 2,
        username: 'joe',
        roles: [
            {id: 500, name: 'Admin'},
        ]
    },
    {
        id: 3,
        username: 'june',
        roles: [
            {id: 502, name: 'User'},
        ]
    }
]

I'm trying to get all the users who have an Admin role by using jmesPath. I've tried [?roles[].name=='Admin'] but this is giving a null value. Is is possible to do this with jmesPath, and if yes can you give me an expression for this example?

diedu · Accepted Answer · 2017-08-16 00:05:32Z

4

I played a little with this example and your data

http://jmespath.org/examples.html#filtering-and-selecting-nested-data

I made it work with this expression

[?roles[?name=='Admin']]

answered Aug 16, 2017 at 0:05

diedu

20.9k4 gold badges39 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sahand Javid Over a year ago

This actually works, but I can't understand your query. Can you please explain it here?

José Quinto Zamora · Accepted Answer · 2017-08-15 23:48:21Z

-1

You can get the same result with plain JavaScript using:

Assuming your array is stored on var users = [...].

users.filter((i)=> i.roles.some((s) => s.name === "Admin"))

You can see this sample with jsBin

answered Aug 15, 2017 at 23:48

José Quinto Zamora

2,13815 silver badges15 bronze badges

Collectives™ on Stack Overflow

How can I filter javascript objects with an expression that has array in it with jmesPath?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related