SimpleSearch
This class provides methods that help the system to perform query searches in the tables specified by their IDs and reindex columns.
recreateAllIndiсes()
This method reindexes all columns with the active Full text search attribute in the system.
Return:
| Type | Description |
|---|---|
| Void | This method does not return a value. |
Example:
recreateAllIndices()
const simpleSearch = new SimpleSearch();
simpleSearch.recreateAllIndices();
recreateIndicesByTableName(tableName)
This method reindexes all columns with the active Full text search attribute within the table specified and its child tables.
Parameter(s):
| Name | Type | Mandatory | Default value |
|---|---|---|---|
| tableName | String | Y | N |
Return:
| Type | Description |
|---|---|
| Void | This method does not return a value. |
Example:
recreateIndicesByTableName()
const simpleSearch = new SimpleSearch();
simpleSearch.recreateIndicesByTableName('task');
recreateIndicesByColumnId(columnId)
This method reindexes a column, including the values of child table records, based on its ID.
Parameter(s):
| Name | Type | Mandatory | Default value |
|---|---|---|---|
| columnID | String | Y | N |
Return:
| Type | Description |
|---|---|
| Void | This method does not return a value. |
Example:
recreateIndicesByColumnId()
const simpleSearch = new SimpleSearch();
simpleSearch.recreateIndicesByColumnId(155931135900001085); // recreating indices for Description column of Task table
search(text, tableIDs)
Use this method to perform a search query against tables. The tableIDs parameter is an array of the ID type.
Parameter(s):
| Name | Type | Mandatory | Default value |
|---|---|---|---|
| text | String | Y | N |
| tableIDs | Array of Strings | Y | N |
Return:
| Type | Description |
|---|---|
| Array of Objects | This method returns an array of the SimpleRecord type. |
Example:
recreateIndicesByColumnId()
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
//...