How to get selected range time from panel using Wild Graphql Data Source

Grafana Dashboards
1

Hi,
I installed Grafana 11.0.0 and I’m using Wild Graphql Data Source to create a dashboard for my website analysis. I create a graphql query like this to get total visits for the selected range time:
query {
viewer {
accounts(filter: { accountTag: “account_tag” }) {
total: rumPageloadEventsAdaptiveGroups(
filter: {
AND: [
{
datetime_geq: “${__from:date:iso}”,
datetime_leq: “${__to:date:iso}”

        },
        {
          OR: [
            {
              siteTag: "$SiteTag"
            }
            
          ]
        },
        {
          bot: 0
        }
        
      ]
    },
    limit: 1
  ) {
    sum {
      visits
    }
  }
}

}
}

But I get this error: {
“error parsing args for "rumPageloadEventsAdaptiveGroups": filter: AND: datetime_geq: not an iso8601 time”.
When I enter the start and end date manually, the query worked perfecly. But it didn’t work when using functions like: ${__from:date:iso} or ${__from:date}.

Could you please help me to resolve this issue.

2

what does you source date format look like?

If it does not match, the date or the iso: date format exactly, it won’t work, but luckily there are other formats and options:

image
image1010×428 36.4 KB

To match your date format you can try the last option, and specify a format that matches your data’s date using the formatting options from:

https://momentjs.com/docs/#/displaying/

3

Thank you @sowdenraymond for your reply. the source date is the date selected from panel.

image

4

I wanted to chime in, as I’m the creator of Wild GraphQL datasource and am just now seeing this. (Feel free to @mention me if you need help in the future)

Unlike most other Grafana plugins, Wild GraphQL Datasource does not allow you to use Grafana’s variable interpolation in the query itself. Most of the time, you don’t need to use anything like ${__from} or ${__to}, but instead you can use the $from and $to variable provided to each query.

I won’t go into detail on that, as it looks like you instead want to use the ISO date format ${__from:date:iso} and ${__to:date:iso}. You cannot use these values directly inside the query. Instead, you can do something like this:

query:

query ($fromIso: String!, $toIso: String!) {
  # Now you can reference $fromIso and $toIso within your query
  # ...
}

variables:

{
  "fromIso": "${__from:date:iso}",
  "toIso": "${__to:date:iso}"
}

The idea here is that interpolation is only allowed to happen in the variables section of the GraphQL query. This allows the GraphiQL editor or an external GraphQL query validator to validate each GraphQL query without worrying about how each interpolation could affect or break the GraphQL query.

I’m guessing I’m a little late to replying and this isn’t useful anymore, but hopefully it will help someone in the future.

5

Probably best to post these questions for this plugin on the GitHub for that plugin as it is not a grafana issue?