Using Operators and Wildcards


Concept

During this topic we will explain how to use operators and wildcards in search pages.


Steps:

  1. Click the Sign In button.

    Step 1

  2. Click the Main Menu button.

    Step 2

  3. Click the Organizational Development menu.

    Step 3

  4. Click the scrollbar.

    Step 4

  5. Click the Maintain Positions/Budgets menu.

    Step 5

  6. Click the Add/Update Position Info menu.

    Step 6

  7. Operators enable you to conduct a search on limited amounts of information, such as first letters for names, descriptions, or IDs.

    Step 7

  8. The fields that uniquely identify your data are called keys.

    Step 8

  9. The advanced search page defaults the operators used for each search key. Notice on the search page displayed that the default for all but one of the search keys is begins with. This means that the system searches for records that match, based on the key beginning with the criteria entered in each field.

    Step 9

  10. Enter "59" into the Position Number field.

    Step 10

  11. In this example, you are searching for a position.  You do not know the specific name of the position, but you know that it is an administrative position. If the first word in the position description was "administrative" you could use the "begins with" operator and enter the word "administrative" in the field next to the operator. This would return all positions that begin with the word "administrative." For this example, you do not know where the word falls in the description, so you need to use the "contains" operator.

     

    Click the Description key list to

    Step 11

  12. Displayed is a list of all the operators that are available when conducting a search, such as begins with, contains, equals, not equal to, greater than, greater than or equal to, less than, less than or equal to, between, and in.

     

    For this example select the contains list item.

    Step 12

  13. Click in the Description field.

    Step 13

  14. Enter "administrative" into the Description field.

    Step 14

  15. Click the Search button.

    Step 15

  16. Your Search Results are displayed below the operators. Notice how the result only displays the positions containing the word "administrative" in the description.

    Step 16

  17. Click the Main Menu link.

    Step 17

  18. Click the Workforce Administration menu.

    Step 18

  19. Click the Job Information menu.

    Step 19

  20. Click the Job Data menu.

    Step 20

  21. CONNECT supports three wildcard features when searching for data in character fields. These wildcards can be helpful in finding the exact information you want to process.

     

    The supported standard wildcard features: 

     

    % the percent sign to match one or more characters

     

    _ the underscore to match any single character

     

    \ the back slash as an escape character (don't treat the next character as a wildcard)

    Step 21

  22. For example, suppose you are looking for a specific employee but can't remember his ID. You know that the Name begins with "K". You can use the % wildcard to locate the employee.

     

    Click in the Name field.

    Step 22

  23. Enter "k%" into the Name field to search for all names beginning with the letter K.

    Step 23

  24. Click the Search button.

    Step 24

  25. Click the scrollbar to view all results.

    Step 25

  26. Notice there are 12 employees with names beginning with the letter K.

    Step 26

  27. Click the Home link.

    Step 27

  28. Click the Sign out link.

    Step 28

You have completed the Using Operators and Wildcards topic.

Table of Contents  Start Topic