topic Re: Looping through For loop items in DQL Query in Workflow in Automations

Looping through For loop items in DQL Query in Workflow

abhijitmorye — Fri, 17 Jan 2025 07:39:44 GMT

Hello Team,

I am trying to create a workflow where I am executing the Davis Analyzer Task using DQL query, In the previous task, I am using the DQL Task which will return the list of records, now in Davis Analyzer Task, I am using For loop option which will iterate over the list of records and execute the task accordingly, I am trying to use the for loop variable in my Davis Analyzer Query, However I am getting an saying "Field {{._item }} does not exit". Please find the below snapshots for the task that I am trying to create.

Workflow -

Execute DQL Query Result -

Davis Analyzer Task Query -

Thanks,

Abhijit Morye

Re: Looping through For loop items in DQL Query in Workflow

christian_kreuz — Fri, 17 Jan 2025 07:02:37 GMT

Hi,

on a first glance this looks alright. Can you please add a screenshot of the "Options" tab of the analyze_with_davis_1 task? I suspect that something might need to be changed on that tab.

See https://docs.dynatrace.com/docs/analyze-explore-automate/workflows/building#task-options for details about loops.

Re: Looping through For loop items in DQL Query in Workflow

abhijitmorye — Fri, 17 Jan 2025 07:09:35 GMT

Hi Christian,

Thanks for the reply.

Please find the below snapshot for the Option in Davis Analyzer Task.

Thanks,

Abhijit M.

Re: Looping through For loop items in DQL Query in Workflow

christian_kreuz — Fri, 17 Jan 2025 07:14:20 GMT

Hi Abhijit, and for the Options Tab itself? Does it look like this? Specifically the Item variable name needs to be item, if you want to reference it with {{ _.item }}

Re: Looping through For loop items in DQL Query in Workflow

abhijitmorye — Fri, 17 Jan 2025 07:25:05 GMT

Yes, I have kept variable name as item and using this variable as {{ _.item }} in DQL query as suggested.

Re: Looping through For loop items in DQL Query in Workflow

abhijitmorye — Fri, 17 Jan 2025 07:44:28 GMT

Hi Christian,

I got the answer for this, correct way to use jinja variable in DQL is "{{ _.item }}". Thanks for your prompt response.