If you need tracking number for ubercart order you can realize this with folowing code:
Please add this code to the next release.

//Added by zlogr
  $packages_schema =  drupal_get_schema('uc_packages');
  $data['uc_packages']['table']['join']['uc_orders'] = array(
    'left_field' => 'order_id',
    'field' => 'order_id',
  );
  $data['uc_packages']['table']['join']['uc_order_products'] = array(
    'left_field' => 'order_id',
    'field' => 'order_id',
  );
  $data['uc_packages']['table']['group'] = t('Ubercart order track number');
  $data['uc_packages']['tracking_number'] = array(
    'title' => t('Tracking number'),
    'help' => $packages_schema['fields']['tracking_number']['description'],
    'field' => array(
      'handler' => 'views_handler_field',
      'click sortable' => TRUE,
    ),
  );

Comments

zlogr’s picture

zlogr commented
Assigned: zlogr » Unassigned

Actually i used wrong table name so below correct and working version:

 //Added by zlogr
  $shipments_schema =  drupal_get_schema('uc_shipments');
  $data['uc_shipments']['table']['join']['uc_orders'] = array(
    'left_field' => 'order_id',
    'field' => 'order_id',
  );
  $data['uc_shipments']['table']['join']['uc_order_products'] = array(
    'left_field' => 'order_id',
    'field' => 'order_id',
  );
  $data['uc_shipments']['table']['group'] = t('Ubercart order track number');
  $data['uc_shipments']['tracking_number'] = array(
    'title' => t('Tracking number'),
    'help' => $shipments_schema['fields']['tracking_number']['description'],
    'field' => array(
      'handler' => 'views_handler_field',
      'click sortable' => TRUE,
    ),
    'sort' => array(
      'handler' => 'views_handler_sort',
    ),
    'filter' => array(
      'handler' => 'views_handler_filter_numeric',
    ),
  );