TYPO3 tx_news add 'random' to the 'sort by' list setting

Question

In a v12 TYPO3 site running EXT:news 12.3.0 I'd like to display a random selection of news articles, maintaining other chosen restraints (as limit to categories, respect top news etc.).

Best practice would add the item random to $GLOBALS['TYPO3_CONF_VARS']['EXT']['news']['orderByNews'] and adapt the demand accordingly. (I'd rather not resort to fetching all articles and then have a viewhelper do the math)

Adding the item is explained here in the documentation.

Anyone knows how to script the rest ? (or a tutorial that would explain how to go about)

Mathias Brodala · Accepted Answer · 2025-10-23 07:30:31Z

0

Unfortunately this cannot be achieved currently. News uses the regular Extbase persistence internally and only makes the order selection configurable.

Extbase does not support SQL options like random sorting.

So you may indeed need to fetch a sufficient amount of items and then shuffle them at runtime / on render. It may be more performant to first fetch all relevant UIDs first and shuffle these. Then, after applying a limit, you can fetch a vastly reduced but now shuffeld subset of news objects.

answered Oct 23 at 7:30

Mathias Brodala

6,52816 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

webman Oct 25 at 8:36

did you consider accessing the news table directly with typoscript and a databaseprocessor with orderBy = rand() ?

Collectives™ on Stack Overflow

TYPO3 tx_news add 'random' to the 'sort by' list setting

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related