Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

The 4th edition of the Campaign Community Lens newsletter is out now!
SOLVED

Adobe campaign postgreSQL error while using aggregate function

Avatar

Community Advisor

Campaign error.JPG

I am getting a postgreSQL error while updating the schema which contains aggregate function sum.

1 Accepted Solution

Avatar

Correct answer by
Employee

Hi Amit,

  You need to Group by the targeting dimension. The primary key of the targeting dimension is always included in the results and that is what this error message is referring to. Edit the additional data and click on the Advanced settings link to do get to this setting.

View solution in original post

3 Replies

Avatar

Correct answer by
Employee

Hi Amit,

  You need to Group by the targeting dimension. The primary key of the targeting dimension is always included in the results and that is what this error message is referring to. Edit the additional data and click on the Advanced settings link to do get to this setting.

Avatar

Community Advisor

Hi Linda,

I am using a preloading in web form.so in there i don't see any

checkbox to Group by the targeting dimension.

How can i use query in a webform to display the count of all participants or some of a recipient field?

Regards,

Amit

Avatar

Employee

The Data Management options are much more limited in a web application workflow than in a Campaign workflow. Can you provide screen shots of what you have implemented?

The ultimate experience is back.

Join us in Vegas to build skills, learn from the world's top brands, and be inspired.

Register Now