getResources, get the latest resource per container

Question

Using getResources, i want to get the latest resource created per container, so here's the resource tree structure:

-Parent
  --Container 1
     ---Resource 1
     ---Resource 2
     ---Latest Resource
  --Container 2
     ---Resource 1
     ---Latest Resource
  --Container 3
     ---Resource 1
     ---Resource 2
     ---Latest Resource

By using [[getResources]] how can i possibly be able to get only the resources Latest Resource?

Not exactly sure what you want listed, is it something like: - Container 1 Latest Resource - Container 2 Latest Resource - Container 3 Latest Resource ? How is "Latest Resource" determined... by the most recent to be added, published, updated, etc? — okyanet, Jun 07 '13 at 04:00
Can you just use a getResource per container? Or are they dynamically created containers? You could then sort by the publish date of the resource, eg: &sortby=`{"publishedon":"ASC"}` — MeltingDog, Jun 18 '13 at 22:39

score 0 · Answer 1 · answered Jun 21 '13 at 11:33

&parents=`1`&sortBy=`publishedOn`&sortdir=`DESC`&limit=`1`
&parents=`2`&sortBy=`publishedOn`&sortdir=`DESC`&limit=`1`
&parents=`3`&sortBy=`publishedOn`&sortdir=`DESC`&limit=`1`

You could also do a getPage with a custom Snippet grabbing the last modResource of the desired parents. The parents=... above will have to represent actual modResource IDs available in the Manager.

score 0 · Answer 2 · edited Sep 18 '13 at 14:48

You can do a nested getResources-call.

Assuming that all Containters have the same template (e.g. "3"):

getResources

[[getResources? 
       &limit=`0`
       &depth=`1`
       &where=`{"template:=":3}`
       &includeContent=`0`
       &includeTVs=`0`
       &processTVs=`0`
       &tpl=`chunk1`
]]

chunk1

[[getResources?
        &parents=`[[+id]]`
        &sortby=`{"publishedon":"DESC"}`
        &hideContainers=`1`
        &limit=`1`
        &depth=`1`
        &includeContent=`1` 
        &includeTVs=`1` 
        &processTVs=`1`
        &tpl=`chunk2`
]]

chunk2

Here you put the placeholdes you want, e.g. [[+pagetitle]], [[+content]]

getResources, get the latest resource per container

2 Answers2