Views Join definition wrong (activity_personal_targets)

Created on 16 November 2011, almost 14 years ago
Updated 29 October 2025, 6 days ago

Hi folks,

since views had a recent update, and closed a bug, a bug of activity showed up.

the join definition has a

  $data['activity_personal_targets']['table'] = array(
    'group' => t('Activity'),
    'join' => array(
      'activity' => array(
        'type' => 'LEFT',
        'left_field' => 'aid',
        'field' => 'aid',
        'extra' => array(
          array(
            'value' => '***CURRENT_USER***', // grab the personal message
            'numeric' => TRUE,
            'field' => 'uid',
          ),
          array(
            'value' => '***ACTIVITY_LANGUAGE***',
            'field' => 'language',
          ),
        ),
        'table' => 'activity_targets',
      ),
    ),
  );

so the 'numeric => TRUE' forces the views module to run an intval() on the '***CURRENT_USER***' which in result is 0.

so only the global anonymous message will get shown, not the personalized.

so please remove the 'numeric' line!

🐛 Bug report
Status

Closed: outdated

Component

Code

Created by

🇦🇹Austria neurovation.kiwi

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.

No activities found.

Production build 0.71.5 2024