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

[Chander Inguva]

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-]

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.

[Chander Inguva]

UI meaning using Issue function on JQL ?

[Nic Brough -Adaptavist-]

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.