From 62188180cab5a8db2c1eece0180fb2f647568741 Mon Sep 17 00:00:00 2001 From: Ben Thompson Date: Thu, 18 Sep 2014 14:17:20 -0400 Subject: [PATCH] Include the view when building share_users. --- .../sales/database/source/xt/tables/sharetype.sql | 14 ++++++++++++++ .../source/xt/views/share_users_shipto_cust.sql | 2 +- 2 files changed, 15 insertions(+), 1 deletion(-) diff --git a/enyo-client/extensions/source/sales/database/source/xt/tables/sharetype.sql b/enyo-client/extensions/source/sales/database/source/xt/tables/sharetype.sql index 69301f323..3e343bf4c 100644 --- a/enyo-client/extensions/source/sales/database/source/xt/tables/sharetype.sql +++ b/enyo-client/extensions/source/sales/database/source/xt/tables/sharetype.sql @@ -54,6 +54,20 @@ insert into xt.sharetype ( 'username' ); +-- Customer that a Ship To is on CRM Account's users. +delete from xt.sharetype where sharetype_tblname = 'share_users_shipto_cust'; +insert into xt.sharetype ( + sharetype_nsname, + sharetype_tblname, + sharetype_col_obj_uuid, + sharetype_col_username +) values ( + 'xt', + 'share_users_shipto_cust', + 'obj_uuid', + 'username' +); + -- Sales Order CRM Account's users. delete from xt.sharetype where sharetype_tblname = 'share_users_cohead'; insert into xt.sharetype ( diff --git a/enyo-client/extensions/source/sales/database/source/xt/views/share_users_shipto_cust.sql b/enyo-client/extensions/source/sales/database/source/xt/views/share_users_shipto_cust.sql index 676a5ae9a..d852f1fbc 100644 --- a/enyo-client/extensions/source/sales/database/source/xt/views/share_users_shipto_cust.sql +++ b/enyo-client/extensions/source/sales/database/source/xt/views/share_users_shipto_cust.sql @@ -5,7 +5,7 @@ * a shared access that has been specifically granted. * * This view can be used to determine which users have personal privilege - * access to a Contact that is on a Ship To based on what CRM Account the + * access to a Customer that a Ship To is on based on what CRM Account the * Ship To belongs to. */ -- 2.39.2