[support] Adding an additional table to views

[Hummel, Tracey S - (thummel)]

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> [mailto:support-bounces at drupal.org] On Behalf Of Steve Kessler
Sent: Saturday, 24 January 2015 6:26 AM
To: support at drupal.org<mailto: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<mailto: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/20150124/296f55a9/attachment.html