DatabaseQueryProcessor¶

DatabaseQueryProcessor¶
The DatabaseQueryProcessor fetches records from the database,
using the default select semantics  from TypoScript. The result
then gets handed over to the FLUIDTEMPLATE as an array.
This way a FLUIDTEMPLATE cObject can iterate over the
array of records.

Options:¶

if¶

Required: false

Type: if condition

Default: ’’

If the condition is not met the data is not processed

table¶

Required: true

Type: string, stdWrap

Default: ’’

Name of the table from which the records should be fetched

as¶

Required: false

Type: string, stdWrap

Default: ‘records’

The variable’s name to be used in the Fluid template

dataProcessing¶

Required: false

Type: array of dataProcessing

Default: ’’

Array of DataProcessors to be applied to all fetched records.

Note
all other options will be interpreted as in the TypoScript function
“select”, including pidInList, orderBy,
where etc. See the reference of select.

Example: Display haiku records¶
Please see also About the examples.

TypoScript¶
We define the dataProcessing property to use the DatabaseQueryProcessor:
tt_content {
   examples_dataprocdb =< lib.contentElement
   examples_dataprocdb {
      templateName = DataProcDb
      dataProcessing.10 = TYPO3\CMS\Frontend\DataProcessing\DatabaseQueryProcessor
      dataProcessing.10 {
         if.isTrue.field = pages
         table = tx_examples_haiku
         orderBy = title
         pidInList.field = pages
         as = myHaikus
         // recursively process the images in the records with the FilesProcessor
         dataProcessing {
            10 = TYPO3\CMS\Frontend\DataProcessing\FilesProcessor
            10 {
               references.fieldName = image
            }
         }
      }
   }
}

The Fluid template¶
In the Fluid template then iterate over the records. As we used the recursive data
processor FilesProcessor on the image records we also can output the images.
<html data-namespace-typo3-fluid="true" xmlns:f="http://typo3.org/ns/TYPO3/CMS/Fluid/ViewHelpers">
   <h2>Data in variable myHaikus</h2>
   <f:debug inline="true">{myHaikus}</f:debug>
   <h2>Output</h2>
   <div class="row">
      <f:for each="{myHaikus}" as="haiku">
         <div class="col-12 col-md-3">
            <div class="card" style="backgorund-color: {haiku.color};">
               <f:if condition="{haiku.files.0}">
                  <f:image image="{haiku.files.0}" class="card-img-top" height="300"/>
               </f:if>
               <div class="card-body">
                  <h5 class="card-title">{haiku.data.title}</h5>
                  <div class="card-text"><f:format.html>{haiku.data.poem}</f:format.html></div>
               </div>
            </div>
         </div>
      </f:for>
   </div>
</html>

Output¶
The array of records each contains the data of the table in data and
the data of the images in files.