Home > Contents > Index >
ASSETSET.GETMULTIPLEVALUES
Scatters attribute values from several attributes (and potentially more than one product) into several specified lists. This tag executes a single SQL query in order to perform its function. (It is therefore much more efficient than using ASSETSET.GETATTRIBUTEVALUES repeatedly for multiple attribute values.)
Syntax
<ASSETSET.GETMULTIPLEVALUES NAME="assetset name" LIST="list name" [BYASSET="true|false
"] [IMMEDIATEONLY="true|false
"] PREFIX="prefix"/>Parameters
NAME (required)
- Input parameter. Name of the assetset object.
LIST (required)
- Input parameter (see as output, below). List of attribute names to scatter. This list has three columns:
attributetypename
attributename
direction
(Possible values include:none
,ascending
, ordescending
. If theBYASSET parameter
is set totrue
the value of this column must be set tonone
.)BYASSET (optional)
- Input parameter. Boolean value indicating whether to scatter a different instance of each attribute for each individual asset in the assetset (
true
), or to group all the attribute values for all assets together into one list per attribute (false
). The default isfalse
.
IMMEDIATEONLY (optional)
- Input parameter. Boolean value indicating whether to scatter inherited attribute values or not. A
false
value indicates that inherited values should be scattered (the default).
PREFIX (required)
- Input parameter. Starting part of the list names that this tag creates.
LIST
- Output parameter. If
BYASSET
isfalse
, creates a set of lists with the names:prefix:attrname
. IfBYASSET
istrue
, creates a set of lists with the names:prefix:assetid:attrname
. If any list is empty (that is, has no values), does not create, change, or clear the list of that name at all.
Description
ASSETSET.GETMULTIPLEVALUES
, as a highly efficient tag, is a good choice when the goal is to display a fixed-format table of assets, or to obtain many attributes of a single asset (such as for a product detail page).
ASSETSET.GETMULTIPLEVALUES
has the following limitations:
- Only non-foreign attributes can be scattered.
- Text-type attributes cannot be scattered.
- No lists will be created or destroyed for any attributes which would return no values.
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.
The ordering values Note
ascending
anddescending
operate in the reverse manner from what might be logically expected. Therefore, ifascending
order is specified, the ordinally lowest value will occur last in the result list.Example
<ASSETSET.GETMULTIPLEVALUES NAME="as" LIST="fields" PREFIX="at" BYASSET="true"/>
Home > Contents > Index > ![]()
FatWire XML Tag Reference
Copyright 2005 by FatWire Software
All rights reserved.