---
title: "Feature: #68094 - Database Query DataProcessor"
manual: "TYPO3 Core Changelog"
version: "main"
permalink: "https://docs.typo3.org/permalink/changelog:feature-68094"
source: "Changelog/7.4/Feature-68094-DatabaseQueryDataProcessor.rst"
modified: "2026-09-14T09:47:36+00:00"
---

# Feature: #68094 - Database Query DataProcessor

See [forge#68094](https://forge.typo3.org/issues/68094)

## 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.

```typoscript
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:

```html
<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>
```