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 Management2017.11

Administer > Database administration > Data persistence > Queries > Cross-table join query improvements > Example: Handle BLOB, CLOB, text and images

Example: Handle BLOB, CLOB, text and images

This query shows all open Incidents, where current operator is a member of an assignment group (Support Groups) that is defined in the affected service.

Note

Because an RDBMS cannot search on a BLOB field directly, if you want to use BLOB field as a query condition, you must map the BLOB field as multi-row array.
You must map support.groups from DEVICE2M1 to DEVICE2A1 for this example to work. Otherwise, you will receive the following error:

Queries on Blob/Clob/Text/Image field is not supported in cross table query. (display,process.option) Field "ta02.support.groups" in the query is not mapped or mapped to Blob/Clob/Text/Image. Queries on Blob/Clob/Text/Image field is not supported in cross table query. (display,process.option)

var file = new SCFile("probsummary");
var sql = "SELECT ta01.*, ta02.support.groups FROM probsummary ta01 LEFT OUTER JOIN device ta02 ON  ( ta01.affected.item = ta02.logical.name )  WHERE ( ta02.support.groups isin $lo.pm.assignments and ta01.flag=true )";
var success = file.doSelect(sql);
while (success == RC_SUCCESS) 
{
    success = findNextRecord = file.getNext();    
}

Send Help Center feedback