Revert "LPS-40695 JournalArticle left join should check on workflow status"

This reverts commit 0ef716453e60c7087797334aeddb275b4af1a221.
LPS-42064 Checks if User is <= 0 to remove it from query
LPS-42064 Use the same method
LPS-42064 Fix logic, we should get subfolders only when the rootFolderId != Default
LPS-42064 SF
LPS-42050 Remove one of the equals signs: this has been introduced by mistake during a source formatting process
LPS-41894 Failing Integration test for this issue
LPS-41894 some tests to guard original SQLServerLimitStringUtil logic
LPS-41894 Minimum fix.
LPS-41894 some more QueryUtilTest integration tests to verify logic
LPS-41894 Removing unnesessary code, no logic changes.
LPS-41894 Source formatting
LPS-41894 SF
LPS-42074 Fine tuning portlet publish when in global scope (no layouts and on control panel)
LPS-38733 Only update the version if the record has changed, added a case to the DLFileVersionTest and consolidate some of the logic into Fields.
LPS-38733 Don't link the entire class, just the methods
LPS-38733 Source formatting
LPS-38733 SF
LPS-41894 Remove unused code
LPS-42075 We should set the locale in the session only when the user is signed in. If the user is not signed in we shouldn't update the locale of the session because if we do it there is no way a guest user can switch the language using the language portlet (if he adds the locale in the url is fine because it doesn't go through the i18nFilter). For a signed in user we can set the locale in the session because when the user switches the language using the language portlet his preferred language is updated in his profile.