1. AdvSearch
      1. AdvSearch.AdvSearch
        1. AdvSearch.AdvSearch.tpl
        2. AdvSearch.Advsearch.paging1Tpl
        3. AdvSearch.AdvSearch.paging0Tpl
        4. AdvSearch.AdvSearch.containerTpl
        5. Advsearch.AdvSearch.extractTpl
      2. AdvSearch.AdvSearchHelp
        1. AdvSearch.AdvSearchHelp.helplinkTpl
      3. AdvSearch.AdvSearchForm
        1. Advsearch.AdvSearchForm.tpl
    2. userTools
    3. ActivationEmail
    4. BotBlockX
    5. CacheClear
    6. CacheMaster
    7. Canonical
    8. Captcha
    9. CaseInsensitiveURLS
    10. ClassExtender
    11. ConstantContact
    12. ConvertDatabaseCharset
    13. DefaultResourceGroup
    14. DefaultUserGroup
    15. DirWalker
    16. EmailResource
    17. EZfaq
    18. FileUpload
    19. FixedPre
    20. getDynaDescription
    21. GoRevo
    22. LexiconHelper
    23. LogLogins
    24. LogPageNotFound
    25. MandrillX
    26. MessageManager
    27. NewsPublisher
    28. Notify
    29. ObjectExplorer
    30. Orphans
    31. Personalize
    32. QuickEmail
    33. ReflectBlock
    34. RefreshCache
    35. SiteAtoZ
    36. SiteCheck
    37. SizeMatters
    38. SPForm
    39. StageCoach
    40. Subscribe
    41. SyntaxHighlighter
    42. ThermX
    43. UpgradeMODX
    44. cookieJar
    45. getYoutube
    46. aliasid
    47. AddHeaderfiles
    48. AjaxUpload
    49. amazonSES mailing list
    50. Analytics
    51. Archivist
      1. Archivist.Archivist
        1. Archivist.Archivist.tpl
      2. Archivist.ArchivistGrouper
      3. Archivist.getArchives
        1. Archivist.getArchives.tpl
    52. Articles
      1. Articles.Theming Articles
      2. Articles.Roadmap
      3. Articles.Retrieving Articles Outside of Articles
      4. Articles.Creating a Blog
    53. Babel
      1. Babel.BabelLinks
      2. Babel.BabelTranslation
    54. BannerX
    55. BannerY
    56. Batcher
      1. Batcher.Roadmap
    57. bdListings
      1. bdListings.bdCategories
      2. bdListings.bdHookNewListing
      3. bdListings.bdListings
      4. bdListings.bdPriceGroups
      5. bdListings.bdRedirect
      6. bdListings.bdTargets
    58. boilerX
      1. bx-head-open
      2. bx-head-append
      3. bx-head-close
      4. bx-container-open
      5. bx-container-close
      6. bx-bottom-open
      7. bx-bottom-close
    59. BreadCrumb
      1. BreadCrumb.containerTpl
      2. BreadCrumb.currentCrumbTpl
      3. BreadCrumb.linkCrumbTpl
      4. BreadCrumb.maxCrumbTpl
      5. BreadCrumb.categoryCrumbTpl
      6. BreadCrumb.homeCrumbTpl
    60. Breadcrumbs
    61. BxrExtra
    62. cachebuster
    63. CamperManagement
      1. CamperManagement.Customizing the Component
      2. CamperManagement.Developing the front-end
        1. CamperManagement.cmCamperDetails Snippet
        2. CamperManagement.cmCampers Snippet
        3. CamperManagement.Placeholders you can use
      3. CamperManagement.Managing your vehicle
      4. CamperManagement.Module home
    64. Church Events Calendar
      1. ChurchEvents.MODX Manager functions
      2. ChurchEventsCalendar Snippet
        1. ChurchEvents.Managing events
      3. ChurchEventsList Snippet
      4. ChurchEventsRss Snippet
    65. Cliche
    66. ClientConfig
    67. CMPGenerator
      1. CMPGenerator.5 minute example
      2. CMPGenerator.Foreign Databases
    68. Collections
    69. ContextRouter
    70. CookieList
    71. CronManager
    72. cssSweet
      1. cssSweet.lighten
      2. cssSweet.modval
      3. cssSweet.prefix
    73. CustomUrls
    74. Databackup
    75. Discuss
      1. Discuss.ChunkMap
      2. Discuss.Contributing
      3. Discuss.Controllers
        1. Discuss.Controllers.board
          1. Discuss.Controllers.board.xml
        2. Discuss.Controllers.home
        3. Discuss.Controllers.login
        4. Discuss.Controllers.logout
        5. Discuss.Controllers.profile
        6. Discuss.Controllers.register
        7. Discuss.Controllers.search
        8. Discuss.Controllers.thread
      4. Discuss.Creating a Discuss Theme
      5. Discuss.Database Model
      6. Discuss.Features
      7. Discuss.Getting Started
      8. Discuss.Installation
        1. Discuss.Installation from Git
      9. Discuss.Roadmap
      10. Configuring Sphinx for Search
    76. DitsNews
    77. Eletters
      1. Eletters.API
      2. Eletters.FormIt
      3. Eletters.Import CSV
      4. Eletters.Templates
    78. EventManager
      1. EventManager.emListEvents
      2. EventManager.emNewReservationHook
    79. eventsCalendar2
      1. eventsCalendar2.eventsCalendar2
      2. eventsCalendar2.Generating events
      3. eventsCalendar2.tplCalendar2
      4. eventsCalendar2.tplCell2
      5. eventsCalendar2.tplEvent2
      6. eventsCalendar2.tplHead2
    80. EventsX
      1. EventsX.Examples
    81. ExerPlan
    82. fastField
    83. FileDownload R
      1. FileDownload R.FileDownload
      2. FileDownload R.FileDownloadLink
      3. FileDownload R.Plugins
    84. FileLister
      1. FileLister.FileLister
        1. FileLister.FileLister.directoryTpl
        2. FileLister.FileLister.fileLinkTpl
        3. FileLister.FileLister.fileTpl
        4. FileLister.FileLister.pathTpl
      2. FileLister.Roadmap
    85. FirstChildRedirect
    86. Flexibility
    87. ForcedPasswdChange
    88. FormIt
      1. FormIt.FormItCountryOptions
      2. FormIt.FormItRetriever
      3. FormIt.FormItStateOptions
      4. FormIt.Hooks
        1. FormIt.Hooks.email
        2. FormIt.Hooks.FormItAutoResponder
        3. FormIt.Hooks.math
        4. FormIt.Hooks.recaptcha
        5. FormIt.Hooks.redirect
        6. FormIt.Hooks.spam
        7. FormIt.Hooks.FormItSaveForm
      5. FormIt.Roadmap
      6. FormIt.Tutorials and Examples
        1. FormIt.Examples.Custom Hook
        2. FormIt.Examples.Simple Contact Page
        3. FormIt.Handling Selects, Checkboxes and Radios
        4. FormIt.Using a Blank NoSpam Field
        5. Form and anchors
      7. FormIt.Validators
    89. FormIt2db
    90. FormitFastPack
      1. FormitFastPack Tutorial
      2. fieldSetDefaults
      3. field
      4. fiGenerateReport
      5. fiProcessArrays
    91. FormSave
    92. FoundationX
      1. FoundationX.How to Use FoundationX
    93. FX2themebase
      1. FX2.How to Use FX2
        1. FX2.For Theme Authors
      2. FX2.Included Extras
    94. Gallery
      1. Gallery.Example1
      2. Gallery.Gallery
        1. Gallery.Gallery.containerTpl
        2. Gallery.Gallery.thumbTpl
        3. Assigning a Gallery album to a specifc resource
      3. Gallery.GalleryAlbums
        1. Gallery.GalleryAlbums.rowTpl
        2. Gallery.GalleryAlbums.containerTpl
      4. Gallery.GalleryItem
        1. Gallery.GalleryItem.albumTpl
        2. Gallery.GalleryItem.GalleryItemPagination
        3. Gallery.GalleryItem.tagTpl
        4. Gallery.GalleryItem.tpl
      5. Gallery.Plugins
        1. Gallery.Plugins.Galleriffic
        2. Gallery.Plugins.Slimbox
      6. Gallery.Roadmap
      7. Gallery.Setting Up the GalleryItem TV
      8. Gallery.Setting Up Your Gallery
    95. GatewayManager
    96. gCal
    97. getDate
    98. getFeed
      1. getFeed.Adding a Twitter Feed
    99. getPage
    100. getRelated
    101. getResourceField
    102. getResources
      1. getResources.Examples
        1. getResources.Building a RSS feed
        2. getResources.Category Index Page with Thumbnails
        3. getResources.Google XML Sitemap
    103. getUrlParam
    104. getRTImages
    105. getVimeo
    106. GoogleSiteMap
      1. GoogleSiteMap.GoogleSiteMap
        1. GoogleSiteMap.GoogleSiteMap.containerTpl
        2. GoogleSiteMap.GoogleSiteMap.itemTpl
      2. GoogleSiteMap.Roadmap
      3. GoogleSiteMapVersion1
    107. GridClassKey
    108. HandyMan
      1. HandyMan.Frequently Asked Questions
      2. HandyMan.Installation
      3. HandyMan.Roadmap
    109. Hits
    110. HitsPage
    111. HybridAuth
      1. HybridAuth.Integrating Facebook
      2. HybridAuth.Integrating Google
      3. HybridAuth.Integrating Twitter
      4. HybridAuth.Integrating VK.com
    112. If
    113. Image+
    114. imageHERE
    115. ImageStyles
    116. ImportX
    117. LexRating
    118. Lingua
    119. Login
      1. Login.ChangePassword
      2. Login.ConfirmRegister
      3. Login.ForgotPassword
      4. Login.Login
      5. Login.Profile
      6. Login.Register
        1. Register.Example Form 1
      7. Login.ResetPassword
      8. Login.Roadmap
      9. Login.Tutorials
        1. Login.Basic Setup
        2. Login.Extended User Profiles
        3. Login.Request Membership
        4. Login.User Profiles
        5. Login.Using Custom Fields
        6. Login.Using Pre and Post Hooks
      10. Login.UpdateProfile
    120. Loginza
      1. Loginza.Loginza
      2. tpl.Loginza.login
      3. tpl.Loginza.logout
      4. tpl.Loginza.profile
    121. mChimpX
    122. MetaX
    123. mhPayPal
      1. mhPayPal.Snippet Usage
        1. mhPayPal.Snippet Usage.Hooks
        2. mhPayPal.Snippet Usage.Templating
    124. MIGX
      1. MIGX.Backend-Usage
      2. MIGX.Data-Entry
      3. MIGX.Frontend-Usage
      4. MIGX.Tutorials
        1. MIGX.Fancybox-images with seperate placeholders in Richtext-Content
        2. MIGX.Simple opening hours table
        3. Using resource-specific mediasource and multifile-uploader with MIGX
        4. MIGX.Varying layout-boxes
          1. MIGX.Varying layout-boxes.Configurator-Version
        5. Creating Selectable and Sortable lists for MIGX
        6. MIGX.sortable resourcelist
        7. Using resource-specific mediasource and multifile-uploader with MIGX (Old Version)
        8. MIGX.Using Grid Inline Editing
    125. MIGXdb
      1. MIGXdb.Configuration
      2. MIGXdb.Tutorials
        1. MIGXdb.Create a basic gallery-management from scratch with MIGXdb
          1. Add resource-specific mediasource and multifile-uploader to the gallery
          2. Add Image-Tagging to the Gallery
        2. MIGXdb.Create doodles manager with help of MIGXdb
        3. MIGXdb.Manage Child-Resources in a grid-TV with help of MIGXdb
        4. MIGXdb.Manage Events-Resources in a CMP with help of MIGXdb
      3. MigxCalendars
    126. MinifyX
    127. miniShop2
      1. miniShop.Screenshots
    128. modActiveDirectory
    129. ModDef
    130. modExtra
    131. modMobile
    132. modSwiftMailer
    133. mxCalendar
      1. mxCalendar.Examples
      2. mxCalendar.Placeholders
    134. mxExtendedMenu
    135. mxFormBuilder
      1. mxFormBuilder.Create Form
      2. mxFormBuilder.Hooks
      3. mxFormBuilder.Field Types
      4. mxFormBuilder.Create Form List in TV
      5. mxFormBuilder.Fields
    136. mxHasTvs
    137. MoneyBird
      1. MoneyBird.Contacts
      2. MoneyBird.Invoices
      3. MoneyBird.NrFormat
    138. ObfuscateEmail-Revo
    139. PackMan
      1. PackMan.Roadmap
    140. PageBreaker
      1. PageBreaker.PageBreaker
      2. tpl.PageBreaker.ajax
      3. tpl.PageBreaker.navigation
    141. Peoples
      1. Peoples.PeopleGroup
        1. Peoples.PeopleGroup.userTpl
      2. Peoples.PeopleGroups
        1. Peoples.PeopleGroups.tpl
      3. Peoples.Peoples
        1. Peoples.Peoples.tpl
      4. Peoples.Roadmap
    142. PHP Tidy (plugin)
    143. phpThumbOf
    144. Polls
      1. Polls.Polls
      2. Polls.PollsLatest
      3. Polls.PollsPrevious
      4. Polls.PollsResult
    145. POI Manager
    146. QuickCrumbs
      1. QuickCrumbs.Example
    147. Quip
      1. Quip.Quip
        1. Quip.Quip.tplComment
        2. Quip.Quip.tplCommentOptions
        3. Quip.Quip.tplComments
        4. Quip.Quip.tplReport
      2. Quip.QuipCount
      3. Quip.QuipLatestComments
      4. Quip.QuipReply
        1. Quip.QuipReply.tplAddComment
        2. Quip.QuipReply.tplLoginToComment
        3. Quip.QuipReply.tplPreview
      5. Quip.QuipRss
      6. Quip.Roadmap
      7. Quip.Upgrading
        1. Quip.Upgrading to 1.0.1
    148. Rampart
      1. Rampart.hook.RampartFormIt
      2. Rampart.hook.RampartQuip
      3. Rampart.preHook.RampartRegister
    149. Redirector
    150. renderResources
    151. ResourceWatcher
    152. RezImgCrop
    153. Rowboat
      1. Rowboat.Rowboat
    154. sekFancyBox
      1. sekFancyBox & Gallery
    155. sekFormTools
      1. sekFormTools.input.autocomplete
      2. sekFormTools.input.combobox
      3. sekFormTools.input.datepicker
      4. sekFormTools.input.helper
      5. sekFormTools.input.textfield
      6. sekFormTools Advanced Examples
    156. sekSiteTools
      1. sekSiteTools.easytabs
      2. sekSiteTools.google.analytics
      3. sekSiteTools.printdiv
    157. sekUserGalleries
      1. sekUserGalleries.album.items.helper
      2. sekUserGalleries.album.items.manage
      3. sekUserGalleries.album.manage
      4. sekUserGalleries.album.view
      5. sekUserGalleries.browse.galleries
      6. sekUserGalleries.directory
      7. sekUserGalleries.image.information
      8. sekUserGalleries.search
      9. sekUserGalleries.users.gallery.manage
      10. sekUserGalleries.users.gallery.view
    158. selfLink
    159. Shopkeeper
    160. siblingNav
    161. SimpleCart
    162. SimpleSearch
      1. SimpleSearch.Roadmap
      2. SimpleSearch.SimpleSearch
        1. SimpleSearch.Faceted Search Through PostHooks
        2. SimpleSearch.SimpleSearch.containerTpl
        3. SimpleSearch.SimpleSearch.currentPageTpl
        4. SimpleSearch.SimpleSearch.pageTpl
        5. SimpleSearch.SimpleSearch.tpl
      3. SimpleSearch.SimpleSearchForm
        1. SimpleSearch.SimpleSearchForm.tpl
      4. SimpleSearch.Solr
    163. SiteEditor
    164. sitemapFriend
    165. Slideshow Manager
      1. jgSlideshow Snippet
      2. Slideshow Manager CMP
    166. sLink
    167. SmartOptimizer
    168. SmartTag
    169. StatCache
    170. SocialLogin
    171. SocialSuite
      1. SocialSuite.getFacebookPhotos
      2. SocialSuite.getFacebookProfile
      3. SocialSuite.getFacebookShares
      4. SocialSuite.getGooglePlusShares
      5. SocialSuite.getTwitterProfile
      6. SocialSuite.prettyNumbers
    172. spieFeed
    173. StaticSaver
    174. StoreLocator
    175. SubscribeMe
      1. SubscribeMe.Configuring API Credentials, IPN and going Live
      2. SubscribeMe.Setting up the Payment Flow
        1. SubscribeMe - Listing the Products
        2. SubscribeMe - Setting up the Payment Methods
        3. SubscribeMe - Subscription Confirmation Page
      3. SubscribeMe.User Account Management
    176. SyntaxChecker
    177. Tagger
    178. TaggingAtoZ
    179. tagLister
      1. tagLister.getResourcesTag
      2. tagLister.tagLister
        1. tagLister.tagLister.all
        2. tagLister.tagLister.tpl
      3. tagLister.tolinks
        1. tagLister.tolinks.tpl
    180. TinyMCE
      1. TinyMCE.Spellchecker
      2. TinyMCE.Table controls
      3. TinyMCE.Template
    181. Upload to Users CMP
    182. VersionX
      1. VersionX.Roadmap
    183. virtuNewsletter
      1. Mailgun integration
    184. Wayfinder
      1. Wayfinder Introductory Examples
    185. xFPC

