Stringfunctions+ | Formula SEARCHVAL
Description
This formula returns the attribute values of objects defined by search parameters.
Formula(s)
{=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:
This parameter depends on the CSType implementation. Not every CSType supports all media. |