Hi Wale,

You are only seeing the status filters that would match any data when used. This is because the 'Filter assistance' setting of the query filter is turned on. This setting will notify the component of different statistics about the dataset to adjust the visible filters. Turning the setting off will show all possible discrete value for the column. Note that the counters next to the states will disappear.

Update

I have taken a look at the setup and will try and explain the difference between the columns:

• The 'Status' column in the setup is added by a custom operator. These custom columns currently have no concept of discrete values. This means that you will not see anything expect a text field when 'filter assistance' is turned off. With the assistance on, you will see a checkbox for all different values that are present in the dataset.
• The 'MCR Status' column is different, this column doesn't come from a custom implementation. This means that the column does know all different discrete values that it can have. With the assistance turned off, you will see a checkbox for all possible values of the column. With filter assistance on, it will act the same as above. Only the values that are actually present in the dataset will be shown.

Next to these differences, the query filter also doesn't have any real-time updates. The counts that are shown with the filter assistance turned on are a snapshot of the data. We have recently improved this by adding the possibility to link a trigger to the query filter. This makes is possible to refresh the data that is shown in the filter. This feature will be available from DataMiner 10.4.0[CU12]/10.5.3 onwards.

This still leaves the missing 'Not defined' value unexplained from the 'MCR Status' filter. I suggest you contact tech support to look further into this issue since I believe it should be shown with filter assistance disabled.