Hello,
Yes, it is possible. For example if you want to show content categories in main table and then show all articles from selected category in sub table on new page for Joomla! 1.5, you can do the following:
1. Create two instance of "ARI Data Tables". One for main table ("Categories"), second for sub-tables ("Articles").
2. Create two articles, for example "Categories page" and "Articles page" and load "Categories" module into "Categories page" article and "Articles" module into "Articles page" with help "Content - ARI Data Tables" plugin.
3. Use the next SQL query for "Categories" module:
| Code: |
SELECT id, title FROM #__categories WHERE section = "com_content"
|
then go to "Columns settings -> Columns settings" parameters and set "ID" parameter to "title" and "Format" parameter to
<a href="index.php?option=com_content&view=article&id=ARTICLES_PAGE_ID&selCatId={$columns:id}">{$value}</a>
Where ARTICLES_PAGE_ID is ID of "Articles page" article. For example, if it equals to 45, use the next code for "Format" parameter:
<a href="index.php?option=com_content&view=article&id=45&selCatId={$columns:id}">{$value}</a>
4. Use the following SQL query in "Articles" module:
| Code: |
SELECT id,title FROM #__content WHERE catid = {$REQUEST:selCatId|filter:int}
|
In brief, "ARI Data Tables" provides ability to use request parameters in SQL query and this ability is used for described approach.
Regards,
ARI Soft
