Help with displaying Joomla Articles

I am creating a connection in CCv4 to display the title and create date of all articles in the wxvz_content table that are in a specific category (cat_id=47). I also want to link the article title to display the title, created date and introtext section of the article which it is in. I have the connection created with showing all articles but can't figure out how to restrict the article listing to just those with cat_id=47 and also how to make one of the title clickable and open up the full view of the article. I don't have a chronoform that was created to work with this because the content is submitted through normal joomla functions. Please let me know what I need to do. Thanks.

Hi mkusens,

Have you tried putting `cat_id` = 47 in the General Tab WHERE SQL box?

The Front End List Settings tab lets you add Linkable fields. The Entry for the View link on the FAQs here is

Article.title:view&cb={Article.id}&alias={Article.alias}

. This links back to a form which displays the article, it may be possible to link directly to the normal article display instead but I'm not sure how.

Bob

With regard to your last statement Greyhead, I was wondering if you or Max had figured out a way to link directly to an article from Chronoconnectivity?

-Donald

Hi Donald,

I'm not quite sure what you are asking. The answer is probably Yes as the FAQs here are all articles linked through ChronoConnectivity - though when you view a FAQ you are are actually seeing a ChronoForm.

Bob

PS For example, the ChronoForm version of one of the first FAQs is here and the article view of the same FAQ is here

Hi GreyHead,
What I am looking for is pretty straightforward. Using chronoconnectivity to display a list using the fields in a database, I would like to have a link called for example "details" that when you click it you are taken to a Joomla! article. I can set up the details link using previous tutorials where Details:Details is added to the Front-end list settings "View List Fields" and "Details" to the "Edit" field. Then normally I would hook it up to a chronoform using the Front Editing tab. but what I would like to do instead, is somehow link directly to an article. I could add a field in the db table to identify the specific article (like the category and article ID) but not sure what to do with it from there...

Thanks!
-Donald

Hi Donald,

I'd use a Custom Listing (it may be possible with the Auto-Listing but I'm not sure how). If you have the article id in the database table then you can build a link in the Body box:

<td><a href='index.php?option=com_content&view=article&id=<?php echo $row['article_id']; ?>' >[ Details ]</a></td>

Bob