getResources

Last edited by Dimitri Hilverda on Oct 27, 2017.
This is a user-contributed Extra. If you find issues or would like more info or help, please contact the author.

What is getResources?

A general purpose Resource listing and summarization snippet.

Requirements

  • MODX Revolution 2.0.0-beta5 or later
  • PHP5 or later

History

getResources was first written by Jason Coward (opengeek) and released on June 30th, 2009.

Download

It can be downloaded from within the MODX Revolution manager via Package Management, or from the MODX Extras Repository, here: http://modxcms.com/extras/package/552

It is NOT a replacement for Ditto, but rather an alternative component that can accomplish some of the things that the more specialized components do, i.e. Ditto, Wayfinder, Breadcrumbs; basically anything that output the properties for a list of Resources (formerly Documents in MODX Evolution).
Documentation and tutorials on Russian can be found here: http://modx.by/docs/modx-add-ons/getresources/

Usage

The getResources snippet can be called using the tag:

    [[getResources]]

Prior to version 1.6.1-pl, calls without the &tpl property specified will output an array of each Resource in the result set, and its fields. Since version 1.6.1-pl this behaviour has changed and you will have to use "&debug=`1`" to get the full result:

    [[getResources? &debug=`1`]] [[getResources? &parents=`choose_an_id` &debug=`1`]]

