Confused about search and custom fields

[pkropf]

I have a custom field for devices and virtual machines called NTA1 along with several other fields. When I search for a value that could be found in NTA1, sometimes it matches and sometimes it doesn't. It's very confusing for my users. I have multiple devices and virtual machines where the search works correctly, just sometimes doesn't. Here's two examples:

A virtual machine called ebridge with NTA1 set to 526:

select custom_field_data, name from virtualization_virtualmachine
where name in ('ebridge');

"custom_field_data","name"
"{""NTA1"": 526, ""NTA2"": null, ""NTA3"": null, ""Listener"": null, ""Replication"": null}","ebridge"

---

A device names ea420 with NTA1 set to 420:

select custom_field_data, name from dcim_device
where name in ('ea420');

"custom_field_data","name"
"{""NTA1"": 420, ""NTA2"": null, ""NTA3"": null, ""Listener"": null, ""Replication"": null}","ea420"

Anyone have thoughts as to why the search sometimes returns valid results from custom fields and other times it doesn't?

P.S. The code sections are pseudo-sql since I cut and pasted from pgadmin.