Versions Compared

Key

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

This class may be used to

...

perform query searches

...

in tables specified by their IDs. Use the SimpleSearch

...

methods in your

...

server-side scripts.


recreateAllIndiсes()


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

Return:

Type

Description

VoidThis method does not return value.

Example:

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

recreateIndicesByTableName(tableName)


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

Parameter(s):

Name

Type

Mandatory

Default Value

tableNameStringYN

Example:

Code Block
languagejs
titlesearch
linenumberstrue
const simpleSearch = new SimpleSearch(

...

);
simpleSearch.recreateIndicesByTableName('task');

recreateIndicesByColumnId(columnId)


This method reindexes a column and its child entities based on its ID.

Parameter(s):

Name

Type

Mandatory

Default Value

columnIDStringYN

Return:

Type

Description

VoidThis method does not return value.

Example:

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

search(text, tableIDs)


This method performs a search

...

query against tables. The tableIDs

...

parameter is an array of the sys_id type.


Parameter(s):

NameTypeMandatoryDefault Value
textStringYN

...

tableIDsArrayYN


Return:

TypeDescription

...

ArrayThis 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