Feature: #68094 - Database Query DataProcessor¶

Description¶

A new Database Query DataProcessor has been introduced, which can be used to fetch data from the Database to be handled by a ContentObject implementing the processors, e.g. the FLUIDTEMPLATE ContentObject.

The Database Query Processor works like the code from the Content Object CONTENT, except for just handing over the result as array. A FLUIDTEMPLATE can then simply iterate over processed data automatically.

tt_content.mycontent.20 = FLUIDTEMPLATE
tt_content.mycontent.20 {
	file = EXT:myextension/Resources/Private/Templates/ContentObjects/MyContent.html

	dataProcessing.10 = TYPO3\CMS\Frontend\DataProcessing\DatabaseQueryProcessor
	dataProcessing.10 {
		# regular if syntax
		if.isTrue.field = records

		# the table name from which the data is fetched from
		# + stdWrap
		table = tt_address

		# All properties from .select can be used directly
		# + stdWrap
		colPos = 1
		pidInList = 13,14

		# The target variable to be handed to the ContentObject again, can be used
		# in Fluid e.g. to iterate over the objects. defaults to "records" when not defined
		# + stdWrap
		as = myrecords

		# The fetched records can also be processed by DataProcessors.
		# All configured processors are applied to every row of the result.
		dataProcessing {
			10 = TYPO3\CMS\Frontend\DataProcessing\FilesProcessor
			10 {
				references.fieldName = image
			}
		}
	}
}

In the Fluid template then iterate over the files:

<ul>
<f:for each="{myrecords}" as="record">
	<li>
		<f:image image="{record.files.0}" />
		<a href="{record.data.www}">{record.data.first_name} {record.data.last_name}</a>
	</li>
</f:for>
</ul>