Print      Open PDF Version of Online Help

Administering Oracle CRM On Demand > Expression Builder > Expression Builder Functions > IsValidRowId

Previous Topic

Next Topic

IsValidRowId

The IsValidRowId function in Expression Builder queries records of a specified record type to determine if a certain row ID exists, and returns a Boolean value (TRUE or FALSE). If the row ID exists but the record is marked for deletion, then the IsValidRowId function returns FALSE.

Syntax

IsValidRowId(record_type, 'row_id')

Result Type

Boolean (TRUE or FALSE).

Arguments

The following table describes the arguments for the function.

Argument

Description

record_type

The language-independent name of the record type. (A language-independent name is a name that does not change when the user language changes.)

The argument must be enclosed in field string identifiers. For example:

'<Contact>'

row_id

The string literal, field name, or expression that returns an alphanumeric row ID.

Examples

The following example determines if the value in the Row Id field on a contact record is a valid row ID for a contact record:

IsValidRowId('<Contact>', [{Id}])

The following example determines if the value 12-Y09KG is a valid row ID for an account record:

IsValidRowId('<Account>', '12-Y09KG')

Related Topics

See the following topics for related Expression Builder information:
Published 7/6/2017 Copyright © 2005, 2017, Oracle. All rights reserved. Legal Notices.