Where are gadget preference stored in JIRA 5.1.8?

[Andrew Frayling]

Hi,

We're standardising some of our custom fields in our JIRA instance and I need to find all gadgets that use a particular custom field in their configuration.

E.g. the out of the box Pie Chart gadget lets you select a custom field for the statistic type, is it possible to search for all gadget instances that use a particular custom field for their statistic type?

Cheers,

Andrew.

[Fabio Racobaldo _Herzum_ · Accepted solution]

Hello Andrew,

in order to retrieve those information you need to perform a query at database level.

Table wich stores these info should be "gadgetuserpreference" that is linked to portletconfiguration table.

Hope this helps,

Fabio

[Andrew Frayling]

Thanks Fabio, just what I was looking for.