Available Properties

Templating Properties

Name Description Default Value Added in version
tpl Name of a chunk serving as a resource template. If not provided, properties are dumped to output for each resource
tplOdd Name of a chunk serving as resource template for resources with an odd idx value (see idx property)
tplFirst Name of a chunk serving as resource template for the first resource
tplLast Name of a chunk serving as resource template for the last resource
tpl_N Name of a chunk serving as resource template for the Nth resource, for example &tpl_4=`tpl4th`
tpl_nN Name of a chunk serving as resource template for every Nth resource, for example &tpl_n4=`tpl4th` would apply to any item divisible by 4 1.4.1
tplCondition Defines a field of the resource to evaluate against keys defined in the &conditionalTpls property. Must be a resource field; does not work with Template Variables. 1.5.0
conditionalTpls A JSON object defining a map of field values and the associated tpl Chunks to use when the field defined by &tplCondition matches the value : &conditionalTpls=`{"1":"tplA","2":"tplB","3":"tplC"}`
[NOTE: tplOdd, tplFirst, tplLast, * and tpl_{n} will take precedence over any defined conditionalTpls]
1.5.0
tplPath An optional directory to look for file-based chunks when using @FILE assets_path+ "elements/chunks/"
tplWrapper Name of a chunk serving as a wrapper template for the output [NOTE: Does not work with toSeparatePlaceholders]. The placeholder where the items are inserted is [[+output]]. 1.6.0
wrapIfEmpty If true, will output the wrapper specified in &tplWrapper even if the output is empty. false 1.6.0
outputSeparator An optional string to separate each tpl instance (delimiter) "\n"
toPlaceholder If set, will assign the result to this placeholder instead of outputting it directly.
toSeparatePlaceholders If set, will assign EACH result to a separate placeholder named by this param suffixed with a sequential number (starting from 0). 1.3.0
@FILE and @INLINE tpls
You can prefix any tpl property with @FILE or @INLINE to use a file-based chunk or inline markup respectively.
  • @FILE— This prefix allows you to provide a file instead of a Chunk in the database as the tpl. The path and filename you specify will by default, unless you specify a custom tplPathproperty, searche for the @FILE tpl relative to your configured assets_path + "elements/chunks/".
  • @INLINE— This prefix allows you to provide markup to use for your tpl directly in the property value. It is recommended you use this only when specifying the tpl* properties in a [Property Set], otherwise any placeholders in your inline markup may be evaluated before the content gets passed to getResources, since cacheable nested tags in MODX Revolution are evaluated before processing of the containing tag begins. This must be followed by a space, e.g. "@INLINE
  • [[+pagetitle]]
  • "

