How to use LOAD_REGISTER with Typoscript select?

Question

In Typoscript, I want to use register together with select. I have a row with values: firstname, lastname, mail. I want to assign it to register somehow, and then use it for another plugin:

page {
 10 = CONTENT
 10 {
  table = tx_my_custom_table
  select {
    pidInList = 21
    where = uid=1234
    selectFields = firstname,lastname,mail
  }
  renderObj = COA
  renderObj {
    10 = LOAD_REGISTER
    10 {
       /*how to assign values to register???*/
    }
  }
 }
}

plugin.tx_powermail.settings.setup.prefill {
    email = TEXT
    email.value = {register.mail}
}

I tried a lot of combinationes with data and field, but it didn't work.

Adding the SELECT statement to the plugin section is possible, but in reality I have 30 fields, and I don't want 30 database queries for one row.

Bernd Wilke πφ Bernd Wilke πφ · Accepted Answer · 2019-08-29T12:09:25

in general you assign a value to a register name:

10 = LOAD_REGISTER
10 {
    register1 = value1

    register2 = 10
}

but you have stdWrapfunctionality and so you can use also:

10 = LOAD_REGISTER
10 {
    register3.field = field1

    register4.data = date:U
    register4.strftime = %Y-%m-%d
}

Edit:

you may use cObject if no stdWrap-functionality is given (in older TYPO3 versions):

10 = LOAD_REGISTER
10 {
    register5.cObject = TEXT
    register5.cObject.field = field1

    register6.cObject = TEXT
    register6.cObject.data = date:U
    register6.cObject.strftime = %Y-%m-%d
}

Accessing registers can be done like:

20 = TEXT
20.data = register:register1

30 = TEXT
30.value = {register:register2}
30.stdWrap.insertData = 1

remember:
only the last value is accessible - unless you use RESTORE_REGISTER to pop the register stack

How to use LOAD_REGISTER with Typoscript select?

1 Answers