Glossary in Sharepoint 2010 without Designer access
Hello.
An expert was kind enough to provide me details of how to create a Glossary in Sharepoint and had advised I create a page with a list view and a Content Editor web part and to set the list view webpart to point to the glossary list and set a filter of "Letter - is equal to - {Letter}".
As I'm quite new to SP, please forgive me as I'm slow... I assumed that with the "page with a list view", it means I work off of my original glossary list of words. I was able to add a content webpart and used <a href="siteName/SitePages/G
I previously already had a column named Letter with the Left formula to pull the initial so based on the instructions, I created a view called filter in my Glossary list and selected the "Letter" column, drop down to "is equal to", and wrote "[Letter]".
The list defaults at empty and remains empty when I click on a letter. I'm sure I'm missing something but not sure as to what.
Also, it appears as if the whole page reloads every time a link is clicked on. Is there a way to only have the glossary list refresh and not the rest of the page?
Can someone please advise as to what I'm doing wrong?
An expert was kind enough to provide me details of how to create a Glossary in Sharepoint and had advised I create a page with a list view and a Content Editor web part and to set the list view webpart to point to the glossary list and set a filter of "Letter - is equal to - {Letter}".
As I'm quite new to SP, please forgive me as I'm slow... I assumed that with the "page with a list view", it means I work off of my original glossary list of words. I was able to add a content webpart and used <a href="siteName/SitePages/G
I previously already had a column named Letter with the Left formula to pull the initial so based on the instructions, I created a view called filter in my Glossary list and selected the "Letter" column, drop down to "is equal to", and wrote "[Letter]".
The list defaults at empty and remains empty when I click on a letter. I'm sure I'm missing something but not sure as to what.
Also, it appears as if the whole page reloads every time a link is clicked on. Is there a way to only have the glossary list refresh and not the rest of the page?
Can someone please advise as to what I'm doing wrong?
ASKER
Thanks, Teylyn. I was hoping you'd be able to assist further :)
I attempted the squigglies {Letter} first, then changed it to the [Letter] when it didn't work. Ichanged the view of my actual list to Filter and it went blank. when I changed the view to all items, it doesn't filter.
I basically added a content webpart on top of my existing glossary list. was I supposed to do something different?
I did notice a difference between what you posted and what I did - my urls say<a href="siteName/SitePages/G
Would you be able to assist?
Thanks for your help thus far.
I attempted the squigglies {Letter} first, then changed it to the [Letter] when it didn't work. Ichanged the view of my actual list to Filter and it went blank. when I changed the view to all items, it doesn't filter.
I basically added a content webpart on top of my existing glossary list. was I supposed to do something different?
I did notice a difference between what you posted and what I did - my urls say<a href="siteName/SitePages/G
Would you be able to assist?
Thanks for your help thus far.
Let me try to unravel this.
There's a Glossary list with three columns: Title, Description, Letter. Letter is a calculated column with the formula =Left(Title, 1). Let's assume that users working with the Glossary will not go to the list directly, but will see the glossary on a different page. This is my preferred approach, since the filter technique requires two web parts and the list view functionality suffers when web parts are added to a list view page.
Next step is to build the page that the end user will see. This page can be a web part page or a wiki page. Does not matter, as long as there are two web parts on the page. Let's assume the page is in the SitePages library and is called Glossary.aspx
Add two web parts to this page.
First, a Content Editor Web Part. Enter the letters A to Z into the web part body, separated by spaces or line breaks. Select each letter and add a link. The link points to the same page, i.e. Glossary.aspx, but it also has the query parameter for the letter. The full link for the letter A is
http://SiteName/SitePages/Glossary.aspx?Letter=A
In HTML view, the link will look like
Second, add a list view web part to the page. Point it to the glossary list. Edit the list view web part and modify the view. Set the filter values as in the screenshot in my previous post.
Save the page.
If you just browse to http://SiteName/LibraryName/Glossary.aspx, the list view will not show any items, because there is no query parameter called "Letter" in the URL. Click on one of the links in the Content Editor Web Part and the URL will change to http://SiteName/LibraryName/Glossary.aspx?Letter=A (or similar) and the list view will show only the items that begin with that letter.
When you create a link to this page, for example from an intranet portal page or the QuickLaunch, you will want to include the query parameter and provide a default value, for e.g. ?Letter=A, so the user will never see an empty glossary list.
cheers, teylyn
There's a Glossary list with three columns: Title, Description, Letter. Letter is a calculated column with the formula =Left(Title, 1). Let's assume that users working with the Glossary will not go to the list directly, but will see the glossary on a different page. This is my preferred approach, since the filter technique requires two web parts and the list view functionality suffers when web parts are added to a list view page.
Next step is to build the page that the end user will see. This page can be a web part page or a wiki page. Does not matter, as long as there are two web parts on the page. Let's assume the page is in the SitePages library and is called Glossary.aspx
Add two web parts to this page.
First, a Content Editor Web Part. Enter the letters A to Z into the web part body, separated by spaces or line breaks. Select each letter and add a link. The link points to the same page, i.e. Glossary.aspx, but it also has the query parameter for the letter. The full link for the letter A is
http://SiteName/SitePages/Glossary.aspx?Letter=A
In HTML view, the link will look like
<a href="http://SiteName/SitePages/Glossary.aspx?Letter=A">A</a>Second, add a list view web part to the page. Point it to the glossary list. Edit the list view web part and modify the view. Set the filter values as in the screenshot in my previous post.
Save the page.
If you just browse to http://SiteName/LibraryName/Glossary.aspx, the list view will not show any items, because there is no query parameter called "Letter" in the URL. Click on one of the links in the Content Editor Web Part and the URL will change to http://SiteName/LibraryName/Glossary.aspx?Letter=A (or similar) and the list view will show only the items that begin with that letter.
When you create a link to this page, for example from an intranet portal page or the QuickLaunch, you will want to include the query parameter and provide a default value, for e.g. ?Letter=A, so the user will never see an empty glossary list.
cheers, teylyn
ASKER
I'm sorry Teylyn, I'm proving to be quite dense with this. LEt me walk you through what I've done and hopefully you can pinpoint what I'm doing wrong.
I created a list called Glossary with my 3 columns, the third one named Letter which pulls the first letter of each word based on the LEft formula. I created a view called Filter with url http://mysite.com/LoB/PC/People/Lists/Glossary/Filter1.aspx. The only changes I made from allitems view is the "Show items only when the following is true: Show the items when column" drop down to "Letter", drop down to "is equal to" and wrote "{Letter}".
I created a separate page called "Glosstest" and added a Content Editor Web Part and a web part which pulls the Glossary . On the Glossary web part, I edited the web part to select the drop down Filter view and saved. On the CEWP, I clicked on the box, clicked on the HTML icon ion the MArkup ribbon, and entered the following code:
<a href="/LoB/PC/People/Pages
<a href="/LoB/PC/People/Pages
<a href="/LoB/PC/People/Pages
<a href="/LoB/PC/People/Pages
<a href="/LoB/PC/People/Pages
I stopped editing and clicked on A on the CEWP. the Glossary web part still shows blank.
Can you please advise what I'm doing incorrect?
Many thanks.
I created a list called Glossary with my 3 columns, the third one named Letter which pulls the first letter of each word based on the LEft formula. I created a view called Filter with url http://mysite.com/LoB/PC/People/Lists/Glossary/Filter1.aspx. The only changes I made from allitems view is the "Show items only when the following is true: Show the items when column" drop down to "Letter", drop down to "is equal to" and wrote "{Letter}".
I created a separate page called "Glosstest" and added a Content Editor Web Part and a web part which pulls the Glossary . On the Glossary web part, I edited the web part to select the drop down Filter view and saved. On the CEWP, I clicked on the box, clicked on the HTML icon ion the MArkup ribbon, and entered the following code:
<a href="/LoB/PC/People/Pages
<a href="/LoB/PC/People/Pages
<a href="/LoB/PC/People/Pages
<a href="/LoB/PC/People/Pages
<a href="/LoB/PC/People/Pages
I stopped editing and clicked on A on the CEWP. the Glossary web part still shows blank.
Can you please advise what I'm doing incorrect?
Many thanks.
Have you tried this on a web part page, and NOT a view in the list?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks for your help teylyn - much appreciated!
ASKER
Quick response; amazing help!
I think that expert was me, in another user's question. You need to use curly braces in the filter.
Letter is equal to {Letter} -- see screenshot. Square brackets will refer to a column name. Curly braces will refer to a URL query parameter.
Yes, the whole page will refresh with that technique. You could use filter web parts, but they would also refresh the whole page. If you need only the list view web part to refresh, that would be a lot more complex, involving javascript, and even then I'm not sure it can be done without a page refresh.
cheers, teylyn