https://community.dynatrace.com/t5/DQL/Implementing-Custom-Functions-to-use-in-DQL/m-p/277820#M2127 <P>I am current replicating a function in Splunk to use in my Dynatrace queries.<BR /><BR />I have replicated the functionality but through the method below:<BR />1. Create a code block segment&nbsp;<BR />2. call the DQL query inside code block using&nbsp;import { queryExecutionClient } from '@dynatrace-sdk/client-query<BR />3. Get the query results modify it using custom JavaScript function<BR />4.&nbsp; Get the results of the segment in raw json format<BR />5. Get the raw JSON result&nbsp; and place it in DQL&nbsp; data json""" &lt;json data&gt;" in DQL, to then chain the subsequent DQL after modifying it&gt;<BR /><BR />Does anyone know a better solution to this approach, which reduces overhead work and have it done in one segment block?</P> Fri, 23 May 2025 07:25:19 GMT shapu 2025-05-23T07:25:19Z https://community.dynatrace.com/t5/DQL/Implementing-Custom-Functions-to-use-in-DQL/m-p/277820#M2127 <P>I am current replicating a function in Splunk to use in my Dynatrace queries.<BR /><BR />I have replicated the functionality but through the method below:<BR />1. Create a code block segment&nbsp;<BR />2. call the DQL query inside code block using&nbsp;import { queryExecutionClient } from '@dynatrace-sdk/client-query<BR />3. Get the query results modify it using custom JavaScript function<BR />4.&nbsp; Get the results of the segment in raw json format<BR />5. Get the raw JSON result&nbsp; and place it in DQL&nbsp; data json""" &lt;json data&gt;" in DQL, to then chain the subsequent DQL after modifying it&gt;<BR /><BR />Does anyone know a better solution to this approach, which reduces overhead work and have it done in one segment block?</P> Fri, 23 May 2025 07:25:19 GMT https://community.dynatrace.com/t5/DQL/Implementing-Custom-Functions-to-use-in-DQL/m-p/277820#M2127 shapu 2025-05-23T07:25:19Z https://community.dynatrace.com/t5/DQL/Implementing-Custom-Functions-to-use-in-DQL/m-p/277837#M2128 <P>There are a couple of product ideas already out there and Under Review for creating DQL macros to save and use in later queries:&nbsp;&nbsp;<A href="https://community.dynatrace.com/t5/Product-ideas/Introduction-of-a-Macro-Feature-in-Dynatrace-DQL/idi-p/256518" target="_blank">Introduction of a Macro Feature in Dynatrace DQL - Dynatrace Community</A></P> Thu, 22 May 2025 14:23:48 GMT https://community.dynatrace.com/t5/DQL/Implementing-Custom-Functions-to-use-in-DQL/m-p/277837#M2128 StrangerThing 2025-05-22T14:23:48Z