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

[subbarayudu]

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.

Thanks in advance.

[Dr Atul G- LNG]

Hi @subbarayudu 

Anything in the dictionary overridden? the chances are less.  Try to filter with value and then check the table names.

[swathisarang98]

Hi @subbarayudu ,

If it is extending any table check the state choices in it ..your field might be showing parent table state choice,

Open sn_grc_issue check which table its extending check the state choice aswell

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

Regards,

Swathi Sarang

[James Chun]

Hi @subbarayudu,

Since the Task table is extended to various tables, you see all the states in its children's tables as well.

The reason for having duplicates is that there are states with the same Label (e.g. Review) but with a different value in the children's tables.

For example, if you filter the 'Choices' of the state field where the Label = Open, you will see something like below:

In this example, since there are two different values (1 and 10) where the label is Open, you will get two 'Open' choices in your report. 

Another thing to keep in mind is that some of the choice values are identical but represent a different state. An example of this is below where value = 1

Because of all of these 'complexities', I don't recommend creating a report on the Task record if you need to filter by its state.

Cheers

[AndersBGS]

Hi @subbarayudu ,

I'm a little in doubt about your question, since your mentioning that the state is from the task table, but the picture you have referenced is the sn_grc_issue table? If you refer to the task table, so the state field lives on the task table where any any table inherit this field - hence multiple can be showed. 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders