ADMIN_OBJECT_FIND

 Show all Hide all

Deprecated.

Searches the database for matches to a specified string.

Type: Stored procedure
Area of use: Development

Parameters:

@Count optional int
Specifies that the number of hits should be returned instead of the actual matching rows. The actual matching rows are returned by default.
@OrderBy optional varchar(1000)
The column to order the result by.
@Raw optional bit
Specifies that html tags should not outputted. By default html tags are outputted.
@SearchFor mandatory varchar(2000)
The string to search for.

Resultsets:

Resultset: Matching rows

Specifies the type of match, the name of the matching object and the matching data for the search.
Repeat mode: repeated zero or one time
Row count: zero or more rows

Columns:

information mandatory string
The data that matched.
name mandatory string
The name of the object that matched.
object_type mandatory string
The type of object that matched.

Resultset: Number of matches

Specifies the number of matching rows found in the search.
Repeat mode: repeated zero or one time
Row count: exactly one row

Columns:

<column with ordinal 1> mandatory int
The number of rows that matched.