[support] Adding an additional table to views

[Yasni]

There is only one relationship. I think it has something to do with pulling
an address from Billing in Drupal Commerce but it didn't matter what
permissions I gave things either within the roles or within view it rendered
the display without data (some message I can't remember). No issues when I
was logged in. 

Anyway I've thrown the idea away. Now the site is live I'm seeing a few
issues but I'm going to leave it until I use this config again rather than
muck up the data or the site now it is live.

 

Yani 

 

From: support-bounces at drupal.org [mailto:support-bounces at drupal.org] On
Behalf Of Hummel, Tracey S - (thummel)
Sent: Sunday, 25 January 2015 2:37 AM
To: support at drupal.org
Subject: Re: [support] Adding an additional table to views

 

I find that happens when I've added an incorrect relationship.  Make sure
you remove any relationships the view does not need. 

 

Tracey

 

--------------------
Tracey Hummel

IT Director

Sagent Labs

tracey at sagentlabs.com

  _____  

From: support-bounces at drupal.org [support-bounces at drupal.org] on behalf of
Yasni [akayani at aapt.net.au]
Sent: Saturday, January 24, 2015 5:27 AM
To: support at drupal.org
Subject: Re: [support] Adding an additional table to views

Too easy but it has created a problem I didn't notice.

 

The information is now not available to all users. Requires an admin log on
to see.

 

It doesn't seem to be resolved via any changes in permissions. Is there
something special that happens here?

 

Yani

 

From: support-bounces at drupal.org [mailto:support-bounces at drupal.org] On
Behalf Of Yasni
Sent: Saturday, 24 January 2015 7:09 PM
To: support at drupal.org
Subject: Re: [support] Adding an additional table to views

 

Thanks... I watched this http://nodeone.se/en/relation-and-views-pt-1 and
with that bit of encouragement sorted it.

 

Yani 

 

From: support-bounces at drupal.org [mailto:support-bounces at drupal.org] On
Behalf Of Steve Kessler
Sent: Saturday, 24 January 2015 6:26 AM
To: support at drupal.org
Subject: Re: [support] Adding an additional table to views

 

This should not be too bad. You need to make a relationship in views with
(probably) the Commerce Order. Once you add the relationship you can then
use the fields from table in the relationship. 

 

-Steve 


On Friday, January 23, 2015, Yasni <akayani at aapt.net.au> wrote:

Hi,

I've created a donation system using CRM and Drupal Commerce.

I have a view for the most recent 10 donations. All the details I need are
being returned from the CRM table.

Now after the site has gone live the client recognises that in this list of
10 recent donation is missing the Country.

That is stored in Drupal commerce as the billing address and not CRM.

What I need is a few really good references for how to add additional tables
to views. And likely a bit of advice on the complexity of doing this.

Yani



--
[ Drupal support list | http://lists.drupal.org/ ]



-- 
Steve Kessler

Owner and Lead Consultant 

Denver DataMan, LLC 

303-587-4428

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20150125/d6914e03/attachment-0001.html