Breaking: #76259 - Return value of AbstractDatabaseRecordList::makeSearchString changed

See forge#76259

Description

The value returned by AbstractDatabaseRecordList::makeSearchString has been adjusted.

The SQL fragment no longer includes the leading AND SQL operator and the method returns "1=1" if no search word is specified or if the table contains no searchable fields.

Impact

3rd Party extensions need to ensure that valid SQL queries are being built using the returned fragment.

Affected Installations

Installations using 3rd party extensions that use AbstractDatabaseRecordList::makeSearchString and expect the leading AND.

Migration

Migrate your code to use the Doctrine QueryBuilder where the AND is no longer needed or prepend the missing AND before using the return value.