Storm Person: Drupal User in Views

Would you be able to post an export of your view for testing please?

subscribing

I am having a similar issue: I want to make a set of views show tasks, tickets, projects, etc that are assigned to a user. I am trying to do it by having a path, like /user/{username}/storm/task. I found that there is a relationship to connect a storm user to a drupal user, but I can't figure out how to implement this. Any help would be appreciated.

Sean Adams-Hiett
Web Geeks For Hire
http://www.webgeeksforhire.com/

Should that be "users" and not "user" in the join statement? There's no 'user' table. Would that not then allow the statement to turn into

LEFT JOIN users user_stormperson ON stormperson.user_uid = user_stormperson.uid

In which case, there's a bug in stormperson.views.inc on line 148

  $data['stormperson']['user_uid'] = array(
    'title' => t('Drupal User'),
    'help' => t('Storm Person -> Drupal User'),
    'relationship' => array(
      'base' => 'user',
      'field' => 'uid',
      'handler' => 'views_handler_relationship',
      'label' => t('Person -> User'),
    ),
  );

Should read

  $data['stormperson']['user_uid'] = array(
    'title' => t('Drupal User'),
    'help' => t('Storm Person -> Drupal User'),
    'relationship' => array(
      'base' => 'users',
      'field' => 'uid',
      'handler' => 'views_handler_relationship',
      'label' => t('Person -> User'),
    ),
  );

This is as per #5.

Hi!
Can you please explain how to create a view to display tasks or project that are assigned for logged in users? I'm busting my head over that all morning.

Thanks! :)

I haven't been able to do it without involving some PHP code in a default argument value. Not really the greatest way to do it.

The tricky part in all this is that Projects, Tasks, Tickets, whatever are nodes related to Teams or Person nodes. A person node is related to a project as well as a team can be related to a project. And lets not forget that an Organization can be a member of a team, which has Persons which can be related to a user...

But the current user is only related to a person directly. But a user can be related to a person which is part of a team which is assigned a task, ticket, etc...

Making Views do the complete series of joins (using relationships) to get that data isn't easy to wrap your head around (my brain hurts just writing about it). Let alone getting the views api to do what I want it to do. But hopefully changing up the Views definitions a little can make it easier. And if not, then a custom views filter handler might be in order.

Of course as long as juliangb is ok with the changes. It's his module after all.

I'd like to get Storm to the point where a user can download and use views without any custom php code - however, this should be tackled in separate issues.

Committed to 2.x, retest on 1.x.

#6: storm--1018448-6.patch queued for re-testing.

Committed to 1.x.

can u tell me how you have been able to do this with custom code and default arguments? I'm running out of time and really need this to work...
thank you very much

This is what we currently use. It's not perfect as it doesn't take into consideration the tasks assigned to a Team or Organizations you belong to. I'd be careful using this on a large set of users. There's no caching and we haven't had more than 4 or 5 people using our projects site at once.

Essentially, use at own risk ;-)

P.S. To avoid filling the issue queue up with comments not directly related to the issue at hand, if you need help with the view, feel free to contact me using my drupal user.

