Solved

Sharepoint List Drop Down filter issue

Posted on 2014-10-28
10
303 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
  • 6
  • 4
10 Comments
 
LVL 19

Expert Comment

by:Iammontoya
Comment Utility
did you make any changes to the content type?
0
 

Author Comment

by:Neogeo147
Comment Utility
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:Iammontoya
Comment Utility
Also, do you have the same behavior if you do this:  

add ?filter=1 at the end of your URL.. after the aspx
0
 
LVL 19

Accepted Solution

by:
Iammontoya earned 500 total points
Comment Utility
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
Comment Utility
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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

Author Comment

by:Neogeo147
Comment Utility
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
Comment Utility
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:Iammontoya
Comment Utility
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
Comment Utility
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
Comment Utility
there ya go
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
micro services vs rest web services 16 45
Excel and Formulas 8 30
VBA code to clear all filter and select 1 43
integer8 values 1 10
Introduction This article is the second of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers the basic installation and configuration of the test automation tools used by…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

763 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now