exclude tickets with specific keywords

[JaganV]

Hi All,

Is there a way to exclude change requests with specific keywords in the reports.

Thanks and Regards,

Jagannadh

[swathisarang98]

Hi @JaganV ,

Could you please explain when you say keyword with which field you are trying filter and with what keyword ?

Please mark this comment as Correct Answer/Helpful if it helped you.

Regards,

Swathi Sarang

[JaganV]

Hi @swathisarang98,

Thank you for the response. I'm trying to filter with Worknotes or Additional Comments.

Regards,

Jagan

[swathisarang98]

Hi @JaganV ,

Directly in change request table or through reporting you can not achieve this,

2 ways to do,

1. create  a database view and report on that database view ,please refer below servicenow support article to achieve this,

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0696891 

2.You can directly navigate to Journal entry table and there you can filter element as Work_note and table as change_request and you will get the value ,

Please mark this comment as Correct Answer/Helpful if it helped you.

Regards,

Swathi Sarang

[JaganV]

Hi @swathisarang98,

Unfortunately as a user, i don't have privileges to create a database view or navigate to journal entry table. Thank you for the reponse.

Regards,

Jagan

[swathisarang98]

Hi @JaganV , Do you have access to change request table if yes you can directly go to change_request table and add additional comment and work note field from personalise and in search give *and your keyword(ex:- testing) as shown below,

Please mark this comment as Correct Answer/Helpful if it helped you.

Regards,

Swathi Sarang