The general concept: I am creating a newspaper website which articles (created from a Seblod form) and newspaper issues (for the moment Categories created using Seblod form). I want the following: When a user creates an article, he assigns it an issue (April 2016 for example). The article stays hidden until the editor-in-chief publishes the issue at which point every article in that issue goes published.
How I implemented it: I used categories as issues. I didn't manage to create such workflow with simple state variables or other article-like content.
My question: How do I only list articles whose category is published on the website?
OR: How do I implement such a workflow differently?
Hi,
if you know sql you could use this plugin
https://www.seblod.com/store/extensions/19157
in append mode to add right join of categories table with right published condition, something like
RIGHT JOIN #__categories AS cat ON t1.catid = cat.id AND cat.published=1
Hi Klas,
The solution you are proposing looks good. However, I am surprised: Joomla, by default, only lists articles whose category are published. Should it not be some kind of a default feature for SEBLOD? (Note also, that when I click on article with unpublished category to see it fully, Joomla returns an error saying I can't access this resource.)
Seblod is not using categories for search unless you add them to the search type, the same with any other condition like published or unpublished articles - everything is set by the user.