[TYPO3-english] Question about DatabaseQueryProcessor

Szabo jean at netinfluence.ch
Tue Feb 13 15:16:20 CET 2018


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


More information about the TYPO3-english mailing list