good point, my bad.<br><br><br><div class="gmail_quote">On Fri, Nov 6, 2009 at 11:52 AM, Jeff Greenberg <span dir="ltr"><<a href="mailto:jeff@ayendesigns.com">jeff@ayendesigns.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="im">Jim Taylor wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Jeff,<br>
<br>
I think you're barking up the wrong tree on this one, uc_views is simply ading additional views based on the views module. It not doing anything that vanila views does not in other word it does not use SQL Views.<br>
<br>
Jim<br>
<br>
</blockquote></div>
Well, perhaps, but since this is in the module install:<br>
db_query("CREATE VIEW {uc_order_products_qty_vw} (nid,order_count,avg_qty,sum_qty,max_qty,min_qty) AS SELECT `op`.`nid` AS `nid`, COUNT(`op`.`nid`) AS `order_count`,AVG(`op`.`qty`) AS `avg_qty`, SUM(`op`.`qty`) AS `sum_qty`,MAX(`op`.`qty`) AS `max_qty`, MIN(`op`.`qty`) AS `min_qty` FROM {uc_order_products} `op` GROUP BY `op`.`nid` ORDER BY `op`.`nid`");<br>
<br>
along with two others, and since that Popular Products view uses them, and since the module description in projects says that Mysql Views create permissions are needed...I think I'm barking in the right direction.<br>
</blockquote></div><br>