drupal view2用于JOIN的views_query_alter

发布于 2024-12-07 18:35:21 字数 682 浏览 1 评论 0原文

我正在尝试更改 drupal view-2 查询，基本上是想再添加一张表。我可以使用 hook_views_query_alter() 更改查询的 where 子句，但不知道如何再加入一张表。

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'];
        }
    }

为什么我要这样做 - 如果关系选项卡在用于联接表的视图中可用，但在我的情况下，我要联接的表包含不是节点引用的字段，但字段名称及其值匹配与视图表表之一。

有谁知道如何在views_query_alter()中执行JOIN。

原文

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().

分享到QQ

分享到微博