Selection Properties

Name Description Default Value Added in version
parents Comma-delimited list of ids serving as parents. Use -1 to ignore parents when specifying resourcesto include. If this is not done, getResources assumes &parents as the current resource and reads its children from there (plus the resources given in &resources = unexpected results). current Resource id
resources Comma-delimited list of ids to include in the results. Prefix an id with a dash to exclude the resource from the result.
depth Integer value indicating depth to search for resources from each parent. First level of resources beneath parent is depth 10
tvFilters Can be used to filter resources by certain TV values. These are entered as [( tvname)( operator)]( value). There are two delimiters you can use to combine filter conditions.

You can have "OR" filters using two pipe symbols. An OR filter fetches resources that has one of the listed TV values.

                    mytv==somevalue||mytv==othervalue
		

You can also use an "and" filter using a comma. This will make sure that all the conditions are met.

                    mytv==somevalue,othertv==othervalue
		

For advanced filtering you can also group these. It is important to know that conditions are first separated based on the OR (||) delimiter, and after that on the AND (,) delimiter. So let's take this hypothetical example:

                    mytv==foo||mytv==bar,bartv==3||bartv==1
		

This will filter resources to meet one of the following conditions:

  • mytv is LIKE foo, or
  • mytv is LIKE bar AND bartv is LIKE 3, or
  • bartv is LIKE 1
    The examples above search for exact values. You can also use the percentage sign (%) as a wildcard. For example:
                    mytv==%a%
		

