Create Declare Index

1.   Create table to hold indexed data inside the pegarules DB by using following SQL script :

(Don’t change the first 3 columns as they are using as primary keys for the Index- classes later)

USE [<<DB-Name>>]GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[<<Table-Name>>](
   
      [pxIndexCount] [decimal](18, 0) NULL,
      [pxIndexPurpose] [varchar](32) NULL,
      [pxInsIndexedKey] [varchar](255) NULL,

      [pxInsIndexedClass] [varchar](96) NULL,
      [pxInsName] [varchar](128) NULL,
      [pxObjClass] [varchar](96) NULL,
      [pzInsKey] [varchar](255) NOT NULL,
 
      [<<Coloumn name8>>] [varchar](50) NULL,
      [<<Coloumn name9>>] [varchar](50) NULL,
   

 CONSTRAINT [<<Table-Name>>_PK] PRIMARY KEY CLUSTERED
(
      [pzInsKey] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

2.   Go to Pega button > Data model > Classes and properties > Database Class mappings

And select index from the dropdown and click “New external database table class mapping” button

                                I.            For the DB name, select the DB connection which connect to the external DB
Go to : Create Database Connection

                              II.            Table name -> External table name which created above

                            III.            Class Name -> 

Create a class which derive from Index-  Ex: Index-XXX

                            IV.            Tick the  pxIndexCount ,pxIndexPurpose, pxInsIndexedKey

Click save and PRPC will create the Index-XXXX class and map it with the DB table.

3.       Open the definition of the Index-XXXX class, which created above ,

The keys should be following order otherwise it will throw an error when it use by the declare-Index rules (If not change it)

4.       Create Declare-Index rule and map the page/properties to create index.

The index records will save when work object save as a Blob record.