How to query for work notes in a regular report?

[ritajit]

There is a requirement from the change team to query on the work notes field to check for keywords and extract the change records based on the condition. However, i don't see the field "work notes" when I try to add it as a filter.

I am able to add the work notes field to the table change_request/change_task but while trying to use it as a filter, I am not able to view it as a option from the list. Is is not a out of the box feature? Would appreciate any prompt response on this.Thanks

[SanjivMeher]

Worknotes wont show up since it is a Journal field and always empty. It is only used to pass notes to the Activity.

You will have to use keywords, if you want to search a text, but it wont just query the activity, it will query other fields as well such as description, short description etc.