Report creation with close note less than or equal to 10 characters

abhi_b · ‎04-05-2024

Hello everyone,

I would like to ask if someone can help in creating a report that has a condition which i'm not able to achieve with out of the box features in servicenow.

Ask is to create a report on incident table having records closed in last 3 months and have resolution note (close_notes) less than or equal to 10 characters. Being new to servicenow, I'm easily able to create a report for incidents closed in last 3 months but the other requirement for resolution note (close_notes) "less than or equal to 10 characters", I'm not able to achieve.

Can someone help me to achieve this functionality? I would be really appreciating and helping for me as a initial learner.

Thanks in advance.

Regards,

Abhishek

Prasanna_Patil · ‎04-05-2024

Hi @abhi_b

you can use "configure function field",

Steps:

1.Create new "configure function field"

2.Once the Function is created save the report

3.Search for the function in the Filter

4.Keep the filter as shown above and run the report. Result will be displayed as shown below

Kindly mark correct and accept the solution if you find this resolves your query.

Thanks and Regards,

PP

View solution in original post

Prasanna_Patil · ‎04-08-2024

Hi @abhi_b

Glad to hear that!!

Regards,