How to fetch custom field value from database for scripted fields on a jira issue ?

Question

Hi @Jamie Echlin [Adaptavist] ,

May i know the database table which stores custom field values of scripted fields ?

OR

Any way to search for a number field type scripted field values to get from database ?

Please guide me on this.

Regards

Chander Inguva

Nic Brough -Adaptavist- · Answer

You don't need JQL functions to search scripted fields, they appear as normal fields as long as you've got a searcher for them.

Chander Inguva · Answer

UI meaning using Issue function on JQL ?

Nic Brough -Adaptavist- · Answer

Scripted field values are not held in the database.  You can search for them with REST or the UI as though they're standard fields though.