OOTB Self Service Knowledge Search History Report - add the query text searched to report

OOTB Self Service Knowledge Search History Report - add the query text searched to report

Hi all,

I really like the idea of this report.  I want it though to show me what they searched for and couldn't find in the knowledge base.  Has anyone been able to adjust this report to make the actual text the user entered / searched on show up in this report?

  • At the Table level it appears to be storing the data in the "query" blob field.  But when I tried to modify the OOTB report and add this field it's showing up empty for some reason.  I know there is data in the system though, so I must be doing something wrong and/or there is a limitation with Crystal reports and blob fields.

  • Hello Christopher,

    hope you are doing fine.

    could you please provide more details? I think I have not clear the idea. Ohterwise, what steps did you follow to configure the report? and what message is displayed?

     

  • Hi Chris,

    One trick I use to check if a SM BLOB is stored in SM own format is to check on SQLserver/Oracle. I checked query of the KMSearchhistm1 table and sure enough, It's not text and not decipherable.

    There is a possible solution. Make a copy of the table and experiment with that before you change the actual table. Have a look at 'How to remap one field or all arrays as multi-row array table, performance problems Document ID :KM961884'. If you can remap the query field to a text array, it will then be possible to report on the data. Good luck.

  • I really hate Oracle BLOB fields.  So much of our system is using these fields and I can't use them very well in any kind of reporting.