Working With Advanced Settings

Query Name

Select the query that you’ve defined to remove orphaned search documents. This is your deletion query.

For example, for rows of data that have been deleted from the database, you would want to ensure that those rows of data (or search result documents) no longer appear in the search index.

Delete SBO Query will not be executed during the first index build of a search definition. It only becomes active after the initial index is populated.

See Defining a Deletion Query.

URL Link Field

Select the drilling URL field for the query selected.

AE Library

To call additional processing logic from Application Engine, specify the correct AE Library (Application Engine program) to run.

AE Section

Specify the Application Engine program section to run.

AE Library

To call additional processing logic from Application Engine, specify the correct AE Library (Application Engine program) to run.

AE Section

Specify the Application Engine program section to run.

AE Library

Specify the AE Library to populate the staging table with the keys of all the documents that need to be indexed. To establish parallel processing, the rows should be assigned with a partition number using the meta sql %RandomNatural.

AE library sample code:

/*
  * Code Snippet for Index by Data Partition Library

  * Populate staging table and assign partition number
 
  * Staging Table PS_DP_STG_JOB
	* Columns of staging Table are:
       - QE_JOB_OPENING_ID
       - PROCESS_INSTANCE
       - PTSF_DP_NBR

  * Clean Staging Table
  * Populate staging Table
  * Assign Partiton Number; use %RandomNatural to assign partition number
 
*/

/*  Clean Staging table*/
SQLExec("DELETE FROM PS_DP_STG_JOB");
SQLExec("COMMIT");

/*Get number of partitions as configured in the run control page*/
Local number &nPartCnt = PTSF_DP_SDL_AET.PTSF_DP_PARTCNT.Value;

/*Populate Staging Table and assign partition number*/
SQLExec("INSERT INTO PS_DP_STG_JOB (qe_job_opening_id,PROCESS_INSTANCE,ptsf_dp_nbr) select qe_job_opening_id , 0,%RandomNatural(:1)  from PS_QE_ALL_JOBS_VW ", &nPartCnt);
SQLExec("COMMIT");

AE Section

Specify the Application Engine program section to run.

Staging Table Name

Specify the Staging Table Name to store the keys of the document to index. The staging table should have a structure with the application keys and the subrecord PTSF_DP_STG_SBR.

Temporary Table Name

Specify the Temporary Table Name to store the keys of the document to index. The temporary table should have a structure with the application keys and the subrecord PTSF_DP_STG_SBR.

Index Only Last <> Days

Enter the number of days for which you want to build the index. The number of days entered are treated as days prior to the current date.

The default value is 0.

Index Start Date

The Index Start Date is calculated based on the number of days you enter in the Index Only Last <> Days field. The Index Start Date displays the date after deducting the number of days entered in the Index Only Last <> Days fields from the current date. The index will be built from the date that is displayed in the Index Start Date field.

When the value of the Index Only Last <> Days field is 0, which is the default value, the Index Start Date is set to 01/01/1900.

Alternate search keywords

Enter any alternate search keywords that users are likely to submit when running search requests. For example, rather than submitting the more official "purchase order" phrase, a user may be more likely to search on "PO" instead.

This field is translatable. If supporting multiple languages, the keywords need to be translated.