Add pagination functionality to database queries

[turnerrainer]

AS AN Architect
I WANT pagination functionality to be implemented in database queries
SO THAT only relevant data would be queried at any given time

Acceptance Criteria

GUI

• Number of pages for relevant service are shown in GUI

DSL

• A REST endpoint to fetch data without any relevant content to get the total number of results per query
• A REST endpoint to fetch data containing relevant content in scope of selected pagination
• Predefined parameters can be passed to SQL queries if there are changes in filters and sorters

This is to replace client-side filtering and sorting of results with server-side filtering and sorting

Scope

• Add pagination functionality to Backoffice's database queries #645
• Add pagination functionality to Training Module's database queries Training-Module#508
• Add pagination functionality to Service Module's database queries Service-Module#299
• Add pagination functionality to Analytics Module's database queries Analytics-Module#243

[rasmusei]

@turnerrainer not all the sub tasks are done, please check