This tag is for questions about relationships used with the Views module.

learn more… | top users | synonyms

0
votes
1answer
23 views

Suppress VIEW on a specific URL

There are two URL's on which I want to suppress a VIEW , Below are the urls's : http://mysite.com/drupal/?q=searchpanel&body_value= http://mysite.com/drupal/?q=searchpanel How can I stop a view ...
-2
votes
0answers
17 views

Why no taxonomy in relationship? [closed]

Why not dictionary taxonomy in relationship. There are only
0
votes
1answer
14 views

How to use GROUP BY and SUM in Views table?

I have custom entity "product". It's base table is "product" and it's primary/id key is "entity_id". I have created all Views definitions for this entity. Additionally I have another table called ...
1
vote
1answer
15 views

General or specific field names [closed]

I have been creating a site for company forms (quote forms, update forms, request forms) with the goal of reducing the amount of paper that the office uses. My content types started off with very ...
0
votes
0answers
9 views

View relationship apply to fields and not the view

So I have a few node references and am using Corresponding node references to link both nodes to each other, I'm using Drupal 7. The node references are referencing the same content type in which it ...
0
votes
1answer
25 views

When adding a relationship to the author, I'm unable to see any custom field

I'm trying to get the username of a blog last poster; I created a view that shows the blog's fields. If I click on "Add field" I can see all custom fields. However, when I add a relationship for ...
1
vote
2answers
31 views

Display a block based on the term reference field of the current node

What I'm trying trying to do sounds fairly simple, but I can't get my head around it. I'm having 2 taxonomy vocabularies: machinery and batteries (both created with NAT for all that matters), and 2 ...
0
votes
0answers
22 views

Drupal 7 views contextual filters taxonomy name 2 fields using same vocabulary

I have a content where two fields using the same vocabulary. I want to show nodes related content filtered by the these fields. I try with relation Relationships content:field_1 (term from ...
0
votes
1answer
14 views

Views: show nodes that share taxonomy term with user

I have a content type requests with the taxonomy field categories. I have added categories to my user's profile as well. I need to create a view that displays all the requests that have category ...
1
vote
0answers
29 views

Why adding a relationship breaks my view?

I have a Drupal 7.26 site with the latest Organic Groups module. Every user of the site will be in one group, and one group only. My groups have two different group content types -- schools and ...
1
vote
1answer
45 views

view query alter : Subselects/query don't work with out brackets

I was trying to alter a view query with a subselect that looks like: $subquery1 = (db_select('users_roles', 'r') ->where('r.uid = users_node__users_roles.uid and r.rid=10')); ...
2
votes
1answer
21 views

How to sort a view on a Drupal Commerce product image field?

I have several Drupal Commerce views. I want to sort on whether the image is "interesting", which means not equal to no-image-available.png. I have added "Indexed Commerce Product: Image » The image ...
0
votes
0answers
10 views

relations endpoints table only lists one endpoint

We have some relations. We list the relations using the prebuild /relations view. Until today we got a list with all relation types and after selecting one of them, we got all relations of that type ...
1
vote
0answers
24 views

Create relationship in views with custom entity

I have a custom entity (emtr) with a property called unit_tid (that relates to a taxonomy term). When I create a view of my custom entity I want access to the fields associated with the related ...
0
votes
0answers
30 views

This Entity Reference View Isn't Working Right

Here's my situation: I have a node type for "School" and node type for "Classroom." In the School node type, I have an Entity Reference field for "Classroom," and vice-versa (i.e. I have a "School" ...
0
votes
0answers
16 views

How to extend entityreference field by another custom field?

I want to add another field, which needs to be accessible by views (for display and ordering), to the entityreference table field_data_field_FIELDNAME. Structure of that table is: entity_type ...
0
votes
2answers
23 views

Duplicated results using fields from relation File Usage: file

I have a content type with a field image and a field file. I made a simple view to get all items of that content. I included in my view a relation ¨File Usage: File¨ to get some data like file size, ...
0
votes
0answers
32 views

How to create a Users view and group them using their field

I need to do something looking very easy, but I cannot get it done. I have the users with many fields such as: -Member name -Member Photo -Company -Institution -etc... Then I have a content type ...
1
vote
2answers
42 views

How to add a view inside a view?

I have 2 groups of blocks in a view, I would like to join both of them in one view, showing the first block (I have the groups all linked one to the other). I did download Views Field View but I can ...
0
votes
1answer
23 views

Definition join on field and where other field has value

I am building a views plugin and I need it to do this: LEFT JOIN my_table mt ON (mt.nid = node.nid AND mt.value = 'some argument'); I have found documentation for creating a views plugin, but all ...
0
votes
0answers
25 views

Node auto term (NAT) and contextual filters in views

briefly: I'd like to filter a view by taxonomy. As far as good. Simple task, I know. But the taxonomy is created by the node auto term (NAT) module. This seems to be an issue. What did I do? I have ...
0
votes
1answer
13 views

Open a specific View node with a link in an image

I'm stumped. I'm not even sure how to ask the right questions to search out an answer. What I have is a View of User Account images in a gallery. So far so good. I have another view of all User ...
0
votes
1answer
26 views

“Organic groups: Group node” equivalent?

I have several Drupal 6 views that use the "Organic groups: Group node" relationship. Does anyone know what the equivalent relationship in Drupal 7 is? Trying to set this up in Drupal 7 and the ...
0
votes
0answers
43 views

How to relate two different vocabularies in a view

i have two vocabularies Course and Tag like below, 1.) Course: Engineering Medicine 2.) Tag: Engineering Management Medicine and i have content type named school ...
0
votes
1answer
36 views

Multiple Webforms in one View

