Generic query editor templates | Community
Skip to main content
Heku_
Level 5
October 23, 2024
Question

Generic query editor templates

  • October 23, 2024
  • 2 replies
  • 627 views

Hello, I use the generic query editor to view and aggregate data and sometimes i have to use the same query in different days. I would like to save the query as a template to use it another time by importing the template.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

Craig_Thonis
Adobe Employee
Adobe Employee
October 23, 2024

Hi Heku. My first thought would have been to save the queries as a filter. However, within the generic editor, you don't have the option to choose a system filter, so I don't see any way to save or template a generic query.

 

I would recommend reaching out to Campaign Support to create an enhancement.

 

Regards,

Craig

somasundaram_h
Community Advisor
Community Advisor
November 7, 2024

Hi,

I suggest you to use a custom web app and use a query activity and print your aggregate result using js activity using document.write(ctx.query1.broadLogRcp.@count). Here @count is a aggregate value field used in the query activity and query is added on broadlogrcp table.

 

 

Note: you should use newWebApp template while creating webapp where the query activity is available.