Searching the Help
To search for information in the Help, type a word or phrase in the Search box. When you enter a group of words, OR is inferred. You can use Boolean operators to refine your search.
Results returned are case insensitive. However, results ranking takes case into account and assigns higher scores to case matches. Therefore, a search for "cats" followed by a search for "Cats" would return the same number of Help topics, but the order in which the topics are listed would be different.
Words and Phrases
| 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. |
Using Boolean Operators
| Search for | Operator | Example |
|---|---|---|
|
Two or more words in the same topic |
|
|
| Either word in a topic |
|
|
| Topics that do not contain a specific word or phrase |
|
|
| Topics that contain one string and do not contain another | ^ (caret) |
cat ^ mouse
|
| A combination of search types | ( ) parentheses |
|
Delete multiple records
Applies to User Roles:
System Administrator
Example: Delete the contacts for advantage with a variant of NewAdvantage as the contact name.
To delete all records with a specified value:
- Click Tailoring > Database Manager.
- Select Administration mode.
- For this example, open the
contactsform. - Enter the desired value. For this example, type NewAdvantage* in the Contact Name field.
-
Click Search.
Database Manager performs the search and displays the record list of matching records, if any, in the contacts.qbe form.
If the query produces no matching records or only one matching record, then Service Manager does not display a record list.
Note: To display the Mass function buttons, use a query that returns more than one record.
-
Select Mass Delete from the tool bar to remove the records shown in the record list from the database.
Database Manager confirms the delete request with a prompt screen.
- Do one of the following:
- To cancel the delete, click No.
To confirm the delete, click Yes.
Database Manager deletes all records in the list.
Note: Service Manager performs the Mass Delete function in the foreground, which means your terminal is devoted to this function until complete. If you are deleting a large number of records, this can take a while.
Upon completion, Service Manager returns terminal control to you. A blank contacts form opens with the message: “nnn records deleted from the contacts file”, where nnn is the number of records deleted.
The topics below comprise an example of how to use multiple-record functions. Follow the steps in this order. If you skip a step, the example will not work.
- Add multiple records using a literal value
- Add multiple records using a variable value
- Update multiple records using a literal value
- Update multiple records using a variable value
- Avoid invalid duplicate or null key errors
- Delete multiple records
Related topics
Determine the number of records in a record list
Open a record using Database Manager
