A field when viewed in list view is null but in the form it has some value

[nikhil_001]

Hi Everyone,

We have   'hardware component'   table that extends to 'Hardware' table which also extends to 'cmdb_ci' table, we have one field 'Status' which is the field on the 'cmdb_ci' table, the field is showing null value in the list view of   'hardware component'   table but if we check in the form of the 'hardware component' it has value. When we double click the list view that same value gets populated in the list view as showing in the form.

There is one more doubt as we have set the default value to be '1' but it is taking the value on the form of hardware component to the other value which is '18'.

We have thousands of record which needs to be updated.Can someone give the reason why it is happening?

Thanks & Regards,

Nikhil Jain

[Aanchal Mehndi1]

Hi Nikhil,

It can be issue of ACLs.

Did you check ACLs?

[nikhil_001]

Hi Aanchal,

I have the admin role so i can see all the records.

Thanks & Regards,

Nikhil Jain

[Aanchal Mehndi1]

Is Status is a Drop Down Field ?

This thread might be helpful for you.

Field shown blank for few records in list view in spite of having values

[nikhil_001]

Hi Aanchal,

Thanks for the similar link.

The link was useful for the first query but the default value it is taking on the form is still incorrect.

Thanks & Regards,

Nikhil Jain