View filter for Message text

Created on 26 January 2020, over 4 years ago
Updated 16 January 2024, 5 months ago

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] => %% )

✨ Feature request
Status

Closed: won't fix

Version

1.0

Component

Code

Created by

πŸ‡¨πŸ‡­Switzerland gagarine

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Production build 0.69.0 2024