Hello,

we have this Query to show the posts of the current LoggedIn User and it works fine:

SELECT
created AS "Erstellt am:", title AS "Beitragstitel"
FROM
#__content
WHERE
created_by = {$UserId}
ORDER BY created DESC

but is ist possible to make the title linkable so that i can get to the article by clicking on it ?

We tried to set "<a href="{$value}">{$value}</a>" to Column Settings -> Format but the Link doesnґt work. Index.php and the Category is missing, i think whith this it would work, but we donґt get it going.

Do you have any solution to solve this ?

Hello,

It is possible to use the next SQL query:



Set "Columns Settings -> ID" parameter to id value and set "Columns Settings -> Hidden" parameter to "Yes" then set "Columns Settings -> ID" parameter to Beitragstitel and "Columns Settings -> Format" parameter to the following value:

<a href="index.php?option=com_content&view=article&id={$columns:id}">{$value}</a>

Regards,
ARI Soft

This works great.

Thanks a lot !!!