1. pat01
  2. General
  3. Thursday, November 23 2017, 03:13 PM
Hi

I need to run some SQL queries to get and display data in a profile tab.

Is there a way to do so? I don't see a field of type "Use SQL" or similar.

Thank you very much!
admin Accepted Answer
Admin
Is there a way to do so?

Yes but not natively,
our delimiter field type allow you to use Joomla content plugins (docs about this field type at http://docs.easy-profile.com/index.php/article/html-delimiter-field-type).

You can use some free plugin like Sourcerer (https://www.regularlabs.com/extensions/sourcerer) to get usergroups and display with some code like this:
{source}
<?php
global $JSNLIST_DISPLAYED_ID;
if($JSNLIST_DISPLAYED_ID) $owner_id=$JSNLIST_DISPLAYED_ID;
else $owner_id=JRequest::getVar( 'id' , JFactory::getUser()->id );
$db=JFactory::getDbo();
$query='YOUR-QUERY'
$db->setQuery($query);
$result=$db->loadObjectList();
?>
{/source}

Customize and put this code in a HTML delimiter field type.

NOTE: this code is not tested and not supported, this is only for example purpose, you need to have PHP and Joomla devs knowledges.
  1. more than a month ago
  2. General
  3. # 1
pat01 Accepted Answer
Pro
Thanks a lot!
  1. more than a month ago
  2. General
  3. # 2
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.