How to search on a 'secure number' custom field of addon "Security Fields and Attachments"?

[Tom Van Rossom]

I've installed the addon "Security Fields and Attachments" and configured it in my project. Now I would like to use it in JQL, but it gives an error

"Field 'Amount' is not searchable, it is only sortable."

Any ideas how to fix this?

[Nic Brough -Adaptavist-]

That message means what it says, but is worth explaining further. 

Fields in Jira are mostly intended to be used for capturing data so it can be reported on later.  Reporting tends to have two elements - showing you the data, and allowing you to search for it.

Showing you data in a field, or getting the data and calculating stuff from it is pretty obvious - you look at it.   But for searching, Jira needs to be told how to search it.  This is what a searcher does - it creates the data for indexing the field so it can be searched and tells Jira the type of input it wants from the user when asking for search criteria.

The field you have got here has no searcher set, and there are none provided by the app that is providing the field.  So you can't set a searcher, and hence there's no way to search it.  You'll need the authors to add a searcher for the field if you want to search it.

[Tom Van Rossom]

Ok, now I understand. Thanks!

[Earl McCutcheon]

Hi Tom,

It sounds like the filed does not have a Search Template defined as covered in Configuring a custom field 

Go to admin >> Issues >> FIELDS >> custom fields >> "Amount" >> edit  and set a value for the Search Template in the drop down list, You will need to run a Re-Index after this is set to populate the search template into the index.

Regards,
Earl

[Tom Van Rossom]

Thanks Earl for the reply, but there is no drop down list, only the message "There are no search templates for this custom field type" ???