Page Comparison

void LoadData(){
  def ctx = api.getDatamartContext()
  def dm = ctx.getDatamart("Transactions")
  def q1 = ctx.newQuery(dm, true)
  
  q1.select("sku")
  q1.select("SUM(NetSales)", "SumNetSales ")
  q1.select("SUM(Cost)", "SumCost")
  
  q1.where(Filter.equal("sku", api.product("sku")))
  
  api.global.queryData = ctx.executeQuery(q1).getData()
}

DataUtil.LoadData() // fills api.global.queryData from query

for(row in api.global.queryData){
  row.ProfitMargin = (row.SumNetSales - row.SumCost) / row.SumNetSales
}

def resultMatrix = api.newMatrix("SKU", "ProfitMargin")
api.global.queryData.each{ row ->
  resultMatrix.addRow(row.sku, row.ProfitMargin)
}
return resultMatrix

List<Map> GetData(){
  def ctx = api.getDatamartContext()
  def dm = ctx.getDatamart("Transactions")
  def q1 = ctx.newQuery(dm, true)
  
  q1.select("sku")
  q1.select("SUM(NetSales)", "SumNetSales ")
  q1.select("SUM(Cost)", "SumCost")
  
  q1.where(Filter.equal("sku", api.product("sku")))
  
  return ctx.executeQuery(q1).getData()
}

List<Map> data = DataUtil.GetData() // fills local variable from query

for(row in data ){
  row.ProfitMargin = (row.SumNetSales - row.SumCost) / row.SumNetSales
}

return data

def resultMatrix = api.newMatrix("SKU", "ProfitMargin")
out.ProcessData.each{ row ->
  resultMatrix.addRow(row.sku, row.ProfitMargin)
}
return resultMatrix

List<Map> GetData(){
  def ctx = api.getDatamartContext()
  def dm = ctx.getDatamart("Transactions")
  def q1 = ctx.newQuery(dm, true)
  
  q1.select("sku")
  q1.select("SUM(NetSales)", "SumNetSales ")
  q1.select("SUM(Cost)", "SumCost")
  
  q1.where(Filter.equal("sku", api.product("sku")))
  
  return ctx.executeQuery(q1).getData()
}
api.global.queryData = GetData()

api.global.queryData.each{ it ->
  // do something
}

List<Map> GetData(){
  return libs.SharedLib.CacheUtils.getOrSet("MyDataCacheKey"){
    def ctx = api.getDatamartContext()
    def dm = ctx.getDatamart("Transactions")
    def q1 = ctx.newQuery(dm, true)
    
    q1.select("sku")
    q1.select("SUM(NetSales)", "SumNetSales ")
    q1.select("SUM(Cost)", "SumCost")
    
    q1.where(Filter.equal("sku", api.product("sku")))
    
    return ctx.executeQuery(q1).getData()
  }
}

List<Map> data = DataUtil.GetData()
data.each{ it ->
  // do something
}

List<Map> GetTransactionData(){
  def ctx = api.getDatamartContext()
  def dm = ctx.getDatamart("Transactions")
  def q1 = ctx.newQuery(dm, true)
  
  q1.select("sku")
  q1.select("SUM(NetSales)", "SumNetSales ")
  q1.select("SUM(Cost)", "SumCost")
  
  q1.where(Filter.equal("sku", api.product("sku")))
  q1.where(Filter.equal("category", api.getElement("Category")))
  q1.where(Filter.greaterThan("netSales", out.NetSalesMinimum))
  q1.where(Filter.notIn("sku", api.global.exclusionSkus))
  
  return ctx.executeQuery(q1).getData()
}

List<Map> GetTransactionData(String sku, String category, Number netSalesMinimum, List<String> exclusionSkus){
  def ctx = api.getDatamartContext()
  def dm = ctx.getDatamart("Transactions")
  def q1 = ctx.newQuery(dm, true)
  
  q1.select("sku")
  q1.select("SUM(NetSales)", "SumNetSales ")
  q1.select("SUM(Cost)", "SumCost")
  
  q1.where(Filter.equal("sku", sku))
  q1.where(Filter.equal("category", category))
  q1.where(Filter.greaterThan("netSales", netSalesMinimum))
  q1.where(Filter.notIn("sku", exclusionSkus))
  
  return ctx.executeQuery(q1).getData()
}