spMFSearchForObjectbyPropertyValues

Signature

EXEC dbo.spMFSearchForObjectbyPropertyValues
    @ClassID = 0,
    @PropertyIds = N'27,28',
    @PropertyValues = N'Foo,Bar',
    @Count = 100,
    @OutputType = 0,
    @XMLOutPut = NULL OUTPUT,
    @TableName = NULL OUTPUT;

Returns

INT: 1 on success; -1 on error.

Parameters

@ClassID

• Type: INT

• Required: Yes

• Description: Class ID.

@PropertyIds

• Type: NVARCHAR(2000)

• Required: Yes

• Description: Comma-separated property IDs.

@PropertyValues

• Type: NVARCHAR(2000)

• Required: Yes

• Description: Comma-separated property values.

@Count

• Type: INT

• Required: No

• Description: Maximum number of results to return.

@OutputType

• Type: INT

• Required: No (default = 0)

• Description: 0 = XML output; 1 = temporary table + MFSearchLog.

@XMLOutPut

• Type: XML

• Required: No (OUTPUT)

• Description: Result as XML (when OutputType = 0).

@TableName

• Type: VARCHAR(200)

• Required: No (OUTPUT)

• Description: Name of temporary table (when OutputType = 1).

Purpose

To search for objects with class id and some specific property id and value.

Additional Info

This procedure will call spMFSearchForObjectByPropertyValuesInternal and get the objects details that satisfies the search conditions and shows the objects details in tabular format.

Examples

DECLARE @RC INT
DECLARE @ClassID INT
DECLARE @PropertyIds NVARCHAR(2000)
DECLARE @PropertyValues NVARCHAR(2000)
DECLARE @Count INT
DECLARE @OutputType INT
DECLARE @XMLOutPut XML
DECLARE @TableName VARCHAR(200)

-- TODO: Set parameter values here.
EXECUTE @RC = [dbo].[spMFSearchForObjectbyPropertyValues]
   @ClassID
  ,@PropertyIds
  ,@PropertyValues
  ,@Count
  ,@OutputType
  ,@XMLOutPut OUTPUT
  ,@TableName OUTPUT
GO

Changelog

Date	Author	Description
2019-08-30	JC	Added documentation
2019-08-13	LC	Added Additional option for search procedure
2019-05-08	LC	Change target table to a temporary table
2018-04-04	DEV2	Added License module validation code.
2016-09-26	DEV2	Removed vault settings parameters and pass them as comma separated string in @VaultSettings parameters.
2016-08-27	LC	Update variable function paramaters
2016-08-24	DEV2	TaskID 471
2014-04-29	DEV2	RETURN statement added