Advanced Search

Return to Snippet

Revision: 78403
at November 19, 2019 01:54 by xtine777
Initial Code 
10 = CONTENT
10 {
  table = tx_powermail_domain_model_answer
  select {
    pidInList = 12668
    where = field = 321
    selectFields = sum(value) AS sum
  }
  renderObj = COA
  renderObj {
    10 = TEXT
    #10.field = value
    10 {
      value = {field:sum}
      insertData = 1
    }
  }
}
Initial URL 









Initial Description





Add values from a given field in your database









Initial Title





TYPOSCRIPT: Use SUM() in SQL query









Initial Tags














Initial Language





TYPO3