Is it possible to extract a value from a subList?

A colleague provided a workable solution below; however, the subList also has a Bool field that I’d I didn’t include in my original example and I’d like to create a select violation.

subListName: (foreach p in i.subList select p.name)

That was correct.

  This

  subListName: (foreach p in i.subList select p.name)

  Instead of this

  subListName: i.subList.name

you need to “unpack” that list. if you could just put “name” by itself, then it would be okay. But since name is subelement “i.subList.name” then query will not unpack it for you.  I can’t think of good description for why this happens.  If you see that “ Can't access field 'name' from 'i.subList', because that is a List” it is NQE saying that you need to unpack that list yourself.

As for the violation.  Are you referring to this line?

  where ep.name == "endpointname" && ep.statusCode == 200

if that is what you want to make a violation, then use a “let” statement.

  let violation = "endpointname" && ep.statusCode == 200

if you make that a violation behind that “let” instead of a filter behind the “where” then you will see entries where this Bool is False and True not just True.

  let recordid = extractJson[{
        kind: String, selfLink: String, items:
            List<{
                subList:List
                    List<{
                        kind: String, selfLink: String, name: String, staged: Bool
                }>
            }>
    }]

My original example should have contained the subList field named called “staged” as type Bool. I would like to create a violation for any records where staged is true. 

If I read it correctly, I think in @Tyson Henrie ‘s comment, the violation field will be a list of booleans. To have it be correctly interpreted as a violation field, it needs to be a boolean. You can do that by taking the min of the list of booleans. That works because min will be false if any of the items in the list are false. So it could be something like this:

select {

      violation: min(foreach x in i.subList select x.staged),

}

select {

      violation: min(foreach x in i.subList select x.staged),

}

Perfect; thank you.