Versions Compared
compared with
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 |
|---|---|
| Void | This method does not return value. |
Example:
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
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 |
|---|---|---|---|
| tableName | String | Y | N |
Example:
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
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 |
|---|---|---|---|
| columnID | String | Y | N |
Return:
Type | Description |
|---|---|
| Void | This method does not return value. |
Example:
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
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):
| Name | Type | Mandatory | Default Value |
|---|---|---|---|
| text | String | Y | N |
...
| tableIDs | Array | Y | N |
Return:
| Type | Description |
|---|
...
| Array | This method returns an array of |
...
| the SimpleRecord type. |
Example:
| Code Block | ||||||
|---|---|---|---|---|---|---|
|
...
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 | ||||
|---|---|---|---|---|
|