Matches any resources that has an "a" in the mytv value.

                    mytv==a%
		

Matches any resources that have a mytv value that starts with an "a"

                    mytv==%a
		

Matches any resources that have a mytv value that ends with an "a".

You can also combine this with the OR (||) and AND (,) delimiters explained above.

It is important to know that this function looks at the raw value of a template variablefor a specific resource. This means that the value has been explicitly set for the resource, and that it has not been processed by a template variable output type( or is the default value in releases prior to 1.4.2-pl; this release adds support for filtering that includes default values). So if you have an "autotag" tv, this means the raw value is a comma delimited list, and it is not split up in tags like you see it in the manager.
New filter operators available in 1.4.2-pl
Starting with release 1.4.2-pl of getResources, there are a number of new comparison operators for use when creating filter conditions. In addition, when using many of these new operators, numeric comparison values are automatically CAST TV values to numeric before comparison. Here is a list of the valid operators:
Filter Operator SQL Operator CASTs numerics Notes
<=> <=> Yes NULL safe equals
=== = Yes
!== != Yes
<> <> Yes
== LIKE No
!= NOT LIKE No
<< < Yes
<= <= Yes
=< =< Yes
>> > Yes
>= >= Yes
=> => Yes
sortby Any Resource Field (excluding Template Variables. See below for the 'sortbyTV' property). Some common fields to sort on are publishedon, menuindex, pagetitle etc, but see the Resources documentation for all fields. Specify fields with the name only, not using the tag syntax. Note that when using fields like template, publishedby and the likes for sorting, it will be sorted on the raw values, so the template or user ID, and NOT their names.

