Sorting catalog by title in multi-language OMP 3.1.1. installations

carola · September 12, 2018, 9:12am

Hi,

in multilanguage OMP 3.1.1 installations, sorting by title does not work.

pkp/omp/blob/omp-stable-3_1_1/classes/monograph/PublishedMonographDAO.inc.php#L473


		}

		if ($featuredOnly) {
			$params[] = $assocType;
			$params[] = $assocId;
		}

		if ($newReleasedOnly) {
			$params[] = $assocType;
			$params[] = $assocId;
		}

		$result = $this->retrieveRange(
			'SELECT	' . ($searchText !== null?'DISTINCT ':'') . '
				ps.*,
				s.*,
				COALESCE(f.seq, ?) AS order_by,
				' . $this->getFetchColumns() . '
			FROM	published_submissions ps
				JOIN submissions s ON ps.submission_id = s.submission_id
				' . $this->getFetchJoins() . '

best,
Carola

astevens · September 21, 2018, 1:39pm

Hi @carola,

Please file this as an issue on Github.

Best,
Amanda Stevens
Public Knowledge Project Team