Syntax needed to display K2 items and images

More
5 years 7 months ago - 5 years 7 months ago #42329 by coreycorey
Hello,
I'm running K2 and hold most articles as K2 items.
Can you kindly provide the syntax to pull K2 items and their image (blog items in particular) into the timeline, please?
The items are front-end displayed from this K2blogURL

Kind regards
D
Last edit: 5 years 7 months ago by coreycorey.

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

More
5 years 7 months ago #42330 by nordmograph
Hello Corey,

You can try this:

SELECT DISTINCT(c.created) AS date, c.id, c.catid, c.title , c.alias, c. introtext AS description
FROM #__k2_items c
JOIN #__viewlevels v ON c.access = v.id
WHERE c.published='1' AND c.catid!='2'
GROUP BY c.created ORDER BY c.created



Add this to the expert mode of the module. It won't display images, but let see if it works for now.
Hope it helps. Let me know

- 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.

Time to create page: 0.336 seconds
Powered by Kunena Forum
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.