I want to indetnify customers who have bought particular products, and then trigger some action on them.
1) product information is unavailable from user based views - some order product info is available, but never the product themselves
2) no VBO action is available from product order based views - I can get user info through relationship, but the corresponding actions are blank.

Help would be much appreciated, thanks

CommentFileSizeAuthor
#1 Présentation1.png187.1 KBjvieille

Comments

jvieille’s picture

jvieille commented
StatusFileSize
new Présentation1.png187.1 KB

Attached screen shot from a order product based views that correctly brings user info, but do not offer any VBO action
The other way - try to bring order product information from user based views does not bring any useful order product info.

jvieille’s picture

jvieille commented
Category: support » task
Status: Active » Needs review

this is what is missing in uc_views_views.inc

function, line 190

function uc_views_views_data() {

...

  $data['uc_orders']['table']['join']['users'] = array(
    'left_field' => 'uid',
    'field' => 'uid',
  );
+  $data['uc_order_products']['table']['join']['users'] = array(
+    'left_table' => 'uc_orders',
+    'left_field' => 'order_id',
+    'table' => 'uc_order_products',
+    'field' => 'order_id',
+  );