projects
/
xtuple
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
3b6c1c6
)
Add in missing join.
author
Ben Thompson
<ben@xtuple.com>
Tue, 13 May 2014 21:24:53 +0000
(17:24 -0400)
committer
Ben Thompson
<ben@xtuple.com>
Tue, 13 May 2014 21:24:53 +0000
(17:24 -0400)
enyo-client/database/source/xm/javascript/item_site.sql
patch
|
blob
|
history
diff --git
a/enyo-client/database/source/xm/javascript/item_site.sql
b/enyo-client/database/source/xm/javascript/item_site.sql
index
31f25a5
..
ff9b62c
100644
(file)
--- 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(