Re: Adding an additional table to views

--===============7289061861854435110==
Content-Type: multipart/alternative; boundary=047d7b66f93b6587cd050d579856

--047d7b66f93b6587cd050d579856
Content-Type: text/plain; charset=UTF-8

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 <[email protected]> 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

--047d7b66f93b6587cd050d579856
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

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 us=
e the fields from table in the relationship.=C2=A0<div><br></div><div>-Stev=
e=C2=A0<span></span><br><div><br>On Friday, January 23, 2015, Yasni &lt;<a =
href=3D"mailto:[email protected]">[email protected]</a>&gt; wrote:<br><=
blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px=
 #ccc solid;padding-left:1ex">Hi,<br>
<br>
I&#39;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 table=
s<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=3D"http://lists.drupal.org/" target=3D"_bla=
nk">http://lists.drupal.org/</a> ]<br>
</blockquote></div></div><br><br>-- <br>Steve Kessler<div>Owner and Lead Co=
nsultant=C2=A0</div><div>Denver DataMan, LLC=C2=A0</div><div>303-587-4428</=
div><br>

--047d7b66f93b6587cd050d579856--

--===============7289061861854435110==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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