Begin of the insertion**As a** user
**I want to** be ableEnd of the insertion Begin of the deletion ### StepsEnd of the deletion to Begin of the insertionsearch for item labels ofEnd of the insertion Begin of the deletion reproduce

1. HaveEnd of the deletion a custom field Begin of the deletion of typeEnd of the deletion hierarchy Begin of the insertion
**so that** I can find work packages which haveEnd of the insertion Begin of the deletion that is marked as "Searchable"

2. ProvideEnd of the deletion a value Begin of the insertionassigned matchingEnd of the insertion Begin of the deletion forEnd of the deletion the Begin of the insertionsearch term.End of the insertion Begin of the deletion custom field on a work package


### What is the buggy behavior?End of the deletion

Begin of the insertion**Acceptance Criteria**

End of the insertion * Begin of the insertionIf a textEnd of the insertion Begin of the deletion Search for the value in the project search


### WhatEnd of the deletion is Begin of the insertionsearched globally,End of the insertion the Begin of the insertionsearch result must containEnd of the insertion Begin of the deletion expected behavior?

1. Have theEnd of the deletion work Begin of the insertionpackages, that have a value assigned to a custom field of type hierarchy whereEnd of the insertion Begin of the deletion package found ifEnd of the deletion the search Begin of the insertiontermEnd of the insertion Begin of the deletion stringEnd of the deletion matches the Begin of the insertionfollowing expectations:

* End of the insertion Begin of the deletion value selected forEnd of the deletion the Begin of the insertionsearch term is a substring ofEnd of the insertion Begin of the deletion work package


OR:

1. RemoveEnd of the deletion the Begin of the insertionitem label

* End of the insertion Begin of the deletion option fromEnd of the deletion the Begin of the insertionsearch term is a substring of any ancestor label onEnd of the insertion Begin of the deletion custom field form 


### Screenshots and other files

Work package can be filtered for byEnd of the deletion the Begin of the insertionbranch ofEnd of the insertion Begin of the deletion value "Berlin"

### <img class="op-uc-image op-uc-image_inline" src="/api/v3/attachments/241533/content">

The same custom field cannot be found by inserting &quot;Berlin&quot; intoEnd of the deletion the Begin of the insertionitem

* theEnd of the insertion search Begin of the insertiontermEnd of the insertion Begin of the deletion

<img class="op-uc-image op-uc-image_inline" src="/api/v3/attachments/241534/content"> <img class="op-uc-image op-uc-image_inline" src="/api/v3/attachments/241535/content">

The CFEnd of the deletion is Begin of the insertiona substring of the item short


End of the insertion Begin of the deletion marked as searchable

<img class="op-uc-image op-uc-image_inline" src="/api/v3/attachments/241536/content">

End of the deletion ### Information

* the custom values of custom fields of type list do have special handling in `act_as_searchable.rb`


```ruby
def build_custom_field_condition(custom_field_ids)
CustomValue.select("1")
.joins(<<~SQL.squish)
LEFT JOIN custom_options
ON custom_options.custom_field_id = custom_values.custom_field_id
AND custom_options.id::VARCHAR = custom_values.value
SQL
.where(customized_type: name, custom_field_id: custom_field_ids)
.where("customized_id=#{table_name}.id")
.where("(custom_values.value ILIKE ?) OR (custom_options.value ILIKE ?)")
end
```

* usually this kind of code should go into responsibility of the custom field itself