Re: Adding an additional table to views
"Hummel, Tracey S - (thummel)" <[email protected]> Sat, 24 Jan 2015 16:36:46 +0000
| Newsgroups | gmane.comp.php.drupal.support |
|---|---|
| Message-ID | <E0483D40280CFA4E9E18C59101FB9BE94108769C@SAWYERISLAND.catnet.arizona.edu> |
--===============2228442712588614123== Content-Language: en-US Content-Type: multipart/alternative; boundary="_000_E0483D40280CFA4E9E18C59101FB9BE94108769CSAWYERISLANDcat_" --_000_E0483D40280CFA4E9E18C59101FB9BE94108769CSAWYERISLANDcat_ Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable I find that happens when I've added an incorrect relationship. Make sure y= ou remove any relationships the view does not need. Tracey -------------------- Tracey Hummel IT Director Sagent Labs [email protected] ________________________________ From: [email protected] [[email protected]] on behalf of = Yasni [[email protected]] Sent: Saturday, January 24, 2015 5:27 AM To: [email protected] Subject: Re: [support] Adding an additional table to views Too easy but it has created a problem I didn=92t notice. The information is now not available to all users. Requires an admin log on= to see. It doesn=92t seem to be resolved via any changes in permissions. Is there s= omething special that happens here? Yani From: [email protected] [mailto:[email protected]] On Beh= alf Of Yasni Sent: Saturday, 24 January 2015 7:09 PM To: [email protected] Subject: Re: [support] Adding an additional table to views Thanks... I watched this http://nodeone.se/en/relation-and-views-pt-1 and w= ith that bit of encouragement sorted it. Yani From: [email protected]<mailto:[email protected]> [mailto= :[email protected]] On Behalf Of Steve Kessler Sent: Saturday, 24 January 2015 6:26 AM To: [email protected]<mailto:[email protected]> 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 us= e the fields from table in the relationship. -Steve On Friday, January 23, 2015, Yasni <[email protected]<mailto: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 table= s 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 --_000_E0483D40280CFA4E9E18C59101FB9BE94108769CSAWYERISLANDcat_ Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable <html dir=3D"ltr"> <head> <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DWindows-1= 252"> <style>=0A= <!--=0A= @font-face=0A= {font-family:"Cambria Math"}=0A= @font-face=0A= {font-family:Calibri}=0A= @font-face=0A= {font-family:Tahoma}=0A= p.MsoNormal, li.MsoNormal, div.MsoNormal=0A= {margin:0cm;=0A= margin-bottom:.0001pt;=0A= font-size:12.0pt;=0A= font-family:"Times New Roman","serif"}=0A= a:link, span.MsoHyperlink=0A= {color:blue;=0A= text-decoration:underline}=0A= a:visited, span.MsoHyperlinkFollowed=0A= {color:purple;=0A= text-decoration:underline}=0A= p.MsoAcetate, li.MsoAcetate, div.MsoAcetate=0A= {margin:0cm;=0A= margin-bottom:.0001pt;=0A= font-size:8.0pt;=0A= font-family:"Tahoma","sans-serif"}=0A= span.EmailStyle17=0A= {font-family:"Calibri","sans-serif";=0A= color:#1F497D}=0A= span.EmailStyle18=0A= {font-family:"Calibri","sans-serif";=0A= color:#1F497D}=0A= span.BalloonTextChar=0A= {font-family:"Tahoma","sans-serif"}=0A= .MsoChpDefault=0A= {font-size:10.0pt}=0A= @page WordSection1=0A= {margin:72.0pt 72.0pt 72.0pt 72.0pt}=0A= -->=0A= </style><style type=3D"text/css" id=3D"owaParaStyle"></style> </head> <body lang=3D"EN-AU" link=3D"blue" vlink=3D"purple" fpstyle=3D"1" ocsi=3D"0= "> <div style=3D"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=3D"font-family:Tahoma; font-size:13px"> <div style=3D"font-family:Tahoma; font-size:13px"> <div style=3D"font-family:Tahoma; font-size:13px"> <div style=3D"font-family:Tahoma; font-size:13px"> <div style=3D"font-family:Tahoma; font-size:13px"> <div style=3D"font-family:Tahoma; font-size:13px"><font size=3D"2" style=3D= "font-family:Arial"><span style=3D"font-size:10pt">--------------------</sp= an></font><br> <font size=3D"2" style=3D"font-family:Arial"><span style=3D"font-size:10pt"= >Tracey Hummel</span></font></div> <div style=3D"font-family:Tahoma; font-size:13px"><span style=3D"font-famil= y:Arial; font-size:13.6000003814697px"><i>IT Director</i></span></div> <div style=3D"font-family:Tahoma; font-size:13px"><span style=3D"font-famil= y:Arial; font-size:13.600000381469727px">Sagent Labs</span></div> <div style=3D"font-family:Tahoma; font-size:13px">[email protected]</di= v> </div> </div> </div> </div> </div> </div> <div style=3D"font-family: Times New Roman; color: #000000; font-size: 16px= "> <hr tabindex=3D"-1"> <div id=3D"divRpF907342" style=3D"direction: ltr;"><font face=3D"Tahoma" si= ze=3D"2" color=3D"#000000"><b>From:</b> [email protected] [support= [email protected]] on behalf of Yasni [[email protected]]<br> <b>Sent:</b> Saturday, January 24, 2015 5:27 AM<br> <b>To:</b> [email protected]<br> <b>Subject:</b> Re: [support] Adding an additional table to views<br> </font><br> </div> <div></div> <div> <div class=3D"WordSection1"> <p class=3D"MsoNormal"><span style=3D"font-size:11.0pt; font-family:"C= alibri","sans-serif"; color:#1F497D">Too easy but it has cre= ated a problem I didn=92t notice.</span></p> <p class=3D"MsoNormal"><span style=3D"font-size:11.0pt; font-family:"C= alibri","sans-serif"; color:#1F497D"> </span></p> <p class=3D"MsoNormal"><span style=3D"font-size:11.0pt; font-family:"C= alibri","sans-serif"; color:#1F497D">The information is now = not available to all users. Requires an admin log on to see.</span></p> <p class=3D"MsoNormal"><span style=3D"font-size:11.0pt; font-family:"C= alibri","sans-serif"; color:#1F497D"> </span></p> <p class=3D"MsoNormal"><span style=3D"font-size:11.0pt; font-family:"C= alibri","sans-serif"; color:#1F497D">It doesn=92t seem to be= resolved via any changes in permissions. Is there something special that h= appens here?</span></p> <p class=3D"MsoNormal"><span style=3D"font-size:11.0pt; font-family:"C= alibri","sans-serif"; color:#1F497D"> </span></p> <p class=3D"MsoNormal"><span style=3D"font-size:11.0pt; font-family:"C= alibri","sans-serif"; color:#1F497D">Yani</span></p> <p class=3D"MsoNormal"><a name=3D"_MailEndCompose"><span style=3D"font-size= :11.0pt; font-family:"Calibri","sans-serif"; color:#1F4= 97D"> </span></a></p> <div> <div style=3D"border:none; border-top:solid #B5C4DF 1.0pt; padding:3.0pt 0c= m 0cm 0cm"> <p class=3D"MsoNormal"><b><span lang=3D"EN-US" style=3D"font-size:10.0pt; f= ont-family:"Tahoma","sans-serif"">From:</span></b><span= lang=3D"EN-US" style=3D"font-size:10.0pt; font-family:"Tahoma",&= quot;sans-serif""> [email protected] [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> [email protected]<br> <b>Subject:</b> Re: [support] Adding an additional table to views</span></p= > </div> </div> <p class=3D"MsoNormal"> </p> <p class=3D"MsoNormal"><span style=3D"font-size:11.0pt; font-family:"C= alibri","sans-serif"; color:#1F497D">Thanks... I watched thi= s <a href=3D"http://nodeone.se/en/relation-and-views-pt-1" target=3D"_blank">= http://nodeone.se/en/relation-and-views-pt-1</a> and with that bit of encou= ragement sorted it.</span></p> <p class=3D"MsoNormal"><span style=3D"font-size:11.0pt; font-family:"C= alibri","sans-serif"; color:#1F497D"> </span></p> <p class=3D"MsoNormal" style=3D"margin-bottom:12.0pt"><span style=3D"font-s= ize:11.0pt; font-family:"Calibri","sans-serif"; color:#= 1F497D">Yani <br> <br> </span></p> <p class=3D"MsoNormal"><span style=3D"font-size:11.0pt; font-family:"C= alibri","sans-serif"; color:#1F497D"> </span></p> <div style=3D"border:none; border-top:solid #B5C4DF 1.0pt; padding:3.0pt 0c= m 0cm 0cm"> <p class=3D"MsoNormal"><b><span lang=3D"EN-US" style=3D"font-size:10.0pt; f= ont-family:"Tahoma","sans-serif"">From:</span></b><span= lang=3D"EN-US" style=3D"font-size:10.0pt; font-family:"Tahoma",&= quot;sans-serif""> <a href=3D"mailto:[email protected]" target=3D"_blank">support-bou= [email protected]</a> [<a href=3D"mailto:[email protected]" target= =3D"_blank">mailto:[email protected]</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=3D"mailto:[email protected]" target=3D"_blank">support@= drupal.org</a><br> <b>Subject:</b> Re: [support] Adding an additional table to views</span></p= > </div> <p class=3D"MsoNormal"> </p> <p class=3D"MsoNormal">This should not be too bad. You need to make a relat= ionship in views with (probably) the Commerce Order. Once you add the relat= ionship you can then use the fields from table in the relationship. </= p> <div> <p class=3D"MsoNormal"> </p> </div> <div> <p class=3D"MsoNormal">-Steve </p> <div> <p class=3D"MsoNormal"><br> On Friday, January 23, 2015, Yasni <<a href=3D"mailto:[email protected]= u" target=3D"_blank">[email protected]</a>> wrote:</p> <p class=3D"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 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> ]</p> </div> </div> <p class=3D"MsoNormal"><br> <br> -- <br> Steve Kessler</p> <div> <p class=3D"MsoNormal">Owner and Lead Consultant </p> </div> <div> <p class=3D"MsoNormal">Denver DataMan, LLC </p> </div> <div> <p class=3D"MsoNormal">303-587-4428</p> </div> <p class=3D"MsoNormal"> </p> </div> </div> </div> </div> </div> </body> </html> --_000_E0483D40280CFA4E9E18C59101FB9BE94108769CSAWYERISLANDcat_-- --===============2228442712588614123== 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/ ] --===============2228442712588614123==--