[Typo3-dev] change default sorting of MySQL WHERE - IN

[ingo schmitt]

Hi,
[..]
> 
> thanks for your hints. By now I think I don`t really need the MySQL
> query any more.
> 
> Background:
> the section index doesn`t work properly with TemplaVoila!. But there is
> a workaround: http://bugs.typo3.org/view.php?id=465
> 
> Unfortunately this only works if you fill the register within the DS so
> you can only access the register from within the content field defined
> in the DS. Inserting tt_content.menu.20.3 as a content element works but
> if you want to include the section index via a TS object defined in your
> TS-template you can`t access the register. (You also can`t use treelevel
> conditions in the TypoScript sections within a page-DS) That`s why Ingo
> and I created a mini extension that reads the content-element uids from
> the tx_templavoila_flex field of the current page. As this field can
> contain UIDs of content-elements that are not valid (e.g. someone
> deleted them in the LIST-view) we filtered the uids with a select query
> + enabledfields.
> 
> But as the section index is build with a record object:
> 
> lib.sectionindex = COA
> lib.sectionindex {
>   10 < plugin.tx_mfctvsectionindex_pi1
>   # "Section index (pagecontent w/Index checked)"
>   20 = RECORDS
>   20 {
>     source.cObject < plugin.tx_mfctvsectionindex_pi2
>     tables = tt_content
>     ....
> 
> The uids are then filtered anyway. So the additional MySQL query is not
> really necessary.
> 
As soon, as we have an documentation and some cleanup in the code, this 
extension will be in ter:-)


Ingo

Mit freundlichen Gruessen
-- 
Ingo Schmitt                        mailto:is at marketing-factory.de
Marketing Factory Consulting GmbH   http://typo3.marketing-factory.de/
Content Management mit Typo3: Beratung - Schulung - Realisierung