Why I am getting double values for the "state" field when I tried to filter state field in report.

subbarayudu
Tera Contributor

The state field is from task table.it show double Review, Respond, Closed cancelled...etc,.

Could you please let me know the why it behaving like and what is the reason

How we can avoid duplicate values in state filed.

 

subbarayudu_0-1711729983635.png

subbarayudu_1-1711730089891.png

 

Thanks in advance.

8 REPLIES 8

Dr Atul G- LNG
Tera Patron

Are you getting same issue in list view as well? or form ?

*************************************************************************************************************
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/dratulgrover [ Connect for 1-1 Session]

****************************************************************************************************************

I am getting the same issue on list view as well, but in the form state field would be read- only.

Check the choices in State field, via dictionary entry.  Might be someone added by mistake. 

*************************************************************************************************************
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/dratulgrover [ Connect for 1-1 Session]

****************************************************************************************************************

I have checked the choices in State field, via dictionary entry nothing is added in that table. but when i filtered with issue table on the dictionary, i am getting the following result

subbarayudu_0-1711731948899.png