Breadcrumbs

Stringfunctions+ | Formula SEARCHVAL

Description

This formula returns the attribute values of objects defined by search parameters.

Formula(s)

PHP
{=SEARCHVALUE("Record class (e.g. Pdmarticle for product)";"Search for items by attribute";"Search for value";"Attribute";Formatted)}
{=SEARCHVALUE("Record class (e.g. Pdmarticle for product)";"Search for items by attribute";"Search for value";"Attribute";"Medium")}


SEARCHVAL("Record class (e.g. Pdmarticle for product)";"Search for items by attribute";"Search for value";"Attribute";Formatted)

Record class (e.g. Pdmarticle for product) (String):
Record class (e.g. Pdmarticle for product)
Search for items by attribute (String/Integer):
Search for items by attribute
Search for value (String/Integer):
Search for value
Attribute (String/Integer):
Defines the attribute name/id from which the value should be retrieved
Formatted (Boolean):
Defines whether the returned value should be formatted(TRUE) or unformatted(FALSE)
(Default: TRUE)


Result

  • Array

Parameters

Parameter
Content
Format
Default value
Explanation

Record class

 Object class

String

 

e.g. Pdmarticle for products

Search for items by attribute

Attribute to be searched in

Attribute ID: Integer

Attribute name: String



Search for value

Search value

Integer

String



Attribute

Attribute ID or attribute name

Attribute ID: Integer

Attribute name: String

 

 

Formatted

TRUE or FALSE

Boolean

TRUE

TRUE: Formatted

FALSE: Unformatted

Medium

Medium for which the value is to be returned

String

MEDIUM_NONE

Possible values:

  • MEDIUM_NONE

  • MEDIUM_TEXT

  • MEDIUM_HTML

  • MEDIUM_EXPORT

  • MEDIUM_EDITOR

  • MEDIUM_TRANSLATIONMANAGER

  • MEDIUM_MASSEDITOR

  • MEDIUM_API

  • MEDIUM_TABLEAPI

This parameter depends on the CSType implementation. Not every CSType supports all media.