By Paul Murray on Tuesday, 24 April 2018
Posted in Groups
Replies 20
Likes 0
Views 686
Votes 0
Hi Si Team

I can not figure out how or where groups are sorted?

Is it by name or date created?

If by date created can I go in and edit the date created to get the groups to appear in the exact order I want?

Can you point me in the right direction?

thanks

Paul
Hi Paul,

May I know which page that are you refer above? it is this http://take.ms/zhg1y ?
Can you give us the link to the page and some screenshot of it so that we can know the sorting of it
·
Tuesday, 24 April 2018 17:29
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Paul,

Editing the date of each group (from the database) is a solution that works, even if it's a little tricky.

Philippe
·
Tuesday, 24 April 2018 17:37
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Fadhli

Yes that is it!
Right under my nose
If I change the dates that the groups were created then they will sort accordingly right?

best

Paul

PS speaking of things right under my nose is there a way I can switch off "Near by Groups"?
·
Tuesday, 24 April 2018 17:38
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Philippe

Editing the date of each group (from the database) is a solution that works, even if it's a little tricky.


Ahhhh so this is not going work by editing the Groups in the ES back end.

As luck would have it my groups are ordered exactly the wrong way!!!

Similar problems when creating video in a Group but that is another story!

@ Fadhli could you walk me through this?

I assume that I have to start by looking for a specific field in phpMyAdmin in the cPanel….
·
Tuesday, 24 April 2018 17:58
·
0 Likes
·
0 Votes
·
0 Comments
·
If you just have to reverse the order, you will not need to change the dates in the database.
This will go through a custom file.

Philippe
·
Tuesday, 24 April 2018 18:14
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Paul,

Kindly find my response for your inquiries below:
If I change the dates that the groups were created then they will sort accordingly right?

Yes, If you want to reorder the date you need to alter in the database in the #_social_clusters table and change the 'created' column for that specific group

PS speaking of things right under my nose is there a way I can switch off "Near by Groups"?

There is no setting for this, where you can customize in the file:
.../components/com_easysocial/themes/wireframe/groups/default/sidebar.php

As luck would have it my groups are ordered exactly the wrong way

Do you mean the current sorting is wrong? where it is not sort by latest? However, I've compare the date created in backend seems it was sort correctly. http://take.ms/qx0p9
·
Tuesday, 24 April 2018 18:25
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Fadhli

Thanks for looking into this for me...

I guess the main thing is that I am using groups to manage courses. So I have for eg

1) Standard Group that every one gets put in on registration (created first)
2) An open Group / Eg of how this all works (created second)

3) Group for beginners (created third)
4) Group for medium users (created fourth)
5) Group for advanced users (created fifth)
6) Group for really advanced users (created sixth)

So whilst technically the sort by order created works it just does not make sense for me.

Is there a way that I can sort the other way around from oldest to latest or do I have to deal with the joys of data bases?

Please see attachments as to what I have found in the data base so far....
·
Tuesday, 24 April 2018 18:57
·
0 Likes
·
0 Votes
·
0 Comments
·
ps @ Philippe
If you just have to reverse the order, you will not need to change the dates in the database.
This will go through a custom file.


I just saw your suggestion above.

Yes this sounds less painfull

If you or Fadhli could tell me how to do this, that would be great
·
Tuesday, 24 April 2018 19:00
·
0 Likes
·
0 Votes
·
0 Comments
·
Ah basically you want to make it oldest to latest not latest to oldest(current behavior) isn't it? This is much easier and yes less painful, where you no need change the date every time you've create a new group yeah.
For this, can you download the attached file and replace in the:
.../administrator/components/com_easysocial/models/groups.php
and see how it goes?

You're suggested to backup the file that you want to replace beforehand for precaution
·
Tuesday, 24 April 2018 19:12
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Fadhli

Works like a charm. Thanks.
The obligatory stupid question.
Does this file get updated/overwritten every time ES gets updated.

Do I need to update this file manually/separately every time ES gets updated?

thanks

Paul

ps thanks Philippe
·
Tuesday, 24 April 2018 20:13
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Paul,

Yes you need to update this file manually every es update as this file in not in the theme file (which is cannot make template override)
·
Wednesday, 25 April 2018 10:15
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Fadhli

Got it

thanks

Paul
·
Wednesday, 25 April 2018 16:46
·
0 Likes
·
0 Votes
·
0 Comments
·
You are most welcome Paul

Just for your information, I have locked and marked this thread as resolved to avoid confusions in the future. Please start a new thread if you have any other issue in the future so it will be easier for us to manage your inquiries.

Thanks for understanding and have a nice day ahead
·
Wednesday, 25 April 2018 17:52
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post