drupal view2 views_query_alter for JOIN

Question

i'm trying to alter drupal view-2 query, basically want to add one more table. I'm able to alter the where clause of query using hook_views_query_alter() but don't know how to join one more table.

function module_views_query_alter(&$view, &$query) {
        if ($view->name == 'view1_name') {
                $query->where[0]['args'][] = 'SOMETEXT';
                $query->where[0]['clauses'][] = "QUERY";
        }

        if($view->name = 'view2_name'){
              $query->table_queue['content_type_sold_product'];
              $query->tables['content_type_sold_product'];
        }
    }

Why do i want to do this - if relationship tab is available in view that is used to join the table, but in my case table which i want to join contains the field that is not a node-reference however field name and its value matches with one of the view table table.

Does anyone know how to perform JOIN in views_query_alter().

Community · Accepted Answer · 2017-05-23 11:55:39Z

2

Seems there are two different ways you can do this, see these links:

Adding a JOIN statement in hook_views_query_alter()

Add Table Join, Where, and Order By to Views Query in views_query_alter()

edited May 23, 2017 at 11:55

CommunityBot

11 silver badge

answered Oct 4, 2011 at 20:42

Clive

36.9k8 gold badges89 silver badges113 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vikas Naranje · Accepted Answer · 2011-10-11 11:04:34Z

2

Giving Answer to own question

fortunately i found these links

http://drupalmodules.com/module/reverse-node-reference module enhances views with reverse relationships for node reference fields.

you may also need http://drupal.org/project/noderelationships

answered Oct 11, 2011 at 11:04

Vikas Naranje

2,4126 gold badges31 silver badges41 bronze badges

Collectives™ on Stack Overflow

drupal view2 views_query_alter for JOIN

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related