Discussion:
[TYPO3-english] Question about DatabaseQueryProcessor
Szabo
2018-02-13 14:16:20 UTC
Permalink
Hello,

I have a ContentElement, and I need to have the list off element with image and the list without image in 2 specifics datas.

I have this code :

the 20 point give me elements for the content,

but the 30 and 40 give me for pid, and if I have more the one content element in a page, I get all element, not by content.

How make the query 30 and 40 for limiting to the content_id, and not to the page id ?



##########################
### DATA PREPROCESSING ###
##########################
dataProcessing {
10 = BK2K\BootstrapPackage\DataProcessing\FlexFormProcessor

20 = TYPO3\CMS\Frontend\DataProcessing\DatabaseQueryProcessor
20 {
table = tx_cohort_people_item
pidInList.field = pid
where {
data = field:uid
intval = 1
wrap = tt_content=|
}
orderBy = sorting
dataProcessing {
10 = TYPO3\CMS\Frontend\DataProcessing\FilesProcessor
10 {
references.fieldName = image
as = images
}
}
}

40 = TYPO3\CMS\Frontend\DataProcessing\DatabaseQueryProcessor
40 {
table = tx_cohort_people_item
pidInList.field = pid

where {
dataWrap = image = 0
}

orderBy = sorting
as = list_without_image
}


30 = TYPO3\CMS\Frontend\DataProcessing\DatabaseQueryProcessor
30 {
table = tx_cohort_people_item
pidInList.field = pid

where {
dataWrap = image = 1
}

orderBy = sorting
dataProcessing {
10 = TYPO3\CMS\Frontend\DataProcessing\FilesProcessor
10 {
references.fieldName = image
as = images
}
}
as = list_with_image
}

}

thanks a lot for your help

Jean

Loading...