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