[TYPO3-project-formidable] modify custom LISTER query

[Ivan Gomez Rodriguez]

Hello,

You can try with compiledatasource.

http://lists.netfielders.de/pipermail/typo3-project-formidable/2006-December/000162.html



Asbjørn Morell wrote:
> Hello,
> 
> I have a page that generates a search form and a lister from the same xml 
> file. (sHtmlList) I have created a custom query for my lister, but now my 
> search form does not work anymore. My custom query is executed each time and 
> all my input fields gets ignored. Also tried with <overridesql> and 
> <onfields> . Any ideas?
> 
> Best regards.
> Asbjørn Morell.
> 
> 
>    <search>
>     <sql>
>      <query>
> 
>       <userobj>
>        <php><![CDATA[
> 
>        return "
> 
>        SELECT
>          tx_myart_art.uid,
>          tx_myart_art.cruser_id,
>          tx_myart_art.title,
>          tx_myart_art.category,
>          tx_myart_images.title AS img_title,
>          fe_users.name
>        FROM
>          tx_myart_art
>          LEFT OUTER JOIN tx_myart_art_image_mm ON (tx_myart_art.uid = 
> tx_myart_art_image_mm.uid_local)
>          LEFT OUTER JOIN tx_myart_images ON 
> (tx_myart_art_image_mm.uid_foreign = tx_myart_images.uid)
>          LEFT OUTER JOIN fe_users ON (tx_myart_art.cruser_id = fe_users.uid)
>        GROUP BY
>          tx_myart_art.uid
> 
>          ";
> 
>        ]]></php>
>       </userobj>
>      </query>
>     </sql>
>    </search> 
> 
> _______________________________________________
> TYPO3-project-formidable mailing list
> TYPO3-project-formidable at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-project-formidable
>