Hi,
I would like to filter a view based on the message text content (with token rendered) using a "contain" filter.
As a workaround, I tried the the global combined filter but I got this error:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'message.get_text' in 'where clause': SELECT message_field_data.langcode AS message_field_data_langcode, message_field_data.mid AS mid, users_field_data_message_field_data.uid AS users_field_data_message_field_data_uid FROM {message_field_data} message_field_data LEFT JOIN {users_field_data} users_field_data_message_field_data ON message_field_data.uid = users_field_data_message_field_data.uid INNER JOIN {message} message ON message_field_data.mid = message.mid WHERE (CONCAT_WS(' ', message.get_text) LIKE :views_combine) ORDER BY message_field_data.mid DESC LIMIT 31 OFFSET 0; Array ( [:views_combine] => %% )
Closed: won't fix
1.0
Code
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.