JIRA is not yet the source of record for RFEs. Not all SourceForge resources have made it to the Apache infrastructure yet. Similarly, CVS is not yet in SVN. These things take time.
That said, <dynamic> is already a reserved element, and hence this RFE will not pass as described. Perhaps something like <fragmet> or even simply <sql> might be more appropriate. Cheers, Clinton On Fri, 10 Dec 2004 08:52:45 -0500, Jerome Jacobsen <[EMAIL PROTECTED]> wrote: > I submitted a RFE to Sourceforge Tracker back in September that > would allow for something similar to what you want. The RFE > ID is 1034260 (Named dynamic for reuse). > > I checked a couple of weeks ago to see if it made it into Jira > but it didn't. I asked the maillist on Nov 30 why it didn't > make it but got no response. > > Anyway, with this RFE your statements would look something > like this: > > <dynamic id="myBigDynamic"> > > > FROM > ( > SELECT > rownum as rownumber, > e.emp_employee_id as employeeId, > e.emp_name as employeeName, > e.emp_manager as managerId, > e.manager_name as managerName, > e.muid as managementUnitId, > e.name as managementUnitName, > cS.course_Id as courseId, > cS.course_title as courseTitle, > cS.start_datetime as courseDate, > > cS.module_status_id > FROM > (select > e.emp_employee_id, > e.emp_name, > em.emp_employee_id as emp_manager, > em.emp_name as manager_name, > mu.muid, > mu.name > ..... (lots more) > </dynamic> > > <statement id="getEmployeeAndLastCourseCount"> > parameterClass="EmployeeAndLastCourseParam" > resultClass="java.lang.Long"> > Select count(*) as count > <dynamic refId="myBigDynamic"/> > </statement> > > <statement id="getEmployeeAndLastCourse" > parameterClass="EmployeeAndLastCourseParam" > resultClass="TrainingRequestListModel"> > Select > > > rownumber, > employeeId, > employeeName, > managerId, > managerName, > managementUnitId, > managementUnitName, > courseId, > courseTitle, > courseDate > <dynamic refId="myBigDynamic"/> > </statement> > > So it is 2 small statements and one large reusable dynamic. > > -Jerome > >
