Hm, do you mean you would like to load the comment with the title first then only load the comment without title?

Screenshot : https://monosnap.com/file/zIjnVoc0QHKzXMrdV8Z1dEYnJoIoET

Hi Arlex,

It is like with Komento "featured" comment which appear first.

In your list the comment with title "no title here" would appear last.

Kind regards,

I see, then you have to modify this function getBlogComment from this file JoomlaFolder/administrator/components/com_easyblog/models/blog.php

I see, then you have to modify this function getBlogComment from this file JoomlaFolder/administrator/components/com_easyblog/models/blog.php

Thank you Arlex, in this function, there is indeed a conditionnal for the sorting

switch ($sort) {

			case 'desc':

			

				$query .= ' ORDER BY a.`rgt` desc';

			break;

			default:

				$query .= ' ORDER BY a.`lft` asc';

			break;

		}

What is strange is that changing any value in this function does not have any effect, like if I replace rgt or lft by id it will not sort by the comment id.

Adding a line like $query .= ' ORDER BY a.`parent_id` = 0 desc' ; will result in an error.

I think you have to execute 2 SQL query in order to achieve this.

1. Execute one of the SQL query to retrieve a list of the comment belong that article + with the title.

2. Execute another SQL query to retrieve a list of the comment belong that article + without the title.

By the way, I am really sorry but unfortunately our support policy does not cover customization

Thanks for understanding.

Hi,

I do not ask for customisation but for the right location of the code that I have to modify.

In my last reply I stated that modifying it would not have any effect so we could have supposed that the localisation of the code to modify was somewhere else and indeed I found the place where to modify it.

The sorting of the comments gets defined in models\comment.php and not in models\blogs.php

I modified the following and it solved my issue.

	$db	= EB::db();



		$queryPagination	= false;

		$queryLimit			= '';

		$queryOrder			= ' ORDER BY a.`title` DESC';

		$queryWhere			= '';



		switch($sort)

		{

			case 'latest' :

			default :

				$queryOrder			= ' ORDER BY a.`created` DESC';

				break;

		}

Hi,

I do not ask for customisation but for the right location of the code that I have to modify.

In my last reply I stated that modifying it would not have any effect so we could have supposed that the localisation of the code to modify was somewhere else and indeed I found the place where to modify it.

The sorting of the comments gets defined in models\comment.php and not in models\blogs.php

I modified the following and it solved my issue.

	$db	= EB::db();



		$queryPagination	= false;

		$queryLimit			= '';

		$queryOrder			= ' ORDER BY a.`title` DESC';

		$queryWhere			= '';



		switch($sort)

		{

			case 'latest' :

			default :

				$queryOrder			= ' ORDER BY a.`created` DESC';

				break;

		}

Hm, that is strange, are you referring on the blog entry page comment section?

If yes, it should call that function from this file JoomlaFolder/administrator/components/com_easyblog/models/blog.php.

Hi there,

You are most welcome. Glad to hear that your issue has been resolved now.

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.