Resource `newrelic_nrql_alert_condition`: Terraform list in NRQL queries

[RogerWilco80]

Can we have the ability to supply a terraform list in NRQL queries? That way we can use a splat expression to specify several IDs in queries.

Depending on the resource (e.g. alert conditions), the alternative could be to create several queries.

For example:

resource "newrelic_synthetics_monitor" "monitor-cust-website" {
  count = length(var.monitor_websites)
  status           = "ENABLED"
  name            = var.monitor_websites[count.index].name
  period           = "EVERY_MINUTE"
  uri                 = var.monitor_websites[count.index].uri
  type              = "SIMPLE"
  locations_public = var.monitor_websites[count.index].location
}

resource "newrelic_nrql_alert_condition" "ping-alert-condition" {
....
  nrql {
      query = "SELECT filter(count(*), WHERE result = 'FAILED') AS 'Failures' FROM SyntheticCheck WHERE entityGuid IN (${newrelic_synthetics_monitor.monitor-customer-website[*].id}) AND NOT isMuted FACET monitorName"
    }
....
}

This gives an error saying I'm providing a tuple where a string is required.

[shakefu]

https://developer.hashicorp.com/terraform/language/functions/join

[rpaliwal1997]

Corrected the NRQL query to dynamically generate the list of entityGuids based on the newrelic_synthetics_monitor.monitor-cust-website resources. This ensures that the query accurately reflects the current state of the monitored synthetic checks.

Query:-

nrql { query = <<-EOT SELECT count(*) FROM SyntheticCheck WHERE entityGuid IN (${length(newrelic_synthetics_monitor.monitor-cust-website) > 0 ? join(", ", [for id in newrelic_synthetics_monitor.monitor-cust-website[*].id : format("'%s'", id)]) : "''"}) EOT }

Query Result(Sample):-

SELECT count(*) FROM SyntheticCheck WHERE entityGuid IN ('MzgwNjUyNnxTWU5USHxNT05JVE9SfGMyOGVhNzk4LWNlZjAtNGIwOC1iNDRiLTZhOGMxOGNlZWY1Nw', 'MzgwNjUyNnxTWU5USHxNT05JVE9SfGU3NDZkZWIwLTliNmEtNGU4ZC1iMGVlLWNjYTE0YzQzYjg5Nw', 'MzgwNjUyNnxTWU5USHxNT05JVE9SfDEwOWJjZDM4LWNlNjMtNDk2Yi05MzY2LWY0NTMxZjZhMTEwNA')