Szabo
2018-02-13 14:16:20 UTC
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
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