Portal Activity Report WCR_WEBCONTENTSTAT for PCDURL field no data fetched

55 Views

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.

Regards

Poonam Sharma