Holiday records

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 includes out-of-box records for common holidays in the United States. To add a holiday, you must create a new holiday record in the calholidays table and associate that holiday with a group in calholtable.

Service Manager uses calholtable to organize holidays into different groups. For example, one group of holidays might list all holidays observed in France. This group would include worldwide holidays like Christmas and New Year's Day and those unique to France. A second group might also list the worldwide holidays, but add those unique to North America.

Associated tables

Service Manager uses information in these tables:

calholidays contains a record for each holiday observed by your company.

calholtable contains a record with the name of each group of holidays.

Related topics