For coders TYPO3 Tech Corner

Extbase: Sorting for IRRE Child Elements

Extbase: Sorting for IRRE Child Elements

When I use IRRE relations in Extbase data models, I also want the editors to be able to sort these data sets.

'faqs' => [ 'config' => [ 'type' => 'inline', 'foreign_table' => 'tx_myextension_domain_model_faq', 'foreign_field' => 'faq', 'appearance' => [ 'collapseAll' => 0, 'levelLinksPosition' => 'top', 'showSynchronizationLink' => 1, 'showPossibleLocalizationRecords' => 1, 'useSortable' => 1, 'showAllLocalizationLink' => 1 ], ],

In order for the records to be sorted in the backend, the field must be set to "useSortable = 1" in the field settings of this relation in the TCA. This means that I can already sort the data records in the backend. Of course, there must also be a "sorting" field in the table "tx_myextension_domain_model_faq". However, Extbase will not yet output these data records sorted, but always in the order in which they were entered. To get the sorting into the data model, the TCA property 'foreign_sortby' => 'sorting' must be set. 

The final result looks like this:

'faqs' => [ 'config' => [ 'type' => 'inline', 'foreign_table' => 'tx_myextension_domain_model_faq', 'foreign_field' => 'faq', 'foreign_sortby' => 'sorting', 'appearance' => [ 'collapseAll' => 0, 'levelLinksPosition' => 'top', 'showSynchronizationLink' => 1, 'showPossibleLocalizationRecords' => 1, 'useSortable' => 1, 'showAllLocalizationLink' => 1 ], ],

Now Extbase will also output our IRRE relation as the editor sets it in the backend.

Stefan Busemann

Let me help you out

Hello, my name is Stefan Busemann and as managing director and customer consultant for TYPO3 projects I am happy to take care of your request personally. I am looking forward to your call or your message.

Stefan Busemann  |  Management & customer service

"Code faster, look at the time" - does this sound familiar to you?

How about time and respect for code quality? Working in a team? Automated tests?

Join us

Lesson cancellation - and now? New portal for the Bavarian school system.

For the Bavarian school system, we developed a new web app based on an existing but very outdated portal. The portal reports lesson cancellations throughout Bavaria and registered users are informed...

Go to news

SQL: Show all tables sorted by size in descending order

Lately I've been using the SQL command more often to find out which tables in the TYPO3 database are the largest. I've published the snippet once.

Go to news

TYPO3 12 with CKEditor 5: Styles in a single selection

If you set a link in the RTE in TYPO3, you may have to choose between different link classes, for example to create buttons in the frontend. What's new in TYPO3 12 is that you can select not just one...

Go to news

Null-Safe Operator in the TYPO3 area

With the introduction of PHP8, problems with undefined arrays or variables in general can arise in many places. Here are a few examples and simple solutions.

Go to news

Delete the first/last lines of a (SQL) file

There isn't much to say about the following commands. Sometimes it can be useful to delete the first (or last) X lines from a file. And if the file is too large to open with a conventional program, a...

Go to news

b13/container: Add and modify child elements in edit view

Unlike gridelements, you cannot manage the child elements in the B13 Container extension when you open the container in the editing view. I would be happy to show you how you can quickly install this...

Go to news