You can also sort randomly by specifying RAND(), like so:
                    &sortby=`RAND()`
		

From version 1.3.0 this can also be a JSON array to sort on multiple fields, e.g.

                    &sortby=`{"publishedon":"ASC","createdon":"DESC"}`
		

To sort in a specific order, specify a resource id-list, e.g.

                    &sortby=`FIELD(modResource.id, 4,7,2,5,1 )`
		

The same thing is possible if you put the sorted IDs in a template variable, like this:

                    &sortby=`FIELD(modResource.id,[[*templateVariable]])`
		

In some cases you need to (somewhat counterintuitively) specify the sort direction as well:

 
&sortby=`FIELD(modResource.id, 4,7,2,5,1 )` &sortdir=`ASC`
createdon
publishedon Modified in 1.3.0
sortbyAlias Query alias for sortby field
sortbyEscaped Escapes the field name specified in sortby
sortdir Order which to sort by DESC
sortbyTV Template Variable to sort by 1.2.0
sortdirTV Order which to sort by when using sortbyTV DESC 1.2.0
sortbyTVType Specify the data type of the sortby TV. Possible values are string, integer, decimal, datetime string 1.3.0
limit Limits the number of resources returned. Use `0` for unlimited results. 5
offset An offset of resources returned by the criteria to skip 0
where A JSON-style expression of criteria to build any additional where clauses from. See below for an example. See display/xPDO20/xPDOQuery.where
context Comma-delimited list of context keys to limit results by; if empty, contexts for all specified parents will be used (all contexts if 0 is specified)

