Reset Filter Results gadget so it shows the results as ordered in the configured filter

Problem Definition

As an admin I would like our users could reset the Filter Results gadget to its default filter ordering when the page is reloaded. Once we create this gadget and a user clicks to any column to sort, the default sort definded in the filter is gone and never comes back (since the user last columns sorting is saved).

Suggested Solution

Options to solve this problem:

• A refresh of the gadgets page could reset the results in this gadget
• A reset filter order option could be added to the gadget
• The filter could have an option to block columns sorting

Workaround

The main field (used as the first field in the order by statement) used to order the filter results should always be presented as a column in the gadget. Once the user sorts the column with the correct field, the results will be sorted as defined in the filter.