Adobe campaign postgreSQL error while using aggregate function

Avatar

Avatar

Amit_Kumar

MVP

Avatar

Amit_Kumar

MVP

Amit_Kumar
MVP

15-12-2015

Campaign error.JPG

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Linda_Stinson

Employee

Avatar

Linda_Stinson

Employee

Linda_Stinson
Employee

18-12-2015

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.

Answers (2)

Answers (2)

Avatar

Avatar

Linda_Stinson

Employee

Avatar

Linda_Stinson

Employee

Linda_Stinson
Employee

21-12-2015

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?

Avatar

Avatar

Amit_Kumar

MVP

Avatar

Amit_Kumar

MVP

Amit_Kumar
MVP

20-12-2015

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