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
Tera Patron

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

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

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/atul_grover_lng [ 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. 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

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/atul_grover_lng [ 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