Hello,
Choose "SQL" source type in "ARI Data Tables" module settings and populate "SQL query" with the following value:
Code: |
SELECT QuizId, QuizName FROM bqerc_ariquiz ORDER BY QuizName ASC
|
Navigate to "Columns settings" parameters section, populate "Columns Settings -> ID" parameter with QuizId value and set "Hidden" to "Yes".
Also set "Columns settings -> ID" parameter to QuizName and populate "Columns settings -> Format" with the following value:
<a href="index.php?option=com_ariquiz&view=quiz&quizId={$value}">{$columns:QuizName}</a>
Regards,
ARI Soft