select count(*) from sf_project_task as task where delete_flag='N' and status in('TS001','TS003') 
    and task.task_owner=35 and task.det_feature_id in 
    (select det_feature_id from sf_detailed_feature as swReq where swReq.delete_flag='N' and swReq.req_type='FEATURE' and swReq.feature_id in
    (select feature_id from sf_feature where delete_flag='N' and project_id=3))
    

select count(*) from sf_project_task as task where delete_flag='N' and status in('TS001','TS003') 
    and task.task_owner=35 and task.det_feature_id in 
    (select det_feature_id from sf_detailed_feature as swReq where swReq.delete_flag='N' and swReq.req_type='CR' and swReq.feature_id in
    (select feature_id from sf_feature where delete_flag='N' and project_id=3))
    
    
    
    
cntList = getHibernateTemplate().find(" select count(*) from Task as task where task.deleteFlag='"+ VSFConstantMaster.FLAG_NO+"' and task.status in('" +
SFConstantMaster.TASK_PROGRESS_STATUS+",'"+SFConstantMaster.TASK_ACCEPTED_STATUS+"')" +
" and task.taskOwnerID=? and task.detailedFeatureID in " +
  " (select distinct swReq.swDetReqID from SWRequirementsVO as swReq where swReq.swReqDelflag='"+ VSFConstantMaster.FLAG_NO+"' and swReq.swReqType='FEATURE' and swReq.swFeatureID in "+
  " (select distinct feature.reqID from Feature as feature where feature.reqDeleteFlag='"+ VSFConstantMaster.FLAG_NO+"' and feature.projectID=?))",memberId,projectId);
    

cntList = getHibernateTemplate().find(" select count(*) from Task as task where task.deleteFlag='"+ VSFConstantMaster.FLAG_NO+"' and task.status in('" +
SFConstantMaster.TASK_PROGRESS_STATUS+",'"+SFConstantMaster.TASK_ACCEPTED_STATUS+"')" +
" and task.taskOwnerID=? and task.detailedFeatureID in " +
  " (select distinct swReq.swDetReqID from SWRequirementsVO as swReq where swReq.swReqDelflag='"+ VSFConstantMaster.FLAG_NO+"' and swReq.swReqType='"+VSFConstantMaster.REQ_CR+"' and swReq.swFeatureID in "+
  " (select distinct feature.reqID from Feature as feature where feature.reqDeleteFlag='"+ VSFConstantMaster.FLAG_NO+"' and feature.projectID=?))",memberId,projectId);



" from Task as task where task.deleteFlag='"+N+"' and task.status in('TS003','TS001') and task.taskOwnerID=1022 and
task.itearationID in (select distinct iteration.iterationId from IterationVO as iteration where
iteration.releaseId in (select distinct release.releaseId from Release as release where release.deleteFlag=
'N' and release.projectId=153 ) and iteration.deleteFlag='N' and iteration.status !='IS001')