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
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Adobe campaign postgreSQL error while using aggregate function

Amit_Kumar
Community Advisor
Community Advisor

Campaign error.JPG

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

1 Accepted Solution
Linda_Stinson
Correct answer by
Employee
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
Linda_Stinson
Correct answer by
Employee
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

Amit_Kumar
Community Advisor
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

Linda_Stinson
Employee
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?