• 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: RSForm list, many pages with feedback

RSForm list, many pages with feedback 10 years 7 months ago #28863

  • ENexus
  • ENexus's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
Hello. I have many pages with rsform list module and with feedback module, which writes page title is answers' base.
How can I make a sorting of message based on page title, for example, like it is made with displaying confirmed messages?

function _buildQuery()
{
$query = "SELECT SQL_CALC_FOUND_ROWS DISTINCT(sv.SubmissionId), s.* FROM #__rsform_submissions s";
$query .= " LEFT JOIN #__rsform_submission_values sv ON (s.SubmissionId=sv.SubmissionId)";
$query .= " WHERE s.FormId='".$this->formId."'";

$confirmed = $this->params->get('show_confirmed', 0);
if ($confirmed)
$query .= " AND s.confirmed='1'";
The administrator has disabled public write access.

RSForm list, many pages with feedback 10 years 7 months ago #28875

  • ENexus
  • ENexus's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
Solved by myself :) it's working:)


$doc = JFactory::getDocument();
$page_title = $doc->getTitle();
if ($page_title)
$query .= " AND sv.fieldvalue= '$page_title'";
The administrator has disabled public write access.
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!