$view = new view;
$view->name = 'my_task';
$view->description = 'My Tasks';
$view->tag = '';
$view->view_php = '';
$view->base_table = 'node';
$view->is_cacheable = FALSE;
$view->api_version = 2;
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */
$handler = $view->new_display('default', 'Defaults', 'default');
$handler->override_option('fields', array(
  'project_title' => array(
    'label' => '',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'target' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'html' => 0,
      'strip_tags' => 0,
    ),
    'empty' => '',
    'hide_empty' => 0,
    'empty_zero' => 0,
    'exclude' => 0,
    'id' => 'project_title',
    'table' => 'stormtask',
    'field' => 'project_title',
    'relationship' => 'none',
  ),
  'title' => array(
    'label' => '',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'target' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'html' => 0,
      'strip_tags' => 0,
    ),
    'empty' => '',
    'hide_empty' => 0,
    'empty_zero' => 0,
    'link_to_node' => 1,
    'exclude' => 0,
    'id' => 'title',
    'table' => 'node',
    'field' => 'title',
    'relationship' => 'none',
  ),
  'taskstatus' => array(
    'label' => '',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'target' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'html' => 0,
      'strip_tags' => 0,
    ),
    'empty' => '',
    'hide_empty' => 0,
    'empty_zero' => 0,
    'exclude' => 0,
    'id' => 'taskstatus',
    'table' => 'stormtask',
    'field' => 'taskstatus',
    'relationship' => 'none',
  ),
  'datebegin' => array(
    'label' => '',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'target' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'html' => 0,
      'strip_tags' => 0,
    ),
    'empty' => '',
    'hide_empty' => 0,
    'empty_zero' => 0,
    'date_format' => 'small',
    'custom_date_format' => '',
    'exclude' => 0,
    'id' => 'datebegin',
    'table' => 'stormtask',
    'field' => 'datebegin',
    'relationship' => 'none',
  ),
  'dateend' => array(
    'label' => '',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'target' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'html' => 0,
      'strip_tags' => 0,
    ),
    'empty' => '',
    'hide_empty' => 0,
    'empty_zero' => 0,
    'date_format' => 'small',
    'custom_date_format' => '',
    'exclude' => 0,
    'id' => 'dateend',
    'table' => 'stormtask',
    'field' => 'dateend',
    'relationship' => 'none',
  ),
));
$handler->override_option('arguments', array(
  'assigned_nid' => array(
    'default_action' => 'default',
    'style_plugin' => 'default_summary',
    'style_options' => array(),
    'wildcard' => 'all',
    'wildcard_substitution' => 'All',
    'title' => '',
    'breadcrumb' => '',
    'default_argument_type' => 'php',
    'default_argument' => '',
    'validate_type' => 'node',
    'validate_fail' => 'ignore',
    'break_phrase' => 0,
    'not' => 0,
    'id' => 'assigned_nid',
    'table' => 'stormtask',
    'field' => 'assigned_nid',
    'validate_user_argument_type' => 'uid',
    'validate_user_roles' => array(
      '2' => 0,
      '3' => 0,
      '6' => 0,
      '4' => 0,
      '5' => 0,
    ),
    'relationship' => 'none',
    'default_options_div_prefix' => '',
    'default_argument_fixed' => '',
    'default_argument_user' => 0,
    'default_argument_php' => 'global $user;
$result = db_query(\'SELECT nid from stormperson WHERE email LIKE "\'.$user->name.\'%"\');
$row = db_fetch_array($result);
return $row[\'nid\'];',
    'validate_argument_node_type' => array(
      'stormperson' => 'stormperson',
      'stormexpense' => 0,
      'storminvoice' => 0,
      'stormnote' => 0,
      'stormorganization' => 0,
      'stormproject' => 0,
      'stormtask' => 0,
      'stormteam' => 0,
      'stormticket' => 0,
      'stormtimetracking' => 0,
      'book' => 0,
      'environment' => 0,
      'page' => 0,
      'webform' => 0,
    ),
    'validate_argument_node_access' => 0,
    'validate_argument_nid_type' => 'nid',
    'validate_argument_vocabulary' => array(
      '2' => 0,
      '1' => 0,
    ),
    'validate_argument_type' => 'tid',
    'validate_argument_transform' => 0,
    'validate_user_restrict_roles' => 0,
    'validate_argument_php' => '',
    'override' => array(
      'button' => 'Override',
    ),
  ),
));
$handler->override_option('filters', array(
  'taskstatus' => array(
    'operator' => 'not in',
    'value' => array(
      'completed' => 'completed',
    ),
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => FALSE,
      'label' => '',
    ),
    'id' => 'taskstatus',
    'table' => 'stormtask',
    'field' => 'taskstatus',
    'relationship' => 'none',
  ),
));
$handler->override_option('access', array(
  'type' => 'role',
  'role' => array(
    '3' => 3,
    '4' => 4,
    '5' => 5,
  ),
));
$handler->override_option('cache', array(
  'type' => 'none',
));
$handler->override_option('title', 'Open Tasks');
$handler->override_option('items_per_page', 0);
$handler->override_option('style_plugin', 'table');
$handler->override_option('style_options', array(
  'grouping' => '',
  'override' => 1,
  'sticky' => 0,
  'order' => 'asc',
  'columns' => array(
    'project_title' => 'project_title',
    'taskstatus' => 'taskstatus',
    'datebegin' => 'datebegin',
    'dateend' => 'dateend',
  ),
  'info' => array(
    'project_title' => array(
      'sortable' => 0,
      'separator' => '',
    ),
    'taskstatus' => array(
      'sortable' => 1,
      'separator' => '',
    ),
    'datebegin' => array(
      'sortable' => 1,
      'separator' => '',
    ),
    'dateend' => array(
      'sortable' => 1,
      'separator' => '',
    ),
  ),
  'default' => 'datebegin',
));
$handler = $view->new_display('page', 'Page', 'page_1');
$handler->override_option('path', 'my_tasks');
$handler->override_option('menu', array(
  'type' => 'none',
  'title' => '',
  'description' => '',
  'weight' => 0,
  'name' => 'navigation',
));
$handler->override_option('tab_options', array(
  'type' => 'none',
  'title' => '',
  'description' => '',
  'weight' => 0,
  'name' => 'navigation',
));
$handler = $view->new_display('block', 'Block', 'block_1');
$handler->override_option('block_description', '');
$handler->override_option('block_caching', -1);

Why is this issue re-opened?