Re: Adding an additional table to views
"Yasni" <[email protected]> Sat, 24 Jan 2015 22:27:53 +1000
| Newsgroups | gmane.comp.php.drupal.support |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format. --===============6873892130958739015== Content-Type: multipart/alternative; boundary="----=_NextPart_000_0034_01D03824.FECADC30" Content-Language: en-au This is a multi-part message in MIME format. ------=_NextPart_000_0034_01D03824.FECADC30 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Too easy but it has created a problem I didn=E2=80=99t notice. =20 The information is now not available to all users. Requires an admin log = on to see. =20 It doesn=E2=80=99t seem to be resolved via any changes in permissions. = Is there something special that happens here? =20 Yani =20 From: [email protected] [mailto:[email protected]] On = Behalf Of Yasni Sent: Saturday, 24 January 2015 7:09 PM To: [email protected] Subject: Re: [support] Adding an additional table to views =20 Thanks... I watched this http://nodeone.se/en/relation-and-views-pt-1 = and with that bit of encouragement sorted it. =20 Yani=20 =20 From: [email protected] [mailto:[email protected]] On = Behalf Of Steve Kessler Sent: Saturday, 24 January 2015 6:26 AM To: [email protected] Subject: Re: [support] Adding an additional table to views =20 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.=20 =20 -Steve=20 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/ ] --=20 Steve Kessler Owner and Lead Consultant=20 Denver DataMan, LLC=20 303-587-4428 =20 ------=_NextPart_000_0034_01D03824.FECADC30 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable <html xmlns:v=3D"urn:schemas-microsoft-com:vml" = xmlns:o=3D"urn:schemas-microsoft-com:office:office" = xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" = xmlns=3D"http://www.w3.org/TR/REC-html40"><head><meta = http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8"><meta = name=3DGenerator content=3D"Microsoft Word 12 (filtered = medium)"><style><!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} @font-face {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4;} /* Style Definitions */ 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 {mso-style-priority:99; color:blue; text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed {mso-style-priority:99; color:purple; text-decoration:underline;} p.MsoAcetate, li.MsoAcetate, div.MsoAcetate {mso-style-priority:99; mso-style-link:"Balloon Text Char"; margin:0cm; margin-bottom:.0001pt; font-size:8.0pt; font-family:"Tahoma","sans-serif";} span.EmailStyle17 {mso-style-type:personal; font-family:"Calibri","sans-serif"; color:#1F497D;} span.EmailStyle18 {mso-style-type:personal-reply; font-family:"Calibri","sans-serif"; color:#1F497D;} span.BalloonTextChar {mso-style-name:"Balloon Text Char"; mso-style-priority:99; mso-style-link:"Balloon Text"; font-family:"Tahoma","sans-serif";} .MsoChpDefault {mso-style-type:export-only; font-size:10.0pt;} @page WordSection1 {size:612.0pt 792.0pt; margin:72.0pt 72.0pt 72.0pt 72.0pt;} div.WordSection1 {page:WordSection1;} --></style><!--[if gte mso 9]><xml> <o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" /> </xml><![endif]--><!--[if gte mso 9]><xml> <o:shapelayout v:ext=3D"edit"> <o:idmap v:ext=3D"edit" data=3D"1" /> </o:shapelayout></xml><![endif]--></head><body lang=3DEN-AU link=3Dblue = vlink=3Dpurple><div class=3DWordSection1><p class=3DMsoNormal><span = style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497= D'>Too easy but it has created a problem I didn=E2=80=99t = notice.<o:p></o:p></span></p><p class=3DMsoNormal><span = style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497= D'><o:p> </o:p></span></p><p class=3DMsoNormal><span = style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497= D'>The information is now not available to all users. Requires an admin = log on to see.<o:p></o:p></span></p><p class=3DMsoNormal><span = style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497= D'><o:p> </o:p></span></p><p class=3DMsoNormal><span = style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497= D'>It doesn=E2=80=99t seem to be resolved via any changes in = permissions. Is there something special that happens = here?<o:p></o:p></span></p><p class=3DMsoNormal><span = style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497= D'><o:p> </o:p></span></p><p class=3DMsoNormal><span = style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497= D'>Yani<o:p></o:p></span></p><p class=3DMsoNormal><a = name=3D"_MailEndCompose"><span = style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497= D'><o:p> </o:p></span></a></p><div><div = style=3D'border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm = 0cm 0cm'><p class=3DMsoNormal><b><span lang=3DEN-US = style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span>= </b><span lang=3DEN-US = style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"'> = [email protected] [mailto:[email protected]] <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<o:p></o:p></span></p></div></div><p = class=3DMsoNormal><o:p> </o:p></p><p class=3DMsoNormal><span = style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497= D'>Thanks... I watched this <a = href=3D"http://nodeone.se/en/relation-and-views-pt-1">http://nodeone.se/e= n/relation-and-views-pt-1</a> and with that bit of encouragement sorted = it.<o:p></o:p></span></p><p class=3DMsoNormal><span = style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497= D'><o:p> </o:p></span></p><p class=3DMsoNormal = style=3D'margin-bottom:12.0pt'><span = style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497= D'>Yani <br><br><o:p></o:p></span></p><p class=3DMsoNormal><span = style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497= D'><o:p> </o:p></span></p><div = style=3D'border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm = 0cm 0cm'><p class=3DMsoNormal><b><span lang=3DEN-US = style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span>= </b><span lang=3DEN-US = style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"'> <a = href=3D"mailto:[email protected]">[email protected]</a>= [<a = href=3D"mailto:[email protected]">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=3D"mailto:[email protected]">[email protected]</a><br><b>Subject:<= /b> Re: [support] Adding an additional table to = views<o:p></o:p></span></p></div><p = class=3DMsoNormal><o:p> </o:p></p><p class=3DMsoNormal>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. <o:p></o:p></p><div><p = class=3DMsoNormal><o:p> </o:p></p></div><div><p = class=3DMsoNormal>-Steve <o:p></o:p></p><div><p = class=3DMsoNormal><br>On Friday, January 23, 2015, Yasni <<a = href=3D"mailto:[email protected]">[email protected]</a>> = wrote:<o:p></o:p></p><p class=3DMsoNormal>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=3D"http://lists.drupal.org/" = target=3D"_blank">http://lists.drupal.org/</a> = ]<o:p></o:p></p></div></div><p class=3DMsoNormal><br><br>-- <br>Steve = Kessler<o:p></o:p></p><div><p class=3DMsoNormal>Owner and Lead = Consultant <o:p></o:p></p></div><div><p class=3DMsoNormal>Denver = DataMan, LLC <o:p></o:p></p></div><div><p = class=3DMsoNormal>303-587-4428<o:p></o:p></p></div><p = class=3DMsoNormal><o:p> </o:p></p></div></body></html> ------=_NextPart_000_0034_01D03824.FECADC30-- --===============6873892130958739015== 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/ ] --===============6873892130958739015==--