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.