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

learn more… | top users | synonyms

0
votes
0answers
18 views

Two different relationships and one view

I would need to combine two content types into one view. Well this is easy but where it gets more tricky is that other content type would need to user relationship that connects to another (third) ...
0
votes
0answers
12 views

How to stop multiple records returned on reverse node reference

I am using the 'references' module and the 'views' module (D7). I have two custom content types - 'Universities' and 'Courses'. The Universities content type has a custom field (field_courses) which ...
0
votes
0answers
12 views

how can i send a parameter to drupal view thru session?

i am new to Drupal and views. scenario: i have a view which uses a group entity for a logged in user. there are two users type "admin" and "customer" both sharing a view. with filter criteria as ...
0
votes
2answers
31 views

List content referenced to another content type

I'm creating a simple site which has shows and episodes. I have created both content types and I added the entity reference field to the episode type. The episode would reference a show which it ...
0
votes
1answer
14 views

Views Exposed Filter Sort on Entity based on Term Reference Field from Entity Reference Relationship

I've been playing around with Views exposed filters on an entity. I have so far been able to create a relationship to another entity through an Entity Reference, and exposed the fields belonging to ...
1
vote
2answers
35 views

display the entities that are referencing the current entity with views

I have a content type "reservation" and another "room" this is a simple booking app that Im making from stracht "just for learning purposes" Im using entity reference for make the reservations, so I ...
0
votes
1answer
31 views

How to show the number og members views members views

How do you show the number of members in a group using views please? I had a look at this post bu unfortunately the relationship have changed in drupal og 7.2 How to show the count of members that ...
0
votes
1answer
30 views

Show users pictures who have flagged a node

I have a event node and a flag to join the event. I want to show the user pictures who have flagged "Join event" This is what I have done so far 1.Created a Node View 2.Added a relationship Flags: ...
0
votes
1answer
30 views

views with multiple contextual filters - should return data only when both or any one filter is present

Views of content is having two contextual filter. For some reason node object is available to views so it is passing through url's 7th argument. 1.Content: Has taxonomy term ID Configuration: Php ...
0
votes
0answers
30 views

D7/Views3: Filter “Parent Nodes” by “Child: Author ID” while still displaying Parent Nodes that don't have Children

I'm able to successfully create a view of parent nodes with referenced children that is filtered by "Child: Author ID" through a "Referencing entity" relationship. My question is would it possible to ...
0
votes
1answer
33 views

Drupal Views Non-admin user permissions

I have a view that seeks to find users that have not filled in a form on the site which is a personal profile. It works correctly for admin user, but not for other user roles although the permissions ...
0
votes
1answer
30 views

Displaying uploaded files in jCarousel

Preface -- I'm a newbie with drupal and have watched too many youtube flicks on jCarousel and slideshows. So totally confused. My question: I've created a web form in drupal 7 and would like to do a ...
0
votes
1answer
29 views

Exclude content referenced by content whose author is current logged in user

I try to solve question - answer scenario with views. 2 content types: question and answer. (answer is connected to question by entityreference) User can check themes of interests (taxonomy) in ...
0
votes
0answers
15 views

Drupal Product Display List view- selecting image from variation with lowest delta

I am currently trying to set up a catalog listing for commerce product display nodes. Each display has several selectable product variations referenced. Using a T-Shirt example, think all shirts ...
0
votes
1answer
17 views

Filter content in view by user field

I'm having problems filtering a view. This is my case: When a user registers he has to select some suppliers of a list (This is a term reference as a field of my user). A user can also create a ...
0
votes
3answers
24 views

Create a view pulling in content that matches user profile

Im am trying to create a view that pulls in content that matches to the user. This is done with two taxonomy fields that are added to the user profile and the content type. These are job role and ...
0
votes
0answers
13 views

Organic Groups - How to create view to fetch groups with nested relationships

I have three types of groups: Main group Course (which is a child of Main Group) Tutorial (which is a child of a Course group) I want to create a view that will pull in all tutorials that belong ...
1
vote
1answer
36 views

How can I show the root taxonomy term in a view field in Drupal 7?

I have a view with a taxonomy term field called Location in Drupal 7 and I want to show the first / root level of the term hierarchy in each view item field, aka the Country level. My Location field ...
0
votes
1answer
22 views

Use entity relationship to exclude records on view

I have a content type, lets say PRODUCT I have another type, PURCHASE, which points to PRODUCT with an entity reference It is simple using views relationships to get PRODUCTS that have PURCHASE ...
0
votes
1answer
13 views

Is there a way to resolve a list of references in a view without cloning entire rows of data?

I'm playing around with the drupal views and reference relationships. I have an entity of type A that has a reference to entity of type B, and a list of references to entities of type C. Reached this ...
0
votes
2answers
38 views

Can node refferences be automatically resolved in a view?

We are using drupal for data management for a web application. We're using the web-service api to get data from drupal views and use it on our app. We are completely depended on views fetched via ...
0
votes
0answers
20 views

Views relationship from nid to gid

I currently have a content type that is keyed by its organic group's gid, but I am trying to make a contextual filter based on nid. Is there is relationship to get the gid from the nid directly? I ...
0
votes
0answers
21 views

Add below each node type A the related nodes of type B

How can I do the following: Display all nodes of content type A (done!) Add underneath each node A fields of related nodes of type B (???) I use Drupal 7 and Views 3. This post suggests the use of ...
0
votes
0answers
22 views

How to display Commerce Pricing Attributes in Views?

We are using the Commerce Pricing Attributes module to create products with price-modifying attributes. I have set up a view to display line items with attached pricing attribute fields, but the ...
2
votes
1answer
35 views

Sorting entities in a view by a field in a 'sibling' entity

At its most general, my question is how you can sort entities in a view by a field in a related entity. This is best illustrated with a lengthy example which is more specific, though still quite ...
3
votes
0answers
56 views

Views query building internals

I have looked at the source code, briefly, and the problem is that the module is a complex "beast" that relies heavily on the core's API which I am not currently familiar with. I have a kind of ...
1
vote
1answer
40 views

How to create heirarchical taxonomy menu/list using VIEWS

How can I create a view of taxonomy terms for a content type (Story and Page) and display it to a block with parent and child relationship? What I want is to take a "Taxonomy Term" based on "Content ...
0
votes
2answers
41 views

View with empty filter result visible only to admin user

So I am new to Drupal 7, just so you know. Here is my problem: I created a view displaying all registered users ("members"). Following a tutorial, I managed to display their user pic, name, date ...
0
votes
1answer
31 views

Relationships block other content type from showing

I have this views_slideshow and its supposed to show two content types, but shows only one. One is simple content type with image field (the one that is not getting showed) and other is commerce ...
0
votes
0answers
20 views

Taxonomy Term Values In Separate Columns in a View

I have a view based on users with a certain role. Users with that role have two taxonomy vocabularies that appear in their profile. In the view, I am showing several fields from the user profile, ...
0
votes
1answer
44 views

Views - adding relationship adds duplicate row for each relation

Sorry if the title is a little vague, I don't know how else to describe it in the space. I have a view that shows Drupal Commerce orders. I am trying to add the SKUs of each product in an order as a ...
0
votes
1answer
27 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 ...
0
votes
1answer
67 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
18 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
13 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
47 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
3answers
54 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
49 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
19 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
35 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
83 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
38 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 ...
1
vote
0answers
62 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
54 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
29 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
71 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
46 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
50 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
32 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
39 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 ...