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 Manager9.41

Administer > System Security > Mandanten file security > Add a restricting query to a security group

Add a restricting query to a security group

Applies to User Roles:

System Administrator

You must have the SysAdmin capability word to use this procedure.

You can add a restricting query to a security group to further limit the data that operators can see when they query a Mandanten protected file.

To add a restricting query to a security group:

Click Tailoring > Database Manager.
The Database Manager form (format.prompt.db.g) opens.
In the Form field, type scaccess.
Click Search.
The Mandanten Restricting Query form (scaccess.g) opens.
In the File Name field, type or select the name of the Mandanten protected file you want to further restrict.
In the Security Group ID field, type the name of the security group that you want to further restrict.
In the Restricting Query field, type the SQL query you want to use to further restrict the data operators can access

Note: Typically, this query is of the format field="value".
Click Add.
HPE Service Manager displays the message:
scaccess record added.