Home >	Contents >	Index >

Template Tags TOC   |    Alpha TOC   |    Tag Family TOC   |    Purpose TOC   |    Annotated TOC   |    Index

assetset:getassetlist

Retrieves an ordered list of assets, given optional sort criteria.

Syntax

<assetset:getassetlist
      name="assetset name"
      [list="sort attribute list"]
      [maxcount="maximum row count"]
      [method="random|highest"]
      [immediateonly="true|false"]
      [distinctonly="true|false"]
      listvarname="list name"/> 

Parameters

name (required)

Input parameter. Name of an assetset object.

list (optional)

Input parameter. Name of the list that determines sort order. This list has three columns:

• attributetypename - Name of attribute asset type to sort on.
• attributename - Name of attribute to sort by, or one of the following special values:
  _RATING_ - order by asset rating (Engage only)
  _ASSETTYPE_ - order by asset type
  
• direction - Either ascending or descending

maxcount (optional)

Input parameter. Maximum number of rows to return in the list. A value of 0 (zero) indicates all. If count is less than the number of items, then items are selected based on rating. Use method argument to customize the selection.

This parameter is meaningful only in the context of Engage.

method (optional)

Input parameter. Required only if the value of maxcount is less than the number of items described. method can have one of the following values:

• random - Random weighted selection based on rating.
• highest - Best selection based on rating.

This parameter is meaningful only in the context of Engage.

immediateonly (optional)

Input parameter. Boolean value indicating whether to consider inherited attribute values or not. A false value indicates that inherited values should be considered (the default).

distinctonly (optional)

This selects only the first combination of sorted values for each asset. Addition of feature for Irish Times.

listvarname (required)

Input and output parameter. As input, name of the list that holds the assigned values on output. The list has the following columns:

• assettype
• assetid
• A column for each sort attribute name, prefixed by the string SORT_.

Description

Each row in the ordered list holds a value for each attribute that is used for sorting. For example, if an assetset represents a product that has two authors, (say Fred and Sam), and the result is specified to sort by author, then the result set has a column called SORT_author, with two rows (one for Fred and one for Sam).

NOTE: This tag also causes dependencies to be recorded for all assets that contribute to the returned lists, or if this assetset object is not an enumerated one, then the equivalent of render:unknowndeps will be performed.

This tag is often used in conjunction with the assetset:getmultiplevalues tag, which is used to retrieve the attribute values for the assets found with this tag.

Note If you sort on an attribute that does not exist for some assets, those assets will be filtered from the results. It is therefore often the case that sort attributes are required attributes.

Example

This example obtains a list of assets from the assetset called myassetset. This list will include only assets that have at least one value for the bulbsize attribute, and will be ordered in lowest first order by the value of that attribute. Furthermore, if any asset has more than one value for the bulbsize attribute, it will be listed once for each value it has.

<listobject:create name="mylistobject" columns="attributetypename,attributename,direction"/>
<listobject:addrow name="mylistobject">
<listobject:argument name="attributetypename" value="PAttributes"/>
<listobject:argument name="attributename" value="bulbsize"/>
<listobject:argument name="direction" value="descending"/>
</listobject:addrow> 
<listobject:tolist name="mylistobject" listvarname="listout"/>
<!-- Apply the sort list to an assetset and retrieve a resultset list -->
<assetset:getassetlist name="myassetset" list="listout" listvarname="aslist"/>

See Also

assetset:getmultiplevalues
listobject:create
listobject:addrow
listobject:tolist

		Home >	Contents >	Index >
	Oracle JSP Tag Reference Copyright (c) 2013, 2016 Oracle and/or its affiliates. All rights reserved.