Supporters of End User
Web

SharePoint - Alpha Search

Item is currently unrated. Press SHIFT+ENTER to rate this item.1 star selected. Press SHIFT+ENTER to submit. Press TAB to increase rating. Press SHIFT+ESCAPE to leave rating submit mode.2 stars selected. Press SHIFT+ENTER to submit. Press TAB to increase rating. Press SHIFT+TAB to decrease rating. Press SHIFT+ESCAPE to leave rating submit mode.3 stars selected. Press SHIFT+ENTER to submit. Press TAB to increase rating. Press SHIFT+TAB to decrease rating. Press SHIFT+ESCAPE to leave rating submit mode.4 stars selected. Press SHIFT+ENTER to submit. Press TAB to increase rating. Press SHIFT+TAB to decrease rating. Press SHIFT+ESCAPE to leave rating submit mode.5 stars selected. Press SHIFT+ENTER to submit. Press SHIFT+TAB to decrease rating. Press SHIFT+ESCAPE to leave rating submit mode.
Categories:Libraries and Lists; Views; Search; Site Manager/Power User; MOSS; WSS; 2007; 2010

You may also be interested in: O'Reilly - SharePoint 2010 at Work

 

Editor's note: Follow contributor Ryan Elliott @ryanelliott82

In response to a comment left to me on the page for Filtering with Web Part Connections, Kerri Abraham asked me to do a how-to on an alphabetical search of a list.  The below process will guide an end user from start to finish, Creating a Contacts list, the needed views for the alphabetical search to function, and creating the custom list to do the alphabetical search.

  1. Create a custom list and give it whatever columns you will need to keep track of…

    • Fname                         Single line of text
    • Lname                         Single line of text
    • Title                             Single line of text
    • Facility                         Single line of text
    • Address                       Single line of text
    • City                             Single line of text
    • State                            Single line of text
    • Zip                               Single line of text
    • Phone                          Single line of text
    • Fax                              Single line of text
    • Approval Status (you don’t need this unless your list items need to be approved before going live

    2013-02-01-AlphabeticalSearch-01.png

  2. Now that you have your contact list created, you can create a view for your alpha search based on last name

    1. Click on the drop down selection for View:
    2. Next, click on Create View
    3. 2013-02-01-AlphabeticalSearch-02.png

    4. And then select Standard View and give it the name A
    5. 2013-02-01-AlphabeticalSearch-03.png

    6. Make sure the columns listed in step 1 are selected to be part of the view (or whatever columns you want visible on the default page).
    7. Set your Filter for the view to be as follows…
    8. 2013-02-01-AlphabeticalSearch-04.png

    9. Click OK to create the view
    10. Repeat this process for each of the other 25 letters of the alphabet

  3. Now, create another custom list to enable the alphabet shortcuts (in our case, we called this list AlphaSearch)

    1. You can leave the mandatory field Title in place, and change the default view to not display this column
    2. Next, create 25 more columns for each of the remaining letters
      1. A                     Hyperlink or Picture
      2. B                     Hyperlink or Picture
      3. C                     Hyperlink or Picture
      4. D                     Hyperlink or Picture
      5. Etc.
        • Be sure to change the Format URL as: field for each column to be a Hyperlink

      2013-02-01-AlphabeticalSearch-05.png

    3. Once you list has been created, go back the AllItems.aspx page so that all columns are visible
    4. 2013-02-01-AlphabeticalSearch-06.png

    5. Next, click on New to add new items to the AlphaSearch list.
      1. You can leave the Title field blank, and make the description match the column name
      2. In the web address field – place the link to the specific view you created in Step 2 for each letter of the alphabet
      3. Click OK to save you additions

      2013-02-01-AlphabeticalSearch-07.png

    6. Once complete, the AlphaSearch list will be setup to search your Contacts list, where the last name starts with the corresponding letter of the alphabet.

  4. You can take this one step further if you would like, and add the AlphaSearch list as a webpart to your contacts list.

    1. Open the Contacts list, and click Site Actions, and then Edit Page.
    2. Add the AlphaSearch web part above the contacts list, and click Exit Edit Mode to save the addition.

Comments

yitoyitoytyo

yitoyitoytyo

Acero inoxidable y modelos Relojes Especiales bicolor son conducidos por el calibre Omega coaxial 8602. Equipado con una espiral Replica de relojes de silicio Si14, certificada oficialmente este cronógrafo movimiento COSC goza de una garantía completa de cuatro Rolex Submariner años (al igual que en otros lugares el 8612). El cristal de zafiro transparente.

Posted 17-Apr-2014 by yitoyitoytyo

Notify me of comments to this article

E-mail:
   

Add Comment

Title:

 
Comment:
Email:

   


Name:

 
Url: