Absent Member.. mcwang Absent Member..
Absent Member..
469 views

Adding multiselect to existing actual timesheet summary reports

Jump to solution

Hello,

 

I am trying to add multi-select to the Actual timesheet summary report.  I enabled the multi-select at the validation level but the report returned no data. 


The jdbc logs show that the  values need to be in separate quotes, but they are not. 

                AND ttslv.WORK_ITEM_TYPE_CODE = 'MISC' AND ttslv.WORK_ITEM_SET_ID IN ('1') AND ttslv.WORK_ITEM_ID IN ('1,4') AND ttsv.RES
OURCE_USER_ID IN (32548)

 

I am trying to change the code but keep running into compiling issues preventing the report to be run..

 

I tried to change in the ActualTimeSummaryReport.jsp the code from

 

<c:if test="${not empty WORK_ITEM_ID}">
  <c:set var="paramsFrag" value="${paramsFrag} AND ttslv.WORK_ITEM_ID IN ('${WORK_ITEM_ID}')" />
  <c:set var="paramsMiddleSQLFrag" value="${paramsMiddleSQLFrag} AND ttslv_s.WORK_ITEM_ID IN ('${WORK_ITEM_ID}')" />

 

to

 

<c:set var="paramsFrag" value="${paramsFrag} AND ttslv.WORK_ITEM_ID IN ('<rpt:replaceAll value="${WORK_ITEM_ID}" from="," to="','" />')"/>

 

OR

 

  <c:forEach items="${WORK_ITEM_ID}" var = "a" varStatus="busa">
 <c:choose>
  <c:when test="[$busa.first == true]">
   <c:set var="paramsFrag" value="${paramsFrag} AND ttslv.WORK_ITEM_ID IN ("'${busa.current}'")"/>
  </c:when>
  <c:otherwise>
   <c:set var="paramsFrag" value="${paramsFrag} AND ttslv.WORK_ITEM_ID IN ("'${busaAreaResult},'${busa.current}'")"/>
  </c:otherwise>
 </c:choose>
  </c:forEach>
  <c:set var="paramsFrag" value="${paramsFrag} AND ttslv_s.WORK_ITEM_ID IN ('${busAreaResult}')"/>
</c:if>

 

In both cases, I  receive error

Unterminated <c:set tag

 

Any help is appreciated.

0 Likes
1 Solution

Accepted Solutions
Established Member.. Utkarsh_Mishra
Established Member..

Re: Adding multiselect to existing actual timesheet summary reports

Jump to solution

Simply replace your line wiht the below one.

 

<c:set var="paramsFrag" value="${paramsFrag} AND ttslv.WORK_ITEM_ID IN (${WORK_ITEM_ID})" />

 

i.e. remove the '

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)

View solution in original post

2 Replies
Established Member.. Utkarsh_Mishra
Established Member..

Re: Adding multiselect to existing actual timesheet summary reports

Jump to solution

Simply replace your line wiht the below one.

 

<c:set var="paramsFrag" value="${paramsFrag} AND ttslv.WORK_ITEM_ID IN (${WORK_ITEM_ID})" />

 

i.e. remove the '

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)

View solution in original post

Absent Member.. mcwang Absent Member..
Absent Member..

Re: Adding multiselect to existing actual timesheet summary reports

Jump to solution

Thanks Utkarsh.. The report finally ran with multi-select.  Although the performance was on the slower side... I think my users will be happy.

 

Thanks,

Michael

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.