Skip to Content
Former Member
Oct 14, 2009 at 11:19 AM

Portal Activity Report WCR_WEBCONTENTSTAT for PCDURL field no data fetched


Hi ,

I am creating custom portal activity report in WD java.

When I am firing a direct query on WCR_WEBCONTENTSTAT table: select * from WCR_WEBCONTENTSTAT

Its giving output with all fields

Now when I firing the same query with Where and LIKE clause for PCDURL field its not givng any results

select * from WCR_WEBCONTENTSTAT where PCDURL LIKE '%pcd:portal_content/Poonam/iview/address%'

Even I had copied the output of PCDURL field from the direct query : select * from WCR_WEBCONTENTSTAT.

and cheecked with another query :select * from WCR_WEBCONTENTSTATwhere PCDURL='pcd:portal_content/Poonam/iview/address'.

But its too not giving data

Similar thing is happening with field CUSTOM also


For rest of the fields the 'Where with LIKE clause 'is working fine.

What I have noticed is the SQL datatype of PCDURL & CUSTOM is NVARCHAR 1024.

But I think NVARCHAR(SQL type) is equvalent to String (java type) , so when I am passing a string to PCDURL field , it should fetch the data.

Please let me know If anyone faced the similar issue and resolved it.


Poonam Sharma