Content::columnData()
\nn\t3::Content()->columnData($colPos, $addRelations = false, $pageUid = NULL);
Loads the "raw" tt_content data of a specific column(colPos).
\nn\t3::Content()->columnData( 110 );
\nn\t3::Content()->columnData( 110, true );
\nn\t3::Content()->columnData( 110, true, 99 );
Copied!
Also available as ViewHelper.
| relations is set to TRUE by default in the ViewHelper
{nnt3:content.columnData(colPos:110)}
{nnt3:content.columnData(colPos:110, pid:99, relations:0)}
Copied!
| @return array
Source Code
public function columnData($colPos, $addRelations = false, $pageUid = null)
{
if (!$pageUid) $pageUid = \nn\t3::Page()->getPid();
$queryBuilder = \nn\t3::Db()->getQueryBuilder('tt_content');
$data = $queryBuilder
->select('*')
->from('tt_content')
->andWhere($queryBuilder->expr()->eq('colPos', $queryBuilder->createNamedParameter($colPos)))
->andWhere($queryBuilder->expr()->eq('pid', $queryBuilder->createNamedParameter($pageUid)))
->orderBy('sorting')
->executeQuery()
->fetchAllAssociative();
if (!$data) return [];
if ($addRelations) {
foreach ($data as $n => $row) {
$data[$n] = $this->addRelations($row);
}
}
return $data;
}
Copied!