Posted By


xtine777 on 11/19/19

Tagged


Statistics


Viewed 261 times
Favorited by 0 user(s)

TYPOSCRIPT: Use SUM() in SQL query


/ Published in: TYPO3
Save to your folder(s)

Add values from a given field in your database


Copy this code and paste it in your HTML
  1. 10 = CONTENT
  2. 10 {
  3. table = tx_powermail_domain_model_answer
  4. pidInList = 12668
  5. where = field = 321
  6. selectFields = sum(value) AS sum
  7. }
  8. renderObj = COA
  9. renderObj {
  10. 10 = TEXT
  11. #10.field = value
  12. 10 {
  13. value = {field:sum}
  14. insertData = 1
  15. }
  16. }
  17. }

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.