Missing Fields in Filter Result Gadget After update from JIRA 6.3.15 to JIRA 6.4.X

Problem

An issue occurs where filter result gadget have fields that were specified in them going missing after an update from JIRA 6.3.15 to JIRA 6.4.X.

• This occurs to random Filter Result gadgets.
  • Usually the only field left on the table would be Due Date(as seen on the gadget)

Steps to Replicate:

1. Create a JIRA 6.3.15 with sample data and multple filter result gadgets on the dashboard.
2. Upgrade the instance to JIRA 6.4.X(also occurs if data is restored between the versions)
3. Check the Dashboard and you should notice that some filters would have their specified fields missing.
4. When you check the database, you should notice a change in the content of the fields data under userprefvalue field in gadgetuserpreference table.

Workaround:

1. If you know the expected fields that went missing you could either add them back manually by editing each field or in the case you want to perform a bulk change then you would need to do this from the database:
   • Backup your database

   • SELECT portletconfiguration.id, gadgetuserpreference.portletconfiguration,gadgetuserpreference.userprefvalue, portletconfiguration.portalpage, portletconfiguration.gadget_xml 
     FROM gadgetuserpreference LEFT JOIN PORTLETCONFIGURATION ON gadgetuserpreference.portletconfiguration = portletconfiguration.id 
     WHERE gadget_xml like '%filter-results-gadget.xml' AND userprefvalue ='--Default--|duedate';//Query the database for matching field ids between portletconfiguration and gadgetuserpref tables

     (This should give you a list of all affected data based on my sample scenario described above, though you need to be careful of filters that have a different configuration and are affected as well

   • Update the fields using this code:

     UPDATE gadgetuserpreference
     SET userprefvalue = '--Default--|issuetype|issuekey|summary|priority|duedate'
     WHERE userprefvalue = '--Default--|duedate'//update set value should be based on what is missing

   • This should fix broken gadgets in the JIRA instance.