LPS-29962 Add utility method to replace status condition in custom sqls
LPS-29962 We have to use the finder because it has additional logic
LPS-29962 Apply to JournalArticleFinder and the JournalArticle services
LPS-29962 Apply to JournalFolderFinder and the JournalFolder services
LPS-29962 Regen
LPS-29962 Rename "table" var to "tableName", search for "String tableName", we have lots of those already. There's also no need to use the "concat" for static vars since those are only used once. Concats are helpful on repeated dynamic calls because it'll happen many times.
LPS-29962 Manually remove unused index
LPS-29962 Sort finder to match in journal.xml (that one's in the right order because userId comes before classNameId)
LPS-29962 Tab