Report based on substring of Short Description

Yogi R
Mega Contributor

‎09-09-2022 02:28 AM

Dear Team,

Is that possible to prepare a report based on substring of Short description .

We have set of  incidents having same description except  Date.

If we exclude the date part alone ,we should be able to find the duplicates easily using Group By options .

Any thoughts or alternative options you could share .

 

Thanks

Yogi

 

 

 

 

Labels:
0 Helpfuls
  • 816 Views
2 REPLIES 2

AnirudhKumar
Mega Sage
Mega Sage

‎09-09-2022 07:49 AM

Have you tired using a 'short description contains' filter? (assuming its a list type report)

Anyway, there is always script include to the rescue. Use a 'sys id IN' and call a script include containing the script logic on your incident short descriptions.

Yogi R
Mega Contributor

‎09-09-2022 08:24 AM

Thanks AnirudhKumar,

We could not use generic filter like 'short description contains'  and even if we use it ... during the   "Group By" we will not be able to find duplicates.

Ex Scenario

INC1-Alert1 raised on 07.08.2022

INC2-Alert1 raised on 08.08.2022

INC3-Alert2 raised on 08.08.2022

INC4-Alert2 raised on 09.09.2022

 

 

In some forum they mentioned about some kind of script.

If there is any starting point ,I will take it further.

Thanks for feedback !

 

Regards

Yogi

 

0 Helpfuls