Other Properties

Name Description Default Value Added in version
showUnpublished If true, will also show Resources if they are unpublished. 0
showDeleted If true, will also show Resources regardless if they are deleted. 0
showHidden If true, will show Resources regardless if they are hidden from the menus. 0
hideContainers If set, will not show any Resources marked as a container (isfolder). 0
includeContent Indicates if the content of each resource should be returned in the results 0
includeTVs Indicates if TemplateVar values should be included in the properties available to each resource template 0
includeTVList An optional comma-delimited list of TemplateVar names to include explicitly if includeTVs is 1 1.4.0
prepareTVs Prepares media source-dependant TemplateVar values. 1 1.5.0
prepareTVList Limits the TVs that are prepared to those specified by name in a comma-delimited list 1.5.0
processTVs Indicates if TemplateVar values should be rendered as they would on the resource being summarized. TemplateVars must be included (see includeTVs/includeTVList) to be processed. 0
processTVList An optional comma-delimited list of TemplateVar names to process explicitly. TemplateVars specified here must be included via includeTVs/includeTVList 1.4.0
tvPrefix The prefix for TemplateVar properties tv.
idx You can define the starting idx of the resources, which is an property that is incremented as each resource is rendered 1
first Define the idx which represents the first resource 1
last Define the idx which represents the last resource. Default is # of resources being summarized + first - 1
totalVar Define the key of a placeholder set by getResources indicating the total number of Resources that would be selected notconsidering the limitvalue. total
debug If true, will send the SQL query to the MODX log. false

Available Placeholders

The placeholders available to your getResources formatting Chunks are mostly dependent on the resources that you are iterating over.

See All Tags on the "Commonly Used Template Tags" page – that lists the properties available to all resources.

If your resource has template variables, those will have corresponding placeholders (remember the placeholders will use the prefix defined by the &tvPrefixparameter).

In addition there are the following placeholders:

Placeholder Description
[[+idx]] Increases with each iteration, starting with 1 (or the value set by the &idxparameter)

Examples

Also see the Examples sub section of this documentation for more detailed examples and tutorials.

Output a list of child Resources of the current Resource, using the 'myRowTpl' chunk:

    [[!getResources? &parents=`[[*id]]` &tpl=`myRowTpl`]]

Output all resources beneath the Resource with ID '5', with the exception of resource 10, using the 'myRowTpl' chunk:

    [[!getResources? &parents=`5` &resources=`-10` &tpl=`myRowTpl`]]

Output only the resources specified, using the 'myRowTpl' chunk:

    [[!getResources? &parents=`-1` &resources=`10,11,12` &tpl=`myRowTpl`]]

Output the top 5 latest published Resources beneath the Resource with ID '5', with tpl 'blogPost':

    [[!getResources? &parents=`5` &limit=`5` &tpl=`blogPost` &includeContent=`1`]]

Output a list of child Resources of the current Resource, based on the Resource-template:

    [[!getResources? &parents=`[[*id]]` &where=`{"template:=":8}` &tpl=`myRowTpl`]]

Output a list of child Resources of the current Resource, where the Resource-template ID is 1 or 2:

    [[!getResources? &parents=`[[*id]]` &where=`{"template:=":1, "OR:template:=":2}` &tpl=`myRowTpl`]]

Output a list of child Resources of the current Resource, where the Resource-template ID is 1, 2 or 3 (you cannot use the same key name more than once):

    [[!getResources? &parents=`[[*id]]` &where=`{"template:IN":[1,2,3]}` &tpl=`myRowTpl`]]

Display a message when no results found (equivalent of "empty" parameter in Ditto):

    [[!getResources:default=`No results found`? &parents=`[[*id]]` &tpl=`myRowTpl`]]

Example using an inline Tpl

    [[!getResources? &tpl=`@INLINE <li title="[[+longtitle]]">[[+pagetitle]]</li>`]]

