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

Develop > Programming Guide > Introduction to JavaScript in Service Manager > Using JavaScript in Service Manager > Restricting fields selected by a query

Restricting fields selected by a query

When looping on a larger set of records by a query, a huge amount of memory may be allocated for each record. At the same time, a dbdict might be mapped to multiple tables on the RDBMS. ITSMA Service Management by default fetches the complete records and therefore selects against each of these tables.

In JavaScript implementations, you can use read-only file variables and restrict them to a set of fields only. Using this option will significantly reduce memory consumption, as well as select against tables not containing any of these fields.

Recommended implementation

var file = new SCFile( filename, SCFILE_READONLY);

var query = "true";

var fields = new Array();

fields = [ “number”, “status” ];

file.setFields( fields );

var rc = file.doSelect(query);

while (RC_SUCCESS == rc)

// Do something with file here

rc = file.getNext();

When using the setFields() function on a file variable that is not read-only, the query is executed against all fields and this message is written to the log file:

JS W SCFile.setFields called on non readonly SCFile("number", "status")- ignored

Send Help Center feedback