I would like to make the following table:

Column1: [Joomla article name] - clickable to the article
Column2: Free text- which I fill out manually in the table
Column3: Free text- etc

The table should extend automatically (with the article name in column 1) when I add a new article to Joomla.

Is this possible? I'm not familiar with SQL - so I need help with the query.

Hello,

If you want to show articles in a table, use the following SQL query:



Set "Columns settings -> ID" parameter to id and "Columns settings -> Hidden" parameter to "Yes". Set also "Columns settings -> ID" to title and "Columns settings -> Format" to the following value:



Regards,
ARI Soft

Thanks! It worked fine. But is it possible to choose article titles from articles inside a spesific category, and not all articles?

For example if you want to show articles from category with ID = 3, use the following SQL query:



Regards,
ARI Soft

I also need to query from another Joomla table (Jinfinity Custom Fields). The ARI table should include article name (column 1 - as describes earlier) and Ji Custom Fields in column 2,3,4 etc. Jinfinity gave me the follow code, which I found a bit complicated:

----------------------------------
You will need to query the Ji Custom Fields tables as well.
For example:
// find catid from article
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('catid');
$query->from('#__content');
$query->where('id='.$article_id);
$db->setQuery($query);
$catid = (int) $db->loadResult();

// get field data
$query = $db->getQuery(true);
$query->select('f.*, fv.value');
$query->from('#__jifields AS f');
$query->join('left', '#__jifields_map AS map ON map.fid = f.id');
$query->join('left', '#__jifields_values AS fv ON fv.fid = f.id');
if($catid!=0) $query->where('map.catid = '.(int) $catid);
$query->where('f.title = '.$db->quote($field_title));
$query->where('fv.cid = '.$article_id);
$db->setQuery($query);
$field = $db->loadObject();
------------------------------------------

How would you write this into the ARI plugin?

Ask "Jinfinity Custom Fields" support about SQL query (one SQL query, not PHP code which creates two SQL query which they provided) which will return articles from specific category with custom fields from their extension.

Regards,
ARI Soft