Wrapping a getResources result in other markup ( like an &outerTpl property, which doesn't exist for getResourcesfrom version 1.6.0 you can still do it like that or use the &tplWrapper property).

    [[getResources? ... &toPlaceholder=`results`]] [[+results:notempty=`<ol>[[+results]]</ol>`]]

Displaying Template Variables with getResources

To reduce retrieval time, getResources does not get TV values by default. If you want to display TVs, you should include the following parameters:

    &includeTVs=`1` &processTVs=`1`

You also need to either prefix all TVs with tv. or use this parameter in your snippet tag:

    &tvPrefix=``

In the Tpl chunk you use to display the getResources output, use a placeholder tag like this (but with the name of your TV):

    [[+tv.my_tv]]

Using getPage for Pagination

When combined with getPage, getResources allows you to do powerful and flexible pagination on your pages.

Examples

Grab first 10 Resources - sorted by publishedon - below the Resource ID 17, no more than 2 levels deep, with the tpl 'blogListPost', including the TVs and content:

    [[!getPage? &elementClass=`modSnippet` &element=`getResources` &parents=`17` &depth=`2` &limit=`10` &pageVarKey=`page` &includeTVs=`1` &includeContent=`1` &tpl=`blogListPost` ]] <div class="paging"> <ul class="pageList"> [[!+page.nav]] </ul> </div>

and the chunk blogListPost:

    <div class="blogPost"> <div class="date">[[+publishedon:strtotime:date=`%b %d %Y`]]</div> <h2><a href="[[~[[+id]]]]" title="[[+pagetitle]]">[[+pagetitle]]</a></h2> <p class="author"><strong>Author:</strong> <span class="author">[[+createdby:userinfo=`username`]]</span></p> <p class="summary">[[+introtext]]</p> <p class="readmore"><a href="[[~[[+id]]]]"><span>Read more</span></a></p> <div class="clear"></div> </div> <hr/>

Troubleshooting

Nothing Happens

Before you go banging your head on a wall, have you checked to make sure that this extra is actually installed on your site?

Array of Attributes is Dumped

You forgot to include the `&tpl` parameter. Without the &tplparameter, the Snippet will retrieve the specified resources, but you didn't tell it how to format them. Be sure you include the &tplparameter in your Snippet call, e.g.

    [[!getResources? &parents=`5` &limit=`5` &tpl=`blogPost`]]

OR

You misspelled the chunk name.Perhaps you DO have a &tplspecified, but does that chunk actually exist? If you name a chunk that does not exist, getResources will not know how to format your results.

OR

Even though you have correctly specified the &tplparameter, you may have inadvertently forgotten the ampersand on one of your otherparameters. E.g. limit=`5`will cause the Snippet call to fail and the attributes to be dumped. The correct format should be &limit=`5`

The same resource is output multiple times (1.2.2 and prior releases)

If you see the same resource listed multiple times, then try omitting the &sortbyTVparameter.

The Content isn't There

You are retrieving the correct resources and you are seeing someof the results formatting correctly, but your [[+content]] placeholders don't contain anything. What's going on? You must include the &includeContent=`1`argument to get the content.

Caching problems using tpl, tpl_N, tpl_nN, tplFirst, tplLast or tplOdd

If you are using this parameters you may have thought about reusing your tpl chunk to avoid repeating code. For example:

Generic Tpl Chunk: [[$GenericTplChunk]]

    <div>Hi [[+pagetitle]]</div>

Fourth Tpl Chunk ( tpl_nN): [[$4thTplChunk]]

    <div class="highlight">[[$GenericTplChunk]]</div>

If you have problems with this, having blank or strange results, is due to MODX caching. Calling the chunk uncached won't work. You have to use a trick: a dummy tag when calling the generic chunk.

    <div class="highlight">[[$GenericTplChunk? &idx=`[[+idx]]` ]]</div>

Note: You don't need to call the chunk uncached.

Seen at: http://forums.modx.com/thread/43748/chunk-inside-getresources-template-not-processed-correctly

See Also

If you only need to get a single field from a foreign resource, try using getResourceField.

Comment Policy

Comments intended to help other users with this document are welcome! If you have a suggestion for this Extra document, please attempt to contact the author directly, possibly on GitHub or in the MODX Community Forums.

Suggest an edit to this page on GitHub (Requires GitHub account. Opens a new window/tab) or become an editor of the MODX Documentation.