I have staging table where the devices will be created first before it will go to the actual CMDB classes upon approval. However, there is a choice field called "Device State" and it holds 2 choices such as New & Existing. I'm trying to set the value of this field based on the availability of the device name exists in the actual cmdb classes. If it exists I'm populating the device state as "Existing", if it's new then populating "New" and I used calculated value option under the dictionary of that field. It seems it is working fine
However, when I go and check in the staging and group by the Device state. it show 3 categories along with empty but the value is already present for them
Also I tried adding the JavaScript to default value of field dictionary but the issue is still the same
It is behaving weirdly. Under the New show matching we can some records with device state as existing. Not able to understand the issue? Can anyone help us if you come across this scenario?
