Solved

Sharepoint List Drop Down filter issue

Posted on 2014-10-28
10
315 Views
Last Modified: 2014-10-28
I have a Sharepoint 2007 server and we currently have a CRM List that contains customer names, numbers, address, information, attachments, etc...

When you click on the CRM LIST on the left hand side of Sharepoint it brings it up in the All Items View. There is nothing special to this view, its just the standard.

Now above we have our normal NEW - ACTIONS - SETTINGS drop downs and below that is the TITLE COLUMN for the list.

Each Title in every Column in the list has a Name (ie. Address, Customer name, Phone number, etc... )

When you click on that top Column Name it opens a menu showing you can sort by Acsending and Decsending also below that it shows the Data in that Column (ie. customer name = shows all of our customers) and you can click on a customer your looking for and fliter it to that Customer Name.

However that is no longer an option, when you click on the Column Title it just shows Acsending and Decsending and Show Filter Choices. It no longer shows the Data within that column.

But if I click on the Phone number column it does show the data in that column and I can pick which number I want and filter it like that.

So why is it just affecting certain columns?
0
Comment
Question by:Neogeo147
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 4
10 Comments
 
LVL 19

Expert Comment

by:Montoya
ID: 40409127
did you make any changes to the content type?
0
 

Author Comment

by:Neogeo147
ID: 40409135
not that I know of, I know there are several people that go in there, what do you mean by content type? it is just single line text
0
 
LVL 19

Expert Comment

by:Montoya
ID: 40409136
Also, do you have the same behavior if you do this:  

add ?filter=1 at the end of your URL.. after the aspx
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 19

Accepted Solution

by:
Montoya earned 500 total points
ID: 40409140
another thing to check is if your list is going beyond 500 items. I read somewhere that it causes issues w/ List filter
0
 

Author Comment

by:Neogeo147
ID: 40409146
Actually I think we just hit 505 as of Friday or Monday, Today is when the user noticed it so that could be it, some sort of Threshold
0
 

Author Comment

by:Neogeo147
ID: 40409208
Yup thats it, I removed about 20 entries and now it works, Thank you for helping me figure this out, I hate the little things users come up with but at least theres documentation for it now.

Thank you again
0
 

Author Comment

by:Neogeo147
ID: 40409241
I've requested that this question be closed as follows:

Accepted answer: 0 points for Neogeo147's comment #a40409146

for the following reason:

Spot on, removed some entries and it came back
0
 
LVL 19

Expert Comment

by:Montoya
ID: 40409223
I dont understand why you are posting a close request and not awarding points, when the answer was spot on. Perhaps by mistake?
0
 

Author Comment

by:Neogeo147
ID: 40409242
Yeah that's wierd it said 500, I'll take a look see why, I selected the grade, this new system is different
0
 

Author Comment

by:Neogeo147
ID: 40409486
there ya go
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this post we will learn how to make Android Gesture Tutorial and give different functionality whenever a user Touch or Scroll android screen.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question