Add sort by functionality to takeovers 'cooked' content

[carkod]

Done

• Added sort functionality, order by active -> true and
• Refactored data explorer query into single one query_engage_pages_by_param
• Added count active query that works with pagination.
• Added total count of pages
• Added total count of all items Most of this work done in data explorer

QA

1. Go to https://ubuntu-com-14035.demos.haus/engage
2. Scroll down and click next page and/or the numbers to check that next page doesn't repeat the same engage pages.
3. Select language, and check that the correct language of engage pages shows
4. Same for resource types and tags

Do the steps 1 and 2 for https://ubuntu-com-14035.demos.haus/takeovers Check for https://ubuntu-com-14035.demos.haus/takeovers.json works as usual. Test security limits e.g. limit=2000

[carkod]

Thanks @carkod! I have a few questions:

• https://ubuntu-com-14035.demos.haus/takeovers is returning a 500 server error
• When I filter languages to Deutch, it seems to show German engage pages instead
• Some tags are not returning any pages when filtered, maybe these tags can be removed from the selection dropdown. Perhaps this is related to what you've mentioned yesterday about adding a "tags" column on the data explorer?

All fixed. "Deutsch" means "German" in German language. Tags are a collection of tags that engage page authors add, we have no control over how many and how they are written, I simply had to go through every engage page and compile a list of all tags, so previously it jus wasn't working properly, it's fixed.