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@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Hummel, Tracey S - (thummel) Sent: Sunday, 25 January 2015 2:37 AM To: support@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@sagentlabs.com
_____
From: support-bounces@drupal.org [support-bounces@drupal.org] on behalf of Yasni [akayani@aapt.net.au] Sent: Saturday, January 24, 2015 5:27 AM To: support@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@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Yasni Sent: Saturday, 24 January 2015 7:09 PM To: support@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@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Steve Kessler Sent: Saturday, 24 January 2015 6:26 AM To: support@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@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/ ]