Home >	Contents >	Index >
Template Tag 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="assetsetname"
      [LIST="attriblist"]
      [MAXCOUNT="rowcount"]
      [METHOD="random|highest"] 
      [IMMEDIATEONLY="true|false"]
      LISTVARNAME="varname"/> 

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
• attributename - Name of attribute to sort by or has one of the following special values:
  _RATING_ - Order by asset rating (Sites-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 Sites-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 Sites-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).

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.

Note The attribute ordering values ascending and descending operate in the reverse manner from what might be logically expected. Therefore, if ascending order is specified, the ordinally lowest value will occur last in the result list.

Example

<!-- Apply a sort list to an assetset and retrieve a resultset list -->
<ASSETSET.GETASSETLIST 
      NAME="myasset"
      LIST="listout"
      LISTVARNAME="aslist"/>

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