Expand my Community achievements bar.

Generic query editor templates

Avatar

Level 7

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.

2 Replies

Avatar

Employee Advisor

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

Avatar

Level 6

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.

 

somasundaram_h_0-1730973662344.png

 

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