Thread

Hey Everyone;

I am trying to create a list of newest images in gallery categories however I’d like all the images from the sub-category of any particular category to be included.

For example I have:

Category A
—-Category C
—-Category D
  —-Category E
Category B

I would like for when I specify category=“D” it shows images from D *and* E because E is a sub-category of D?

Does that make sense?

Cheers,
Ludwig

Moved to HowTo by Moderator

Ludwig,

I’m afraid that isn’t possible at the moment. You will have to pipe your parent and sub categories.

category="D|E"

You are welcome to make a Feature Request for it. A custom query would also do it. Something like below should work but would need tweaking.

{exp:query sql="SELECT cat_id FROM exp_gallery_categories WHERE gallery_id= '1' AND parent_id= '3' ;"}

{exp:gallery:entries gallery="{gallery_name}" orderby="entry_date" category="{cat_id}|3"}

{entries}

{row}

<a href="http://{id_path=gallery/image_med}">{image_url}</a>
<div class="title">{title}

{/row}

{/entries}
{/exp:gallery:entries}
{/exp:query}

Won’t that create multiple requests asking for the latest in D and E and then D and F and then D and G which means D gets repeated for each sub-album. Ie, it creates multiple queries instead of combining them into one?

Anyway, this code is just not displaying anything :

{exp:query sql="SELECT cat_id FROM exp_gallery_categories WHERE gallery_id='1' AND parent_id='{embed:ministry_gallery}' ;"}
{exp:gallery:entries gallery="photos" category="{cat_id}|{embed:ministry_gallery}" orderby="date" columns="5" rows="2" dynamic="off"}
<li><a href="http://{id_path=photos/photo}cat/{category_id}">{thumb_url}</a></li>
{/exp:gallery:entries}
{/exp:query}

Ludwig ,

You are missing some of my example code, specifically the {entries} and {row} tag and you have orderby=“date” rather than orderby=“entry_date”

{exp:query sql="SELECT cat_id FROM exp_gallery_categories WHERE gallery_id='1' AND parent_id='{embed:ministry_gallery}' ;"}
{exp:gallery:entries gallery="photos" category="{cat_id}|{embed:ministry_gallery}" orderby="entry_date" dynamic="off"}

{entries}

{row}

<li><a href="http://{id_path=photos/photo}cat/{category_id}">{thumb_url}</a></li>

{/row}

{/entries}
{/exp:gallery:entries}
{/exp:query}

Oh! I now see pictures but as I feared the images from Category D are being repeated for each sub-category under it.

Ludwig, are there some unresolved Tech Support issues left? If you want to discuss the in some more depth, I can move the thread over to Howto. Otherwise (or in addition), I’d suggest a Feature Request.

Ingmar, I guess this needs to continue as a How-to?

Thanks!

Moving..