I didn't look over it thoroughly but i noticed you appear to have a
misplaced "COUNT":
SELECT CG , COUNT(CD) *COUNT*,
SUM (
TO_DATE(EDATE||' '|| etime ,'DD-MM-YYYY HH24:MI:SS' ) -
TO_DATE(ADATE||' '|| atime ,'DD-MM-YYYY HH24:MI:SS' )
) total_time
Perhaps you should check you SQL.
Brandon
On Fri, Jun 12, 2009 at 12:44 AM, Jahan Zaib <[email protected]>wrote:
> i am trying to run this but problem occursi have a class
>
> ----
> public class CompleteCallsReportBean implements Serializable{
> /**
> *
> */
> private static final long serialVersionUID = 2192836100387342196L;
> /**
> *
> */
>
> private String cg;
> private String COUNT;
> private String totalTime;
> public void setCG(String cg) {
> this.cg = cg == null ? null : cg.trim();
> }
> public void setCOUNT(String COUNT) {
> this.COUNT = COUNT == null ? null : COUNT.trim();
> }
> public void setTotalTime(String totalTime) {
> this.totalTime = totalTime == null ? null : totalTime.trim();
> }
> public String getCG() {
> return cg;
> }
> public String getCOUNT() {
> return COUNT ;
> }
> public String getTotalTime() {
> return totalTime;
> }
>
> }
>
>
> --------
>
> And Sql Map related to that is
> :
>
> <resultMap id="CompleteCallsReportMap"
> class="com.prevail.bean.CompleteCallsReportBean" >
> <result column="total_time" property="totalTime" jdbcType="VARCHAR" />
> <result column="COUNT" property="COUNT" jdbcType="VARCHAR" />
> <result column="CG" property="cg" jdbcType="VARCHAR" />
> </resultMap>
>
> <select id="get_complete_call_summary_by_date" parameterClass="String"
> resultMap="CompleteCallsReportMap" >
> SELECT CG , COUNT(CD) COUNT,
> SUM (
> TO_DATE(EDATE||' '|| etime ,'DD-MM-YYYY HH24:MI:SS' ) -
> TO_DATE(ADATE||' '|| atime ,'DD-MM-YYYY HH24:MI:SS' )
> ) total_time
> FROM COMPLETE_CALLS
> WHERE EDATE = #date:VARCHAR# HAVING
> (
> TRUNC (SUM (
> TO_DATE(EDATE||' '|| etime
> ,'DD-MM-YYYY HH24:MI:SS' ) - TO_DATE(ADATE||' '|| atime ,'DD-MM-YYYY
> HH24:MI:SS' )
> ) *24
> )
> BETWEEN 0 AND 9
> )
> GROUP BY
> CG order by total_time desc
> </select>
> ---------------------------
> But it did not fetch any data, where as simply query run fine
> What i do ?
> Kindly Help
> --
> Regards,
> Jahan Zaib
>
>
