the standard way is to martial the data in groovy script that are
called out(the new way) in a screen definition. you can find many
examples of this in the code.
The martialed data is then defined and passed to the screen where you
define screenlets to define layout.
I don't use SQL directly but define a entityview.
Note: I sent this to the user ML so others that may approach this
differently can respond.
however if you want personalized help, I will be glad to consult for a
fee with you.
giridhar mungi sent the following on 10/7/2012 10:03 PM:
> Hi Freeman,
>
> Good day to you.
>
> my name is giridhar.Thanks for accepting for my connection request in
> linkedin. i have seen ur mail id in linkedin.
>
> I have doubt in Sql.please help me if you know.
>
> *TableName:stores*
>
> *storeid date price paymenttype*
> 101 Oct-01 26 Creditcard
> 101 Oct-01 25 Creditcard
> 101 Oct-01 25 Cash
> 101 Oct-01 24 Cash
> 101 Oct-01 33 Cash
> 101 Oct-01 35 Cash.
>
> This is the sample data.I want to display the total creditcard amount and
> total cash amount individually per date and storeid.
>
> if we want to display the creditcard,we can give like *select
> storeid,date,sum(price) as creditcardtotal from stores where
> paymenttype='creditcard'* *group by storeid,date*;
>
> if we want to display the cash total,we can give like *select
> storeid,date,sum(price) as cashtotal from stores where
> paymenttype='cash'* *group
> by storeid,date*;
>
> *How to display the total amounts of credit card and cash per storeid and
> date in a single query like,
>
> storeid date totalcreditcardamount totalcashamount
>
>
> *please help me sir.*
> *
>
> Thanks& Regards,,
> giridhar.
>