Advertisement
junfan59

Working typoscript query between 3 tables into formhandler

Aug 24th, 2015
46
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. fichier1 = CONTENT
  2.         fichier1 {
  3.             table = sys_file
  4.             select {
  5.                 pidInList = root
  6.                 selectFields = sys_file.uid, sys_file.identifier
  7.                 join = sys_file_reference ON sys_file.uid = sys_file_reference.uid_local JOIN tx_news_domain_model_news ON sys_file_reference.uid_foreign = tx_news_domain_model_news.uid
  8.                 where = tx_news_domain_model_news.uid = sys_file_reference.uid_foreign and sys_file_reference.tablenames = "tx_news_domain_model_news" and tx_news_domain_model_news.pid = "13" and tx_news_domain_model_news.title=###TITLE###
  9.                 markers {
  10.                     TITLE.data = GP:FormEditnews|title
  11.                 }
  12.             }
  13.             renderObj = COA
  14.             renderObj {
  15.                 #value
  16.                 10.wrap = |
  17.                 10 = TEXT
  18.                 10.field = identifier
  19.             }
  20.         }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement