|
// 查询销售出库
// st.salesout.SalesOuts 销售出库子表
// mainid 销售出库子表中主表的id
// ustock 销售出库单domainkey
var relSearch = "select product,sum(qty) as qty,mainid,mainid.vouchdate as vouchdate from st.salesout.SalesOuts left join mainid main on mainid = main.id where product='2167818396816128' and mainid.vouchdate between '2022-05-10' and '2022-05-12'";
var result = ObjectStore.queryByYonQL(relSearch,"ustock");
|
|