By David Montoya on Thursday, 28 April 2016
Posted in Technical Issues
Likes 0
Views 358
Votes 0
Is there a way, within the database, to change the order of custom fields? I tried redoing their IDs within _easyblog_fields, but they don't seem to be sorted by that column.
Found the fix, to anyone curious. Open the Operations tab, and use Alter table order by.

·
Thursday, 28 April 2016 12:23
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey David,

Unfortunately right now there is no way to re-order them currently.
·
Thursday, 28 April 2016 11:30
·
0 Likes
·
0 Votes
·
0 Comments
·
How is order currently determined? It's gotta be stored somewhere~
·
Thursday, 28 April 2016 11:46
·
0 Likes
·
0 Votes
·
0 Comments
·
We did not explicitly retrieve the items by their ordering. It is by the id by default. You can look at the table #__easyblog_fields and try to sort them by id or the creation date.
·
Thursday, 28 April 2016 11:55
·
0 Likes
·
0 Votes
·
0 Comments
·
I'll keep playing with it. I edited both with no desired results. Maybe I edited the creation date incorrectly or something.
·
Thursday, 28 April 2016 12:04
·
0 Likes
·
0 Votes
·
0 Comments
·
If you have set the correct creation date, you can order by the creation date by ascending or descending
·
Thursday, 28 April 2016 12:07
·
0 Likes
·
0 Votes
·
0 Comments
·
It's truly the weirdest thing. It seems to be determined by group_id, regardless of whether or not all the group IDs are the same. If you sort by created or id, you don't get expected results. The order reflects whatever group_id sorts into. I've tried exporting the table, dropping the old one, and reimporting, and the group_id order is random every time. Weird!
·
Thursday, 28 April 2016 12:17
·
0 Likes
·
0 Votes
·
0 Comments
·
I have certain fields that make more sense grouped together (Image Caption, Image Citation), and I'm just mildly obsessive-compulsive.
·
Thursday, 28 April 2016 12:24
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks for updating, glad that your issues are resolved now.
·
Thursday, 28 April 2016 12:26
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post