Home >	Contents >	Index >
Template Tag TOC  |   Alpha TOC  |   Tag Family TOC  |   Purpose TOC  |   Annotated TOC  |   Index

ASSET.SEARCH

Locates a list of asset primary table rows based on the asset type and a set of search criteria.

Syntax

<ASSET.SEARCH
      TYPE="asset type"
      [SUBTYPE="asset subtype"]
      PREFIX="prefix"
      [FIELDLIST="field name(s)"]
      [EXCLUDE="true|false"]
      [WHAT="*|fieldsToReturn"]
      [LIMIT="maximum assets"]
      [ORDER="order-by string"]
      LIST="list variable name" />

Parameters

TYPE (required)

Asset type of assets for which to search.

SUBTYPE (optional)

Asset subtype. For flex assets, this must be specified if asset attributes are part of the search criteria.

PREFIX (required)

Prefix for variable names used to specify search criteria .

FIELDLIST (optional)

A comma-separated list of field names that may have search criteria specified. If this argument is not specified, then all local fields are considered. The following key words represent groups of attributes: "LocalFields" - fields of the asset's primary table "Publist" - publication ids.

EXCLUDE (optional)

When set to true, it specifies to scatter all fields except those specified by the FIELDLIST parameter.

WHAT (optional)

Comma separated list of fields from the asset's primary table to return. '*' indicates return all fields.

LIMIT (optional)

Maximum number of assets to return.

ORDER (optional)

An Order-By string to add to the end of the query. You can only use fields in the asset type's primary table for the order-by string.

LIST (required)

Name of resulting list.

Description

The search criteria are gathered from Sites variables. For attributes of simple types, the variable search criteria is gathered from the following:

• prefix:attribute_op - Search operation. Valid values are =, !=, <, >, <=, >=, like, or not like.

• prefix:attribute_map - For case-insensitive search of string fields. Indicates whether to map everything to upper or lower case before performing the operation. - Valid values are none, upper, or lower.

• prefix:attribute:Total - Number of criteria for this attribute to string together with ORs.

• prefix:attribute:n - Where n is a number between 0 and prefix:attributeTotal -1 , indicating the search value.

If there is no prefix:attribute:Total variable:

• prefix:attribute - search value

Error Numbers

The possible values of errno include:

Value	Description
-105	Database error.
-10001	The implementing class is invalid.
-10002	There is a missing method for the implementing class.
-10003	The method could not be invoked successfully.
-10001	The implementing class is invalid.
-12006	There is no such asset type.
-12064	Invalid asset search criteria.

Example

This example shows a search for non-voided Articles in a certain publication with a name containing World or General.

<SETVAR NAME="searchfor:status_op" VALUE="!="/>
<SETVAR NAME="searchfor:status" VALUE="VO"/>
<SETVAR NAME="searchfor:name_op" VALUE="like"/>
<SETVAR NAME="searchfor:name:Total" VALUE="2"/>
<SETVAR NAME="searchfor:name:0" VALUE="General"/>
<SETVAR NAME="searchfor:name:1" VALUE="World"/>
<SETVAR NAME="searchfor:Publist_op" VALUE="="/>
<SETVAR NAME="searchfor:Publist:Total" VALUE="1"/>
<SETVAR NAME="searchfor:Publist:0" VALUE="968251170475"/>

<ASSET.SEARCH TYPE="Article" PREFIX="searchfor" LIST="mylist" FIELDLIST="Publist,LocalFields"/>
<CSVAR NAME="mylist.#numRows"/> assets returned<br/>
<LOOP LIST="mylist">
	 <CSVAR NAME="mylist.name"/>, <CSVAR NAME="mylist.description"/><br/>
</LOOP>

This example shows a search for flex asset Products with definition, PTypeFund, where the symbol attribute is either 'PMDEX' or 'PMDIX', regardless of case. The id and name columns will be returned in the list.

<SETVAR NAME="prd:Attribute_Symbol:Total" VALUE="2"/>
<SETVAR NAME="prd:Attribue_Symbol:0_op" VALUE="="/>
<SETVAR NAME="prd:Attribue_Symbol:0_map" VALUE="upper"/>
<SETVAR NAME="prd:Attribute_Symbol:0" VALUE="PMDEX"/>
<SETVAR NAME="prd:Attribue_Symbol:1_op" VALUE="="/>
<SETVAR NAME="prd:Attribue_Symbol:1_map" VALUE="upper"/>
<SETVAR NAME="prd:Attribute_Symbol:1" VALUE="PMDIX"/>

<ASSET.SEARCH TYPE="Products" PREFIX="prd" SUBTYPE="PTypeFund" LIST="prdlist" WHAT="id,name" FIELDLIST="Attribute_Symbol"/>
<CSVAR NAME="prdlist.#numRows"/> assets returned<br/>
<LOOP LIST="prdlist">
	 <CSVAR NAME="mylist.name"/><br/>
</LOOP>

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