... in a JSON or ZohoDeluge Map format
m_Response = Map();
l_JsonProducts = List();
//
// start preparing CSV file to email for export
v_ReportCSV = "ItemID,ItemName,Price,CurrencyCode,QuantityAvailable,SKU,DateCreated";
l_CsvFileRows ...
...
cn."Total (BCY)" AS "CnTotal",
cni."Buy Price" AS "ItemBuyPrice",
cni."Discount Amount (BCY)" AS "ItemDiscount",
cni."Item Name" AS "ItemName",
cni."Item Price" AS "ItemPrice",
cni."Quan ...
... ItemName,
DATEPART(dayofyear, ItemDate) as DayOfYear,
DATEPART(year, ItemYear) AS YearRun,
COUNT(ItemName) AS Counter
FROM
TableName
WHERE
ItemDate BETWEEN '01/01/2010' ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.