From f8da3cc30379763b4e4d1b67c6a4ffdb1a67c9a3 Mon Sep 17 00:00:00 2001 From: Ben Thompson Date: Tue, 13 May 2014 17:24:53 -0400 Subject: [PATCH] Add in missing join. --- .../database/source/xm/javascript/item_site.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) diff --git a/enyo-client/database/source/xm/javascript/item_site.sql b/enyo-client/database/source/xm/javascript/item_site.sql index 31f25a534..ff9b62cfc 100644 --- a/enyo-client/database/source/xm/javascript/item_site.sql +++ b/enyo-client/database/source/xm/javascript/item_site.sql @@ -112,6 +112,12 @@ select xt.install_js('XM','ItemSite','xtuple', $$ } extra += ") "; + + if (!clause.joins) { + clause.joins = []; + } + + clause.joins.push('left join item jt0 on itemsite_item_id = item_id') } /* If vendor passed, and vendor can only supply against defined item sources, then restrict results */ @@ -121,6 +127,12 @@ select xt.install_js('XM','ItemSite','xtuple', $$ ' from itemsrc ' + ' where itemsrc_active ' + ' and itemsrc_vend_id=' + vendorId + ')'; + + if (!clause.joins) { + clause.joins = []; + } + + clause.joins.push('left join item jt0 on itemsite_item_id = item_id') } sql1 = XT.format( -- 2.39.2