TMDM-7606: "Sort by time in journal web app generates wrong query"

Fix order in parameters.
(https://jira.talendforge.org/browse/TMDM-7606)
TMDM-7604: "Error while creating a record in Staging data browser(SqlServer only)"

Fix incorrect query analysis when fields that don't need checks are processed for incompatible operators.
(https://jira.talendforge.org/browse/TMDM-7604)
TMDM-7602: "Ensure maxLength changes are considered as elements to require a database schema update"

Includes maxLength changes in data model comparison (as modification).
Reports maxLength modifications are high impact changes on Hibernate storage.
(https://jira.talendforge.org/browse/TMDM-7602)
TMDM-7599: "Query uses operators incompatible with 'text' data type (SQL Server)"

Raise limit for nvarchar to 4000 in custom Hibernate dialect (aligned with database capabilities).
(https://jira.talendforge.org/browse/TMDM-7599)
TMDM-7190: "tMDMViewSearch component can't search result when Operations area using "Contains" and "Full Text Search" function."

Fix incorrect behavior when projection holds a metadata field *and* query uses full text.
Minor refactoring for reading metadata values out of DataRecord instances.
Adds unit test for issue.
(https://jira.talendforge.org/browse/TMDM-7190)
Tests: don't share same H2 database between user and system data (weird side effect when system storage tests are ran in the middle of data tests).
TMDM-7599: "Query uses operators incompatible with 'text' data type (SQL Server)"

Overrides default Hibernate mapping if LONGVARCHAR to "text" (now nvarchar(max)).
(https://jira.talendforge.org/browse/TMDM-7599)
TMDM-7599: "Query uses operators incompatible with 'text' data type (SQL Server)"

Overrides default Hibernate mapping of LONGVARCHAR to "text" (now nvarchar(max)).
Completes previous commit (previous commit only covered LONG - N  - VARCHAR).
(https://jira.talendforge.org/browse/TMDM-7599)
TMDM-7372 Filled with the FK ID automatically after user creates FK entity on the fly from the main tab or the FK tab.

TMDM-7372 Auto set FK when it render in the main tab and auto add a new one in grid when it render in tab panel.

Merge branch 'master' of https://github.com/Talend/tmdm-server-se into bugfix/TMDM-7372

TMDM-7371 Fixed no id after create a FK record of auto id.
TMDM-7599: "Query uses operators incompatible with 'text' data type (SQL Server)"

Overrides default Hibernate mapping if LONGVARCHAR to "text" (now nvarchar(max)).
(https://jira.talendforge.org/browse/TMDM-7599)

TMDM-7599: "Query uses operators incompatible with 'text' data type (SQL Server)"

Overrides default Hibernate mapping of LONGVARCHAR to "text" (now nvarchar(max)).
Completes previous commit (previous commit only covered LONG - N  - VARCHAR).
(https://jira.talendforge.org/browse/TMDM-7599)
Merge branch 'maintenance/5.6' of https://github.com/Talend/tmdm-server-se into maintenance/5.6
TMDM-7372 Link parent to child when saving FK entity created on the fly.
TMDM-7192: "Refactor delete process to include update report creation"

Web app refactorings:
  Browse record actions code clean up (physical and logical delete to delegate update report creation to server).
  Removes duplicated code for webservice stubs (reuses classes from org.talend.mdm.core).
  Removes duplicated code for webservice objects <-> POJO translation (reuses XConverter).
  Refactoring of client for enterprise / open source versions (enterprise now extends open source to prevent code duplication and errors).
  Web application calls to reuse bean delegators (iso. duplicated code).
  Separate web app exception handling from actual client.

Server refactoring:
  Changes supportStaging() to become a stateless method (to remove dependency on current logged on user).
  Adds option for delete and drop for generating an update report on WSDeleteItem and WSDropItem.

Clean up:
  Removes unit test used to test mock (IXtentisPortTest removed).
  Major code clean up (unused classes, obvious code issues).

TMDM-6104: "Remove method com.amalto.webapp.core.util.Util#createUpdateReport"
Removes update report creation in web ui.

TMDM-7576: "JournalHistoryService parses over and over data model to generates diffs"
Fix journal data model parsing issues (reuse server cache).

TMDM-7567: "restore events is missing in journal entries"
Cleaner separation of web ui and drop / recover item (update reports to be created server side).

TMDM-7606: "Refactor delete process to include update report creation"
Fixes order of parameters following reuse of API defined in core module (desync between core and webapp modules).

(https://jira.talendforge.org/browse/TMDM-7192)
(https://jira.talendforge.org/browse/TMDM-6104)
(https://jira.talendforge.org/browse/TMDM-7576)
(https://jira.talendforge.org/browse/TMDM-7567)
(https://jira.talendforge.org/browse/TMDM-7606)
Merge branch 'feature/5.6/TMDM-7192' into maintenance/5.6
TMDM-7524: "The web server does not work after loging it use DB2 database."

Enforces use of CLOBs for DB2 in case of system database.
(https://jira.talendforge.org/browse/TMDM-7524)
TMDM-7593: set [NO OP (TRUE)] to [NO OP (false)] in 'OR' BINARY LOGIC OPERATOR
TMDM-7199: "MDM Studio Data Container Browser view can't search result with "time period", "Keywords" and "Use Full Text Search" option."

Fix incorrect indexing on numeric fields: remove annotation "NumericField" (not present in currently used version of HibernateSearch).
Use TermRangeQuery iso. NumericRangeQuery (needs @NumericField to work).
Adds missing range implementation in search for type transitive closure.
Adds unit test for reproducing issue.
(https://jira.talendforge.org/browse/TMDM-7199)
TMDM-7608 : foreign key search issue unable to single search
TMDM-7137: "Staging validation deleted the Product family failed if it was used in master"
TMDM-7614: "Translation for new 'delete failed due to constraint issue'"

Adds new staging constant 405 (deletion failed due to constraint issue).
Updates web application tool tips for new 405 status (as defined in TMDM-7614).
Updates server-side behavior for 405 instances (retries previously failed deletions during validation).
Fix issue when path to display in web UI includes an internal field (for example: "$staging_status$").
(https://jira.talendforge.org/browse/TMDM-7317)
(https://jira.talendforge.org/browse/TMDM-7614)
TMDM-5126 : "Advanced search does not work for list of complex types"

Consider full text search on a non-data field as a "or(f1(or(f2,...)))" (f1...fN are reachable simple fields from query field type).
Adds unit test for feature.
(https://jira.talendforge.org/browse/TMDM-5126)