-- Oracle 11+
with s (Logdate,Status) as (
select 20190101, 'ok' from dual union all
select 20190101, 'notok' from dual union all
select 20190101, 'ok' from dual union all
select 20190102, 'ok' from dual union all
select 20190102, 'notok' from dual)
select *
from s
pivot (count(*) for status in ('ok' as ok, 'notok' as notok))
order by Logdate;
LOGDATE OK NOTOK
---------- ---------- ----------
20190101 2 1
20190102 1 1
Это работает отлично..
<%
request.setAttribute("lcItem", LeftContentItem);
%>
<s:property value="#request['lcItem']" />
Примечание: Согласно Объему, который мы используем, мы должны указать #request.. и т.д.