<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style>
<!--
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
@font-face
{font-family:Tahoma}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif"}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif"}
span.EmailStyle17
{font-family:"Calibri","sans-serif";
color:#1F497D}
span.EmailStyle18
{font-family:"Calibri","sans-serif";
color:#1F497D}
span.BalloonTextChar
{font-family:"Tahoma","sans-serif"}
.MsoChpDefault
{font-size:10.0pt}
@page WordSection1
{margin:72.0pt 72.0pt 72.0pt 72.0pt}
-->
</style><style type="text/css" id="owaParaStyle"></style>
</head>
<body lang="EN-AU" link="blue" vlink="purple" fpstyle="1" ocsi="0">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">I find that happens when I've added an incorrect relationship. Make sure you remove any relationships the view does not need.
<div><br>
</div>
<div>Tracey<br>
<div><br>
<div style="font-family:Tahoma; font-size:13px">
<div style="font-family:Tahoma; font-size:13px">
<div style="font-family:Tahoma; font-size:13px">
<div style="font-family:Tahoma; font-size:13px">
<div style="font-family:Tahoma; font-size:13px">
<div style="font-family:Tahoma; font-size:13px"><font size="2" style="font-family:Arial"><span style="font-size:10pt">--------------------</span></font><br>
<font size="2" style="font-family:Arial"><span style="font-size:10pt">Tracey Hummel</span></font></div>
<div style="font-family:Tahoma; font-size:13px"><span style="font-family:Arial; font-size:13.6000003814697px"><i>IT Director</i></span></div>
<div style="font-family:Tahoma; font-size:13px"><span style="font-family:Arial; font-size:13.600000381469727px">Sagent Labs</span></div>
<div style="font-family:Tahoma; font-size:13px">tracey@sagentlabs.com</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div style="font-family: Times New Roman; color: #000000; font-size: 16px">
<hr tabindex="-1">
<div id="divRpF907342" style="direction: ltr;"><font face="Tahoma" size="2" color="#000000"><b>From:</b> support-bounces@drupal.org [support-bounces@drupal.org] on behalf of Yasni [akayani@aapt.net.au]<br>
<b>Sent:</b> Saturday, January 24, 2015 5:27 AM<br>
<b>To:</b> support@drupal.org<br>
<b>Subject:</b> Re: [support] Adding an additional table to views<br>
</font><br>
</div>
<div></div>
<div>
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D">Too easy but it has created a problem I didn’t notice.</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D">The information is now not available to all users. Requires an admin log on to see.</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D">It doesn’t seem to be resolved via any changes in permissions. Is there something special that happens here?</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D">Yani</span></p>
<p class="MsoNormal"><a name="_MailEndCompose"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D"> </span></a></p>
<div>
<div style="border:none; border-top:solid #B5C4DF 1.0pt; padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt; font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt; font-family:"Tahoma","sans-serif""> support-bounces@drupal.org [mailto:support-bounces@drupal.org]
<b>On Behalf Of </b>Yasni<br>
<b>Sent:</b> Saturday, 24 January 2015 7:09 PM<br>
<b>To:</b> support@drupal.org<br>
<b>Subject:</b> Re: [support] Adding an additional table to views</span></p>
</div>
</div>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D">Thanks... I watched this
<a href="http://nodeone.se/en/relation-and-views-pt-1" target="_blank">http://nodeone.se/en/relation-and-views-pt-1</a> and with that bit of encouragement sorted it.</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D"> </span></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D">Yani
<br>
<br>
</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D"> </span></p>
<div style="border:none; border-top:solid #B5C4DF 1.0pt; padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt; font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt; font-family:"Tahoma","sans-serif"">
<a href="mailto:support-bounces@drupal.org" target="_blank">support-bounces@drupal.org</a> [<a href="mailto:support-bounces@drupal.org" target="_blank">mailto:support-bounces@drupal.org</a>]
<b>On Behalf Of </b>Steve Kessler<br>
<b>Sent:</b> Saturday, 24 January 2015 6:26 AM<br>
<b>To:</b> <a href="mailto:support@drupal.org" target="_blank">support@drupal.org</a><br>
<b>Subject:</b> Re: [support] Adding an additional table to views</span></p>
</div>
<p class="MsoNormal"> </p>
<p class="MsoNormal">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. </p>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">-Steve </p>
<div>
<p class="MsoNormal"><br>
On Friday, January 23, 2015, Yasni <<a href="mailto:akayani@aapt.net.au" target="_blank">akayani@aapt.net.au</a>> wrote:</p>
<p class="MsoNormal">Hi,<br>
<br>
I've created a donation system using CRM and Drupal Commerce.<br>
<br>
I have a view for the most recent 10 donations. All the details I need are<br>
being returned from the CRM table.<br>
<br>
Now after the site has gone live the client recognises that in this list of<br>
10 recent donation is missing the Country.<br>
<br>
That is stored in Drupal commerce as the billing address and not CRM.<br>
<br>
What I need is a few really good references for how to add additional tables<br>
to views. And likely a bit of advice on the complexity of doing this.<br>
<br>
Yani<br>
<br>
<br>
<br>
--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]</p>
</div>
</div>
<p class="MsoNormal"><br>
<br>
-- <br>
Steve Kessler</p>
<div>
<p class="MsoNormal">Owner and Lead Consultant </p>
</div>
<div>
<p class="MsoNormal">Denver DataMan, LLC </p>
</div>
<div>
<p class="MsoNormal">303-587-4428</p>
</div>
<p class="MsoNormal"> </p>
</div>
</div>
</div>
</div>
</div>
</body>
</html>