[TYPO3-project-formidable] modify custom LISTER query

[Asbjørn Morell]

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>