topic Re: DQL - filte by ZONE in DQL

DQL: filter by ZONE

yuval1983 — Thu, 28 Dec 2023 11:23:01 GMT

HI,

I created this filter, and I want to add another filter in addition that I can see by ZONE

I can Search but the list to long so i what to add another filer

can you help 🙂

Re: DQL - filte by ZONE

yuval1983 — Wed, 27 Dec 2023 09:29:14 GMT

I did it this way

But he doesn't cut and filter for the big list

Re: DQL - filte by ZONE

Pawel_Zalewski — Wed, 27 Dec 2023 09:55:24 GMT

Hi,

Do you need something like this?

Re: DQL - filte by ZONE

Pawel_Zalewski — Wed, 27 Dec 2023 10:00:43 GMT

Or like this

Re: DQL - filte by ZONE

yuval1983 — Wed, 27 Dec 2023 12:34:51 GMT

thanks 🙂

How can I fix this?

And How I add a Tags filter ?

In the category "Properties and tags"
I made an association based on Tags

Re: DQL - filte by ZONE

Pawel_Zalewski — Thu, 28 Dec 2023 08:51:27 GMT

Can you post whole query?

Re: DQL - filte by ZONE

Pawel_Zalewski — Thu, 28 Dec 2023 08:54:05 GMT

To filter a tag you just need something like this:

fetch dt.entity.service
| fields entity.name, managementZones, tags
| filter matchesValue(tags, "TAG you looking for")

Re: DQL - filte by ZONE

yuval1983 — Thu, 28 Dec 2023 09:23:25 GMT

HI,

/* * This function will run in the DYNATRACE JavaScript runtime. * For information, visit https://dt-url.net/functions-help */ import { metricsClient } from '@dynatrace-sdk/client-classic-environment-v2'; export default async function fetchMetricResults() { const serviceSelection = $Service; const metricKey = "builtin:service.errors.total.rate"; const config = { metricSelector: buildQuery(serviceSelection, metricKey), resolution: "Inf", from: $dt_timeframe_from, to: $dt_timeframe_to, acceptType: "application/json; charset=utf-8" }; if (config.metricSelector.length > 3500) { return "Please select fewer services"; } const metricQuery = await metricsClient.query(config); const processedResults: MetricResult[] = metricQuery.result[0].data.map(result => { return { "Service Name": result.dimensionMap["dt.entity.service.name"], "Service ID": result.dimensionMap["dt.entity.service"], "Failure Rate": +result.values }; }); return processedResults; } function buildQuery(inputs: string[], metricKey: string): string { const filters = inputs.map( input => `in("dt.entity.service", entitySelector("type(service), entityName.equals(~"${input}~")"))` ); const filterString = filters.join(","); return `${metricKey}:filter(or(${filterString})):splitBy("dt.entity.service"):sort(value(auto, descending)):names`; }

I have an example code that I want to add Zone filter capabilities to in the Failure Rate window. This means that in addition to the current filters for *prod OR *QA OR *Test, I would like to add another filter for location, such as *US OR *UK. The purpose of these filters is to be able to narrow down the results by location or name. Thank you your assistance.

Re: DQL - filte by ZONE

Pawel_Zalewski — Tue, 02 Jan 2024 08:15:28 GMT

Sorry but I can't find any solutions for this problem 😕

Re: DQL - filte by ZONE

yuval1983 — Sun, 07 Jan 2024 10:02:24 GMT

OK - maybe it sounds too complicated - i try explain

This is my screen

I want to add in the area of the filter
Column filter
Enables/disables field filters in table
Then the result will be in the window

- I want to add TAGS:PROD -

The code found in average is like this

import { metricsClient } from '@dynatrace-sdk/client-classic-environment-v2';

export default async function fetchMetricResults() {
  const serviceSelection = $Service;
  const metricKey = "builtin:service.errors.total.rate";

  const config = {
    metricSelector: buildQuery(serviceSelection, metricKey),
    resolution: "Inf",
    from: $dt_timeframe_from,
    to: $dt_timeframe_to,
    acceptType: "application/json; charset=utf-8"
  };

  if (config.metricSelector.length > 3500) {
    return "Please select fewer services";
  }

  const metricQuery = await metricsClient.query(config);

  const processedResults: MetricResult[] = metricQuery.result[0].data.map(result => {
    return {
      "Service Name": result.dimensionMap["dt.entity.service.name"],
      "Service ID": result.dimensionMap["dt.entity.service"],
      "Failure Rate": +result.values
    };
  });

  return processedResults;
}

function buildQuery(inputs: string[], metricKey: string): string {
  const filters = inputs.map(
    input => `in("dt.entity.service", entitySelector("type(service), entityName.equals(~"${input}~")"))`
  );
  const filterString = filters.join(",");

  return `${metricKey}:filter(or(${filterString})):splitBy("dt.entity.service"):sort(value(auto, descending)):names`;
}

The window shows me only the first filter - I want to add another filtering filter

@Pawel_Zalewski wrote:
Sorry but I can't find any solutions for this problem 😕