Sorting news in a folder by feed title does not work properly

10 posts / 0 new
Last post

Hi,

sorry for bothering you but I put 5 feeds in a folder naming them
page 01, page 02, page 03, page 04, page 05
and if I try to sort the news in the folder by feed title the order is not correct.
There seems to be a problem with this procedure if I call it for the whole folder..

Kind regards,

Sheldon

Works fine for me. Post

Works fine for me. Post screenshot, please.

I sent it to this email

I sent it to this email address.
rootatquiterss.org

I guess I found the culprit!

I guess I found the culprit! Smile
You seem to order the news by field id from table feeds in this case.

I went to the db and tested this query

Select * from news as n, feeds as f
where n.feedid = f.id
and n.feedid in(47,49,50,51,52)
order by f.id

From this I received exactly the same result as in the GUI.
But the problem is that

feed id 47 belongs to page 01
feed id 52 belongs to page 02
feed id 49 belongs to page 03
feed id 50 belongs to page 04
feed id 51 belongs to page 05

Shouldn't it be ordered by f.title like this?

Select * from news as n, feeds as f
where n.feedid = f.id
and n.feedid in(47,49,50,51,52)
order by f.title

This leads to the correct order.

How have you done this

How have you done this operation "I try to sort the news in the folder by feed title"?

I did it by clicking the

I did it by clicking the column header "Feed Title" in the news list.

This is the intended

This is the intended behaviour. Feed is sorted due to its id. You can resort they manually. If you want to sort it choose "Main menu->Feeds->Sort by Title". This action can't be undone!

Sort by "Feed title" in list

Sort by "Feed title" in list of news does not really work, I'll try to fix it.

Are you sure?

Are you sure?

If I click the column header "Published " the news are ordered by publishing date.
If I click the column header "Title" the news are ordered by title.

So I would expect that

If I click the column header "Feed Title " the news are ordered by feed title

Otherwise it's not consitant and really doesn't make sense if you are honest.

Ooops! Now the messages

Ooops! Now the messages overlapped! Smile
Sorry, you were too fast! Smile
Thanks!