Reference field not showing all the options from table

[mdsh]

Hi All,

Here is my issue.

In my catalog item, there is a Reference type variable which points to cmdb_ci_db_instance table.

But when I try to search for a field which I know exists in that table , it does not showing up in the lookup results. Not only a single record, there are multiple records which exist in the DB Instance table, but not visible in my lookup field.

Has anyone faced similar issue? 

Thanks.

[mdsh]

Hi Gaurav,

Finally I figured out the issue. It was with the user preference, where the search should have been "contains", but it was "starts with". So, the reference field was not returning the search results even if it was there.

[Laukik1]

could you describe it in detail? I'm facing similar issue with sys_user_group_type table