Home >	Contents >	Index >

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

searchstate:addsimplelikeconstraint

Adds an attribute like name/value constraint into a new or existing searchstate object.

Syntax

<searchstate:addsimplelikeconstraint 
      name="ssname" 
      [bucket="bucketname"]
      [typename="assettype"] 
      attribute="attribname" 
      value="value"
      [immediateonly="true|false"]/> 

Parameters

name (required)

Input parameter. Name of an object representing a searchstate.

bucket (optional)

Input parameter. Bucket name. If not specified, the attribute name is used. Use this parameter to indicate which constraint you need when the same attribute is used in multiple contstraints. A bucket is an alias and functions similar to an inner join in SQL; when you have multiple tables that have columns of the same name, you must specify the table name to indicate which column you are requesting.

typename (optional)

Input parameter. Internal asset type name for the attribute (either CAttributes for content attribute, or PAttributes for product attribute). If you do not specify TYPENAME, a default value is picked up from a property in the gator.ini property file: mwb.defaultattributes. The default value is set to be PAttributes and may be changed to be the name of any custom attribute asset types you create.

attribute (required)

Input parameter. Name of the attribute to constrain.

value (required)

Input parameter. Single value that constrains the attribute.

immediateonly (optional)

Input parameter. true indicates that the search is limited to values directly associated with the specified attribute; false (the default) extends the search to include values inherited from a parent.

Description

This tag is the simple version of addlikeconstraint and adds a single name/value constraint rather than a list. This constraint is similar to a database LIKE operation and accepts wild cards (%). The object referred to by name is updated to reflect the new constraint. If the attribute name is already in the searchstate, then the new constraint replaces the old constraint.

Error Numbers

The possible values of errno include:

Value	Description
-10004	A required parameter is missing.
-13050	General error.

Example

This code creates an empty searchstate and adds a like constraint. The constraint sets the attribute to search on and specifies a value to match against. The typename parameter is not specified and the default set in gator.ini is picked up. Any assets with matching values for this attribute will be returned . This code then sets this searchstate into an assetset:setsearchedassets tag to constrain the assetset to be used when searching with other assetset tags. The last tag uses this constrained assetset to search for matching assets and fetch a list of values for a different attribute of the returned assets:

<searchstate:create name="ss" />
<searchstate:addsimplelikeconstraint name="ss" attribute="cat2" value="Watt%"/>
<assetset:setsearchedassets name="as" constraint="ss" assettypes="Products"/>
<assetset:getattributevalues name="as" attribute="productdesc" listvarname="resultlist"/>
<ics:listloop listname="resultlist">
<ics:listget listname="resultlist" fieldname="value"/><br/>
</ics:listloop>

See Also

searchstate:create
searchstate:addlikeconstraint
searchstate:addsimplestandardconstraint
assetset:setsearchedassets
assetset:getattributevalues

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