Re: Adding an additional table to views
"Yasni" <[email protected]> Sun, 25 Jan 2015 04:05:24 +1000
| Newsgroups | gmane.comp.php.drupal.support |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format. --===============5261598078434652146== Content-Type: multipart/alternative; boundary="----=_NextPart_000_0087_01D03854.25975F30" Content-Language: en-au This is a multi-part message in MIME format. ------=_NextPart_000_0087_01D03854.25975F30 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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: [email protected] [mailto:[email protected]] On Behalf Of Hummel, Tracey S - (thummel) Sent: Sunday, 25 January 2015 2:37 AM To: [email protected] 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 [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'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: [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 Thanks... I watched this http://nodeone.se/en/relation-and-views-pt-1 and with that bit of encouragement sorted it. Yani 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 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 ------=_NextPart_000_0087_01D03854.25975F30 Content-Type: text/html; charset="us-ascii" 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=3Dus-ascii"><meta name=3DGenerator content=3D"Microsoft Word 12 = (filtered medium)"><!--[if !mso]><style>v\:* = {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} </style><![endif]--><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.BalloonTextChar {mso-style-name:"Balloon Text Char"; mso-style-priority:99; mso-style-link:"Balloon Text"; font-family:"Tahoma","sans-serif";} p.msochpdefault, li.msochpdefault, div.msochpdefault {mso-style-name:msochpdefault; mso-margin-top-alt:auto; margin-right:0cm; mso-margin-bottom-alt:auto; margin-left:0cm; font-size:10.0pt; font-family:"Times New Roman","serif";} span.emailstyle17 {mso-style-name:emailstyle17; font-family:"Calibri","sans-serif"; color:#1F497D;} span.emailstyle18 {mso-style-name:emailstyle18; font-family:"Calibri","sans-serif"; color:#1F497D;} span.balloontextchar0 {mso-style-name:balloontextchar; font-family:"Tahoma","sans-serif";} span.EmailStyle23 {mso-style-type:personal-reply; font-family:"Calibri","sans-serif"; color:#1F497D;} .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'>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. <br><br>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.<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>Hummel, Tracey S - (thummel)<br><b>Sent:</b> Sunday, 25 = January 2015 2:37 AM<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><div><p class=3DMsoNormal><span = style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black'>= I find that happens when I've added an incorrect relationship. = Make sure you remove any relationships the view does not need. = <o:p></o:p></span></p><div><p class=3DMsoNormal><span = style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black'>= <o:p> </o:p></span></p></div><div><p class=3DMsoNormal><span = style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black'>= Tracey<o:p></o:p></span></p><div><p class=3DMsoNormal><span = style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black'>= <o:p> </o:p></span></p><div><div><div><div><div><div><p = class=3DMsoNormal><span = style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";color:black'>-= -------------------</span><span = style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black'>= <br></span><span = style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";color:black'>T= racey Hummel</span><span = style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black'>= <o:p></o:p></span></p></div><div><p class=3DMsoNormal><i><span = style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";color:black'>I= T Director</span></i><span = style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black'>= <o:p></o:p></span></p></div><div><p class=3DMsoNormal><span = style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";color:black'>S= agent Labs</span><span = style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black'>= <o:p></o:p></span></p></div><div><p class=3DMsoNormal><span = style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black'>= <a = href=3D"mailto:[email protected]">[email protected]</a><o:p></o:p= ></span></p></div></div></div></div></div></div></div><div><div = class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><span = style=3D'color:black'><hr size=3D2 width=3D"100%" = align=3Dcenter></span></div><div id=3DdivRpF907342><p class=3DMsoNormal = style=3D'margin-bottom:12.0pt'><b><span = style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black'>= From:</span></b><span = style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black'>= <a = href=3D"mailto:[email protected]">[email protected]</a>= [[email protected]] on behalf of Yasni = [[email protected]]<br><b>Sent:</b> Saturday, January 24, 2015 5:27 = 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</span><span = style=3D'color:black'><o:p></o:p></span></p></div><div><div><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’t = notice.</span><span style=3D'color:black'><o:p></o:p></span></p><p = class=3DMsoNormal><span = style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497= D'> </span><span style=3D'color:black'><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.</span><span = style=3D'color:black'><o:p></o:p></span></p><p class=3DMsoNormal><span = style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497= D'> </span><span style=3D'color:black'><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’t seem to be resolved via any changes in permissions. = Is there something special that happens here?</span><span = style=3D'color:black'><o:p></o:p></span></p><p class=3DMsoNormal><span = style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497= D'> </span><span style=3D'color:black'><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</span><span style=3D'color:black'><o:p></o:p></span></p><p = class=3DMsoNormal><span = style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497= D'> </span><span = style=3D'color:black'><o:p></o:p></span></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";color:black'>= From:</span></b><span lang=3DEN-US = style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black'>= <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>Yasni<br><b>Sent:</b> Saturday, 24 January = 2015 7:09 PM<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</span><span = style=3D'color:black'><o:p></o:p></span></p></div></div><p = class=3DMsoNormal><span = style=3D'color:black'> <o:p></o:p></span></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" = target=3D"_blank">http://nodeone.se/en/relation-and-views-pt-1</a> and = with that bit of encouragement sorted it.</span><span = style=3D'color:black'><o:p></o:p></span></p><p class=3DMsoNormal><span = style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497= D'> </span><span style=3D'color:black'><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 </span><span style=3D'color:black'><o:p></o:p></span></p><p = class=3DMsoNormal><span = style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497= D'> </span><span style=3D'color:black'><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";color:black'>= From:</span></b><span lang=3DEN-US = style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black'>= <a href=3D"mailto:[email protected]" = target=3D"_blank">[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">[email protected]</a><br><b>Subject:</b> Re: = [support] Adding an additional table to views</span><span = style=3D'color:black'><o:p></o:p></span></p></div><p = class=3DMsoNormal><span = style=3D'color:black'> <o:p></o:p></span></p><p = class=3DMsoNormal><span style=3D'color:black'>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></span></p><div><p class=3DMsoNormal><span = style=3D'color:black'> <o:p></o:p></span></p></div><div><p = class=3DMsoNormal><span = style=3D'color:black'>-Steve <o:p></o:p></span></p><div><p = class=3DMsoNormal><span style=3D'color:black'><br>On Friday, January 23, = 2015, Yasni <<a href=3D"mailto:[email protected]" = target=3D"_blank">[email protected]</a>> = wrote:<o:p></o:p></span></p><p class=3DMsoNormal><span = style=3D'color:black'>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></span></p></div></div><p class=3DMsoNormal><span = style=3D'color:black'><br><br>-- <br>Steve = Kessler<o:p></o:p></span></p><div><p class=3DMsoNormal><span = style=3D'color:black'>Owner and Lead = Consultant <o:p></o:p></span></p></div><div><p = class=3DMsoNormal><span style=3D'color:black'>Denver DataMan, = LLC <o:p></o:p></span></p></div><div><p class=3DMsoNormal><span = style=3D'color:black'>303-587-4428<o:p></o:p></span></p></div><p = class=3DMsoNormal><span = style=3D'color:black'> <o:p></o:p></span></p></div></div></div></div= ></div></div></body></html> ------=_NextPart_000_0087_01D03854.25975F30-- --===============5261598078434652146== 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/ ] --===============5261598078434652146==--