Querries in AwareIM

daleb · Post by **daleb** » Tue Sep 30, 2008 6:47 am

Hi

I am trying to create a query in Aware:

I have a table of dealers who have a total numeric amount in one column and i need to show the total for the total amount column per dealer

For example each dealer is shown multiple times and i'd like it to show each dealer once with the total amount for a specific amount of time

Please Help me with the sequal

tford · Post by **tford** » Tue Sep 30, 2008 12:54 pm

daleb,

You can't do this in a query on your Dealers BO. You could do this in a Customer Presentation of that BO by showing a totals band only & not showing the detail band.

If you want to do it in a query, you will have to have another BO, say DealerTotals that you build via rules / process.

Tom

christopherb · Post by **christopherb** » Tue Sep 30, 2008 5:55 pm

daleb,
Take a peek at the Order management application in the sample folder from Aware, this comes with your installation. This should help you understand using the objects as Tom mentioned to achieve your goal.

Good Luck...