Parameterized NQE query from the API

Hi Christopher,

How would I be able to set the parameters up so that it returns all results starting with “us”, rather than providing the full name of the region.

I have tried using “*” at the end of the string, e.g. “us*” but this doesn’t seem to work.

Is there another way to do this?

Kind regards,

Sebastian

@Sebastian Coros you could change the query to this

 

@query
natGatewaysByRegion(awsRegion : List<String>) =
 foreach cloudAccount in network.cloudAccounts
 where cloudAccount.cloudType == CloudType.AWS
 foreach vpc in cloudAccount.vpcs
 foreach natGateway in vpc.natGateways
 foreach region in awsRegion
 where matches(natGateway.region, region)
 select { vpcId: vpc.id, natGatewayId: natGateway.id, region: natGateway.region };

then you can use glob characters like us*

@GaryB ‘s query might produce duplicate rows if a gateway’s region matches multiple region globs. To avoid those duplicates, you could write the query like this:

@query
natGatewaysByRegion(awsRegionGlobs : List<String>) =
 foreach cloudAccount in network.cloudAccounts
 where cloudAccount.cloudType == CloudType.AWS
 foreach vpc in cloudAccount.vpcs
 foreach natGateway in vpc.natGateways
 where max(foreach glob in awsRegionGlobs 
           select matches(natGateway.region, glob))
 select { 
    vpcId: vpc.id, 
    natGatewayId: natGateway.id, 
    region: natGateway.region 
};

In this query, instead of emitting a row for every glob that matches, it emits a single row for a gateway only when it matches at least one of the provided globs.