Hello,
Use the following SQL query:
| Code: |
SELECT
I.id,
I.title,
U.userName,
C.name
FROM
#__k2_items I INNER JOIN #__k2_users U
ON U.userID = I.created_by
INNER JOIN #__k2_categories C
ON I.catid = C.id
|
Set "Columns settings -> ID" parameter to id and set "Columns settings -> Hidden" parameter to "Yes" in module settings. Set also "Columns settings -> ID" parameter to title and "Columns settings -> Format" parameter to the following value:
<a href="index.php?option=com_k2&view=item&id={$columns:id}">{$value}</a>
Regards,
ARI Soft
