topic Create a View with Aggregation Function (COUNT) in Application Development and Automation Discussions

Create a View with Aggregation Function (COUNT)

Former Member — Wed, 06 Dec 2006 16:24:55 GMT

I've been looking up and down for a way to create a view with a few basic fields and some other fields containing aggregation function.

For instance:

To display a view that contain all the Contract Agreement and the corresponding count of the PO releases.

Agreement Nbr, Total PO releases

I need this view so that I can create a search help with this view.

I found something about the "CREATE VIEW" statement, but I don't have any idea how to use it.

Any helps toward this matter is very much appreciated, thanks.

Re: Create a View with Aggregation Function (COUNT)

uwe_schieferstein — Sun, 21 Jan 2007 20:44:15 GMT

Hello Aldern

I guess you have read about the SQL statement "CREATE VIEW". When we create a view in the dictionary this SQL statement is finally called to create the view on the DB. Thus, since we do not have any aggregation options in views you cannot achieve what you want using views.

The solution for your problem is to create a <b>search help</b> having a <b>search help exit</b>. Within the exit you can do your aggregation functions and add these values to the displayed search help data.

Regards

Uwe