Is it possible to clear all ratings?

[Matthew J. Horn]

When we move from a test to a production environment, we'd like to "reset" the page ratings. Is this possible with the Adaptavist rate plugin?

[Matthew J. Horn]

Anyone have anything on this?

[Matthew J. Horn]

Heard back from Adaptavist. This is what they said:

The rating data is stored in 'Bandana', so you may be able to remove the data directly from the bandana table in the database.

The keys for the rating data will be prefixed with "com.adaptavist.confluence.rate.internals.RateManagerImpl:" if that helps.

Be careful though as the bandana table is used to store data for other plugins, so don't just empty it.

[Matthew J. Horn]

Follow up with some additional details:

1) To remove all ratings, run this query:

DELETE FROM [Confluence].[dbo].[BANDANA] WHERE [BANDANAKEY] LIKE 'com.adaptavist.confluence.rate.internals.RateManagerImpl:%'

2) To check, run this query:
SELECT * FROM [Confluence].[dbo].[BANDANA] WHERE [BANDANAKEY] LIKE 'com.adaptavist.confluence.rate.internals.RateManagerImpl:%'

There should be no results.

3) Must restart server after running the first query.