We would like to create a query on the database involving the customfieldvalue of a scripted field, but apparently it is not stored there.
Where should we find it (if at all persisted)
I seem to remember that scripted fields store their results data in the index. (I know that's how derived fields do it, but I could be wrong about scripted fields and they build it on-the-fly whenever it's needed)
I'm afraid that if you're reporting off the database, then the only real answer is to duplicate the work the scripted field does in your reporting.
If you're randomly losing scripts like that, you need to be looking at the rogue application or script that is trashing your data, not patching over it by taking backups and manually re-entering scripts. Neither Jira nor Scriptrunner have code that would delete scripts during indexing.
They're held in the AO tables that SR adds to Jira when you install it.
Hi Community! The submissions are in (and listed below) for the 🍻🍂Apptoberfest🍂🍻 Demo Competition and it’s time for you to place your votes for the best: Analytics & reporting app demo ...
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