Category

Topic Author
Visitor

5 years 1 month ago #43205 by

Category was created by

Hi Support,

I noticed that this module does not allow to select a specific Joomla Category when we select "latest Joomla article" as source.
Can you advise how we can achieve this ? as we need only articles from one category, not all of them.
Thanks.

edit: I also have a suggestion for this module, where can I post ? It's a suggestion for it.

Please Log in or Create an account to join the conversation.

nordmograph
Offline
Moderator

5 years 1 month ago #43218 by nordmograph

Replied by nordmograph on topic Category

Hello Tropical,

Sorry for the late reply.
You can use the expert query or the wizard to set a specific category with the related category ID.

If you use the expert mode it would be something like:

Code:

SELECT DISTINCT(c.created) AS date, c.id, c.catid, c.title , c.alias, c. introtext AS description, c.images AS image 
			FROM #__content c
			JOIN #__viewlevels v ON c.access = v.id
			WHERE c.state='1' AND (c.language='*' OR c.language='[LANGTAG]') 
			AND c.catid!='XXX' 
			GROUP BY c.created ORDER BY c.created

Replacing XXX by the specific category ID.

Let me know if this is waht you seeked.

For your sugggestion to this module, please post another topic.

- Need help? Post the URL of the related page (eventualy as confidential info), it will help solve your issue faster.
- An error, notice or warning? report the exact message including the line number
- If you get a white page , enable error reporting and / or check your server error logs.

Please Log in or Create an account to join the conversation.

Topic Author
Visitor

5 years 1 month ago #43247 by

Replied by on topic Category

Hey support, yes, I can confirm this works. But as a proposal, can't this be made easier, just like a user can select their category and not have a complex process ?
Cheers

Please Log in or Create an account to join the conversation.

Time to create page: 0.314 seconds

Featured Apps

Shop Account

Misc.

Disclaimer: Nordmograph is not affiliated with or endorsed by The Joomla! Project™. Any products and services provided through this site are not supported or warrantied by The Joomla! Project or Open Source Matters, Inc. Use of the Joomla!® name, symbol, logo and related trademarks is permitted under a limited license granted by Open Source Matters, Inc.

Category

Featured Apps

Shop Account

Misc.

Follow Us