Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

Service Manager

Upgrade > Upgrade the applications from a version earlier than 9.60 > Appendix B: Data migration > Out-of-box data migration settings > Task Planner data migration

Task Planner data migration

In versions of Service Manager earlier than 9.40, Task Planner data is stored in the changeModel and changePlan tables. However, in Service Manager 9.40, Task Planner data is stored in the changePlan table only. Therefore, two data migration settings are provided to migrate Task Planner data from Service Manager 9.40 and earlier versions.

Migrate legacy change model Task Planner data to new Task Planner

Default settings:

Source table	changeModel
Target Table	changePlan
Query	not null(tasks)
Batch Update	false

Field mapping:

Target field	Source field
fileName
number	id

Value mapping:

Target value mapping field	Mapping type	Condition	Target value
fileName	fixedValue		changeModel

Post script:

for(var i=0;i<$sourceTable.tasks.length();i++){
	$targetTable.tasks[i].taskId=$sourceTable.tasks[i].taskId;
	$targetTable.tasks[i].taskCoords=$sourceTable.tasks[i].taskCoords;
	$targetTable.tasks[i].dependentIds=$sourceTable.tasks[i].dependentIds;
	$targetTable.tasks[i].dependentCoords=$sourceTable.tasks[i].dependentCoords;
	$targetTable.tasks[i].taskCategory=$sourceTable.tasks[i].taskCategory;
	$targetTable.tasks[i].taskTemplate=$sourceTable.tasks[i].taskTemplate;
	$targetTable.tasks[i].taskDescription=$sourceTable.tasks[i].taskDescription;
	$targetTable.tasks[i].openInPhase=$sourceTable.tasks[i].openInPhase;
	$targetTable.tasks[i].closeByPhase=$sourceTable.tasks[i].closeByPhase;
	$targetTable.tasks[i].activeCond=$sourceTable.tasks[i].activeCond;
	$targetTable.tasks[i].activeCondXML=$sourceTable.tasks[i].activeCondXML;
	$targetTable.tasks[i].activeCondDesc=$sourceTable.tasks[i].activeCondDesc;
	$targetTable.tasks[i].mandatory=$sourceTable.tasks[i].mandatory;
}
$targetTable.doUpdate();

Migrate legacy change instance Task Planner data to new Task Planner

Default settings:

Source table	changePlan
Target Table	changePlan
Query	null(fileName)
Batch Update	true

Field mapping:

Target field	Source field
fileName	fileName

Value mapping:

Target value mapping field	Mapping type	Condition	Target value
fileName	fixedValue		cm3r

Migrate legacy change/task data to new Task Planner

In Service Manager Hybrid, task information is stored in the change’s task plan. Change task information must be migrated to the new Task Planner. To do this, use the “Legacy change/task data to new taskplanner” data migration setting in the data migration tool.

Default settings: