Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Where to find values of scripted fields in the database?

I am trying to create a SQL query which involves scripted fields from Jira, but there is no information available for scripted fields in the customfieldvalue table.

Apparently it is not stored in the same table or is not there in the database at all.

Reading few old similar discussions, I found that the scripted fields work over indexes, can anybody suggest a workaround to fetch values of scripted fields via database if possible?


1 answer

1 accepted

0 votes
Answer accepted

There is no way to get scripted/calculated fields from the database (yet another reason to not use the database - it is the worst possible way to get information from Jira).  The scripted fields simply aren't there.  The best you could do with the database is read the scripts behind the fields and replicate the logic in them from scratch to calculate them for yourself.

You will need to move to using the UI or REST API - they can expose the index and hence scripted fields.

Thanks Nic!

Could you please suggest which table to look for the scripts?

I don't know, it's not something we should ever be worrying about.  I would expect it to be a table named AO_4B00E6_something, but I've not looked.

You do know that to extract this, you're going to need to implement a full Groovy/Java environment to run the scripts in against the data you extract?

This is not an insignificant piece of work, you could be trying to do this for months. 

I still very strongly recommend that you stop using SQL and use REST

Like Divyanshu Dwivedi likes this

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Apps & Integrations

🍻🍂Apptoberfest Update: Upcoming Virtual Events 🎉

Hello Community! I hope you've been enjoying the 🍂Apptoberfestivities🍂 (I know I have!) The event is heating up next week with a series of virtual events that we're calling the 🍻🍂Partner App ...

393 views 3 17
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you