I have a SharePoint 2016 on-premises farm that contains a large list of items with several text fields that should be searchable.
Drawings: Title Name Building Approval Date Category
Each of these fields should be searchable. Performing a standard search on the list returns the correct results. For example, searching for "333" will return all drawings that contain 333 in any field. However, when attempting to search a specific field using KQL, I am not getting any results. I am attempting to search the Building field for the value "333". I have tried searching using the syntax Building:333, Building:333* and Building:333. None of these queries returned any results. I can go to the list view and filter by the building column and it returns the correct results. I have tried searches on other columns with the same results. I also attempted to search filtering out any empty Buildings by using the syntax Building<>"". Rather than returning no results, this returned ALL the items in the list including the ones in which the Building column was empty.
This is the first time I've attempted to use KQL, so it's very possible that I don't have something set up correctly or I don't have a required feature turned on. However, at this point, I don't even know what to look for. Can anyone tell me why this might be happening?
I have also verified that my search index is running correctly and all the drawings appear to be indexed as they are showing up in searches not using KQL.