Adobe campaign postgreSQL error while using aggregate function

[Amit_Kumar]

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

[Linda_Stinson · Accepted solution]

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.

[Amit_Kumar]

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]

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?