good point, my bad. On Fri, Nov 6, 2009 at 11:52 AM, Jeff Greenberg <jeff@ayendesigns.com>wrote:
Jim Taylor wrote:
Jeff,
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.
Jim
Well, perhaps, but since this is in the module install: 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`");
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.