Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This class enables provides methods that help the system to perform query searches in the tables specified by their IDs . Use the SimpleSearch methods in your server-side scripts.and reindex columns.

recreateAllIndiсes()


This method reindexes all columns with the active Full Text Search text search attribute in the system.

Return:

Type

Description

VoidThis method does not return a value.

Example:

Code Block
languagejs
titlesearchrecreateAllIndices()
linenumberstrue
const simpleSearch = new SimpleSearch();
simpleSearch.recreateAllIndices();

recreateIndicesByTableName(tableName)


This method reindexes all columns with the active Full Text Search text search attribute within the table specified and its child tables.

Parameter(s):

Name

Type

Mandatory

Default value

tableNameStringYN

Return:

Type

Description

VoidThis method does not return a value.

Example:

Code Block
languagejs
titlesearchrecreateIndicesByTableName
linenumberstrue
const simpleSearch = new SimpleSearch();
simpleSearch.recreateIndicesByTableName('task');

recreateIndicesByColumnId(columnId)


This method reindexes a column and its child entities , including the values of child table records, based on its ID.

Parameter(s):

Name

Type

Mandatory

Default value

columnIDStringYN

Return:

Type

Description

VoidThis method does not return a value.

Example:

Code Block
languagejs
titlesearchrecreateIndicesByColumnId
linenumberstrue
const simpleSearch = new SimpleSearch();
simpleSearch.recreateIndicesByColumnId(155931135900001085); // recreating indices for Description column of Task table

search(text, tableIDs)


This Use this method performs to perform a search query against query against tables. The tableIDs parameter is an array of the sys_id IDtype.

Parameter(s):

NameTypeMandatoryDefault value
textStringYN
tableIDsArray of StringsYN

Return:

TypeDescription
Array of ObjectsThis method returns an array of the SimpleRecord type.

Example:

Code Block
languagejs
titlesearch
linenumberstrue
const searchManager = new SimpleSearch();
const results = searchManager.search('email', ['155931135900000083'/* task */]);
results.map(foundRecord => {
  ss.info(`/record/${foundRecord.getTableName()}/${foundRecord.sys_id}`);
});
//Info: /record/task/164579004293577819
//Info: /record/task/163696164398828017
//...


Table of Contents
absoluteUrltrue
classfixedPosition