ValueTable.Find

Syntax:

Find(<Value>, <Columns>)

Parameters:

<Value> (required)

Type: Arbitrary.
Sought value.

<Columns> (optional)

Type: String.
List of column names, separated by commas, in which you want to search.
If the parameter is not specified, search will be performed across all values table.
Default value: Empty string.

Returned value:

Type: ValueTableRow; Undefined.
Row containing the searched value. If a value is not found, the Undefined value is returned.

Description:

Searches for value in specified values table columns.

Availability:

Server, thick client, external connection, Mobile application (server).

Note:

This method is useful for searching unique values.

Example:

FoundString = PriceTable.Find(Selection, "Article");
If 
FoundString = Undefined Then
    DoMessageBox("Article not found!");
Else
    ArticleCost = FoundString.Cost;
EndIf
;


    

1C:Enterprise Developer's Community