I have 4 webforms on a site and I would like to be able to display the data from each of those in a table using a view. Each of the forms has a "First Name" "Last Name" "Phone Number" and "Email ...
0
votes
1answer
47 views

How can I reference two field without nid or uid?

I have two content types: 1.- Equipment and 2.- Configuration The First CT has the following fields: Title : is equipment id with autocomplete module serial and hide for not capture. model : Text ...
0
votes
0answers
9 views

How to create a view for Group and its latest content [duplicate]

I have installed Organic Groups on my website. I have a content type "Members Group" which is recognized by OG as "Group". Each of these groups have some contents attached to them named "Group ...
0
votes
0answers
27 views

DIsplay related nodes if current node has all of the tags that the other node has plus some others

Creating related nodes block in Drupal 7 is quite easy with Views and contextual filter. There you can choose an option - display related nodes that have any or all the tags that the current node has. ...
0
votes
1answer
32 views

Using Entity Registration, how can I create a view that shows all the events that a user has NOT registered for?

Using the Entity Registration module's built-in Views integration, I was easily able to create a view showing the events that the logged-in user has registered as attending. Content type: Event Date ...
0
votes
0answers
26 views

Referenced entity is output each time instead of once

I use out-of-the-box articles content type to which a I added en entity reference field so I can assign multiple users to that article. I used this reference in order to be able to display multiple ...
1
vote
1answer
26 views

Does Views RSS display deals with relationship

I have a content type "Event" which has a relationship with the content type "Category", via the node reference field 'category_ref'. The "Category" content has a field "Image". I have figured out ...
1
vote
2answers
134 views

How to filter a view on a property of optional entityreference-related content (table join / views relationship)?

Consider this example: we have three content types: Concept, Language, and Word. The Word content type has two entityreference fields: field_concept references concept nodes, and field_language ...
0
votes
1answer
23 views

Hand generate views relationship

Here's the setup: the previous site builder linked a large quantity of assets to particular nodes. Now that I'm on board, we want to expand those nodes into larger sections, but we need the linked ...
0
votes
1answer
48 views

Views entity reference field

I am trying to create a news content type which can display related content. In the news content type I have an Entity Reference field with unlimited values, which is used to select the nodes which ...
0
votes
1answer
36 views

list of parent nodes with a list of child referring nodes

I would like to make a list of all parent nodes and under each parent display a list of child nodes that are referencing parent node. Something like drupal.org modules page, except in my case this is ...
0
votes
0answers
14 views

Relationship that links additional URL's to node?

Sorry if the title is difficult to understand. I have a lot of fields across my site that are linked to specific nodes. Problem is, those nodes are out of date and we are creating additional nodes. ...
0
votes
0answers
31 views

I have multiple profiles using profile 2 per user need to create view showing data from 2 profiles but only one line per user

Ok, I am creating a website for a volunteer agency which will have each member of the agency having their own log in to our site and a set of profiles made based upon important key data based upon the ...
0
votes
0answers
8 views

Get Term Ref From Node Referance

Hello after messingabout with drupalfor about the past 8 years im finally making my first 'shop' type of website. Ive been scratching my head the last week or so trying to make it as easy for me to ...
0
votes
1answer
215 views

drupal contextual filter (URL argument) OR operator

So, I have a view which filters content from 3 different content types: Books, photos and articles and outputs in the same view. All three content types have an independent "issue number" field. The ...
0
votes
2answers
52 views

How can I filter for the UID of the node on a view?

I want to have a relationship between the the author of the node ($uid) and the view results, seems straightforward but I'm not getting it. On the view, I've added the relationship to content:author ...
0
votes
1answer
633 views

Hierarchical Select with taxonomy in Views

I have a generic content which can be differencied by a taxonomy term. Then i've created to views filtered by a taxonomy. I want to enable a second filter, exposed , based on the taxonomy, depending ...
0
votes
0answers
44 views

How to add multi-level filters?

I have a group with a custom Boolean field to specify if the group(og group) is public or private. I have a content type as group content type for this group. People can comment on the contents of ...
0
votes
1answer
24 views

Files View, How to display Images related to Media Gallery?

I have created a view in views to show files of type image. Under fields I have selected File Rendered. Now my view is displaying all the images. The problem is this that I only want to display ...
0
votes
0answers
36 views

Drupal 6-Define hook_views_data for custom table has 2 relationships user and node

I define new table has following columns hid : primary nid uid text So now I just want to write hook_views_data in my custom module, so this view will connect with user and node table I wrote like ...
0
votes
1answer
75 views

How can the items in a field collection view be restricted to those of its containing entity?

I have an entity type with a field collection that I want to display as table within the main entity display. I have created the view as a block view and added it as a block field using Display Suite. ...
0
votes
0answers
42 views

Views entity reference relationship problem

I have two content type. 1. Organization 2. Job Fields in Organization content type : Title Organization URL Organization address. Fields in Job content type : 1. Job title 2. Job ...
0
votes
0answers
121 views

How to pass a token to Webform from a node relationship?

Hi I have 2 node types which are related via a view, one contains an email field which I want to pass to a webform via a token. The token is available in the webform setup but doesn't show on the ...
2
votes
1answer
138 views

Contextual filter and exposed filter related

I am facing a real problem and i can't manage to solve it. I have some checkboxes in user profile based on a vocabulary. I want to display all articles that have this tags in a view . If user wants ...
3
votes
1answer
57 views

How to implement properly a view of nodes displaying other referenced nodes with no duplications?

I know that this has been asked several times with different variations, but I cannot seem to find an optimal solution, so here we go again: I have a content type 'Parent' and a content type 'Child'. ...
0
votes
0answers
26 views

How to make relationships & contextual filters

I'm using a map module (Gmap), and i need a view that on the product's page that will show me on the map only the current product location. How i should set-up the relationship & contextual ...