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:

Example:

const simpleSearch = new SimpleSearch();
simpleSearch.recreateAllIndiсes();

recreateIndicesByTableName(tableName)

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

Parameter(s):

Example:

const simpleSearch = new SimpleSearch();
simpleSearch.recreateIndicesByTableName('task');

recreateIndicesByColumnId(columnId)

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

Parameter(s):

Return:

Example:

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):

Return:

Example:

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
//...