XWIKI-13087: The setup of user initial groups on user creation can set groups cache to a wrong value, resulting in wrong user groups until next restart

(cherry picked from commit 5710a756)

(cherry picked from commit 337fbc20)

(cherry picked from commit 621bf103)

XWIKI-13715: XWiki#getPlainUserName() should log only a warning instead of an error with full stack trace because it falls-back on the user profile reference name
* Improve warning message.

(cherry picked from commit e7f1ac1e)

* Lower a bit the test coverage ratio on the stable-7.4.x branch (it's still higher than it was before XWIKI-13700).

(cherry picked from commit 9ee96187)

XWIKI-13715: XWiki#getPlainUserName() should log only a warning instead of an error with full stack trace because it falls-back on the user profile reference name

(cherry picked from commit 48bd7e92)

XWIKI-13710: The title displayed for the current document in the navigation panel is "Document Tree"
* Actually the display script service doesn't help. Using the default displayer hint is not good because the documents that have a sheet associated (the BlogIntroduction) are badly displayed. We need to use the sheet displayer but we need to make sure the displayed document instance is different than the current document (and we can achieve this through clonning).

(cherry picked from commit b25b73b1)

(cherry picked from commit d1d90a63)

(cherry picked from commit 79b91bcf)

XWIKI-13712: Document#saveDocument set the document author as guest reference instead of null when context has no user

(cherry picked from commit 3ccbe39a)

XWIKI-13712: Document#saveDocument set the document author as guest reference instead of null when context has no user

(cherry picked from commit 272f302e)

* Last fix for PostgreSQL (column "title" does not exist)

(cherry picked from commit 8339901f)

* Fix query on PostgreSQL (PSQLException: ERROR: operator does not exist: boolean <> integer)

(cherry picked from commit bb649430)

* Oracle doesn't like "as" in some cases..

(cherry picked from commit 4b661061)

* Drop the XWikiPage* fake tables (that were mapped to an SQL query) and use named native queries instead in order to keep the joins and constraints inside the union
* Drop the hierarchy.hbm.xml file as a consequence.
* Add support for executing native named queries (they behave exactly as a HQL named query)
* Put the named native SQL queries in a separate queries.hbm.xml that is loaded when XWiki starts (through an ApplicationStartedEvent listener)
* Write some query filters to modify the named native SQL queries (in order to limit the code that is aware of the SQL usage). Only these query filters need to be updated in case we move to HQL.

(cherry picked from commit 6f3cf422)

XWIKI-13710: The title displayed for the current document in the navigation panel is "Document Tree"
* Use the display script service in order to make sure the sheet request parameter doesn't affect the displayed title.

(cherry picked from commit 701d920b)

(cherry picked from commit 76c44a0a)

(cherry picked from commit 88866885)

- Resetting the creation date and setting the creator/lastAuthor as the current user.

(cherry picked from commit 22af3c87)

- Removed unneeded spaces between velocity calls
- Removing unneeded {{velocity}} call that added a paragraph
- Removed unneeded if
- Fixed the indentation

(cherry picked from commit b22cdb8c)

XWIKI-13673: Wiki descriptor section from administration gives error on saving after changing owner.

(cherry picked from commit b2d8f40d)

(cherry picked from commit 507864d8)

XWIKI-10118:     XWIKI-10118  Container macro cannot be added more than once with different number of columns

Fix tests in xwiki-platform-dashboard-macro to reflect CSS class changes
(cherry picked from commit bb4bc952)

* Request the tree JSON through the current document so that relative references are correctly resolved.

(cherry picked from commit dcbc61de)

* Fix build for Java 7.

XWIKI-11611: Presentation Office documents (.ppt & .pptx) aren't displayed with LibreOffice 4.3.0.1+
* Upgrade the JODConverter version.

(cherry picked from commit 6fdc5577)

* Fix parent version after cherry-pick.

* Un-wrap the links generated from wiki syntax so that they are taken into account by jsTree.

(cherry picked from commit 9c5c05e1)

* Show the Attachments node when showAddAttachment=true, even if there are no attachments.
* Refactor a bit the code to remove duplication.

(cherry picked from commit 2d8f1bc5)

* Add missing dependency.

(cherry picked from commit 6f209fac)

* Move the hierarchy mapping in a separate file to avoid duplication.

(cherry picked from commit 42526269)

Revert "XWIKI-13468: The query used by the Document Tree to get the nested child pages is very costly"
* Too much duplication. Better move the hierarchy mapping in a separate file.

This reverts commit da8a821d.

(cherry picked from commit a9adeb63)

* Update the database-specific mapping files.

(cherry picked from commit da8a821d)

* Define a new Hibernate entity, XWikiPage, mapped to a SQL union between the documents table and the spaces table. This new entity is used in HQL queries to fetch the Nested Pages hierarchy.
* Separate the Document Tree code that queries the Nested Pages hierarchy from the code that displays the hierarchy. Move the former from Velocity to Java components. This way the Document Tree doesn't requrie PR for querying the Nested Pages hierarchy.
XWIKI-13615: "one more" does not make sense
* Query limit+1 child nodes and display only limit if there are more left.
XWIKI-12909: openTo doesn't work when root is specified as relative reference
XWIKI-13225: Finder in documentTree not working
* Resolve the relative root and openTo parameters.
XWIKI-13183: Some document tree branches not translated
* Display the translated page title
XWIKI-12832: Add support for sorting the pages by their title in the document tree
* Sort by the raw translated title field (with fall-back on the default title and then on page/space name)

(cherry picked from commit 8c642a7c)

(cherry picked from commit a56351ce)

(cherry picked from commit c3c735ca)

(cherry picked from commit b54cb3ea)