Issue
No results returned in reference Lookup in Agent Workspace
Release
All supported releases
Cause
The table the reference field is referencing is not an indexed table. Since the lookup uses keyword search, any search performed on a table that is not indexed will not work.
You can verify if the table is indexed by navigating to System Definition > Text Indexes
Resolution
To solve this issue you will need to index the table being referenced. Before you do this, we recommend opening a ticket with support to check if there will be any negative impact on performance.