[TYPO3-dev] sorting IRRE in FlexForm

[bernd wilke]

Am 14.02.2013 16:58, schrieb Sascha:
> Hello Everyone.
>
> I hope someone can help me with my (small?) problem.
>
> i currently have a Extbase model that can added multiple times into a
> FlexForm.

>
> So far everything works without any problem.
> But the sorting i make in the FlexForm is not saved in the database.
> Maybe it ignores the definiton of <foreign_sortby>
>
> I noticed that it saves the sorting in an XML inside the tt_content
> database-table.
> It looks like this:
>
> <?xml version="1.0" encoding="utf-8" standalone="yes" ?>
> <T3FlexForms>
>     <data>
>         <sheet index="settings">
>             <language index="lDEF">
>                 <field index="images">
>                     <value index="vDEF">20,21</value>
>                 </field>
>             </language>
>         </sheet>
>     </data>
> </T3FlexForms>
>
>
> And inside the <value index="vDEF"> are the two IDs of the Objects i
> added. And when i change the sorting it changes in the XML too. But not
> in the "sorting" field in the database.

you may use this kind of ordering in your query:
$orderBy      = 'field(uid,' . $orderedUidList . ')';

> That way i can not read the sorting when i use Extbase.

I think this information should be also available in extbase.

bernd
-- 
http://www.pi-phi.de/cheatsheet.html