Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

portal activity report query


We have a customized portal activity report in which there is a SQL Query "

select to_char((to_date('01-JAN-1970','DD-MON-YYYY')(a.TIMESTAMPHOUR/86400000)),'DY') as TIMESTAMPDAY, to_char((to_date('01-JAN-1970','DD-MON-YYYY')(a.TIMESTAMPHOUR/86400000)))||' (GMT)' as TIMESTAMPHOUR, decode(a.OBJECTTYPE,'i','iView','p','Page') as pageTYPE, a.CUSTOM as OBJECTName , a.VISITS as hits , a.IMPRESSIONS as IMPRESSIONS, b.LOGONID as ID, a.PCDURL as PCDURL from WCR_WEBCONTENTSTAT a ,WCR_USERPAGEUSAGE b where ( PCDURL = 'pcd:portal_content/com.freescale.SUPO_Roles/com.freescale.sup_rol_armanager/com.freescale.sup_wks_0005/com.freescale.sup_wks_0001/com.freescale.sup_pge_0003' or PCDURL = 'pcd:portal_content/com.freescale.SUPO_Roles/com.freescale.sup_rol_bidder/com.freescale.sup_wks_0006/com.freescale.sup_pge_0011') and a.ID = b.HOURLY_ID and AGGREGATIONLEVEL= 'h' and a.TIMESTAMPHOUR > (select ((to_date('01-JAN-2008','DD-MON-YYYY')-(to_date('01-JAN-1970','DD-MON-YYYY'))))*86400000 from DUAL) "

I need to modify this quey for taking a time duration of 3 months till date period .Is it possible / how to debug this query? Can anyone please help me in this

Former Member

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question