Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Dropdown List Filter

  Asked By: Daniel    Date: Sep 30    Category: Sharepoint    Views: 4301

I have three lists created at the very top of the site collection. I
then created a content type and added the lists to the content type
and then attached the content type to the document library for used.
My question is, can someone help me figure out how to filter my
lists.

My three lists are:
Country:
-Canada
-USA
Province/State:
-Alberta
-California
-British Columbia
City:
-Edmonton
-Calgary
-LA

So for example, I want to create a document using the content type
that i attached in the document library. When i pick a country from
the Country list, I want Provice to filter only province based on
the country. And when i pick a province and only want all the city
that are in that province. For example: I pick "Canada" from
Country list, in Province/State list: only "Alberta" and "British
Columbia" in this list would show. And when I choose "Alberta", City
list would show "Edmonton" and "Calgary" only. Can someone please
help me with this please.

Share: 

 

4 Answers Found

 
Answer #1    Answered By: Jaya Deoghar     Answered On: Sep 30

You can't do this using the out of the box controls. You will need to use a
custom Field control for the site  columns in your content  types that you want to
cascade. Check out the following Codeplex project for some custom Field types
that will work.

http://www.codeplex.com/CustomFieldControls

 
Answer #2    Answered By: Candi Branch     Answered On: Sep 30

You can achieve this by using CAML query, when you are using custom
asp.net pages. But I am not sure on how to achieve this through custom
content types. once you get any solution for this, do let me know.

 
Answer #3    Answered By: Jan Chen     Answered On: Sep 30

The only way I know of is to create  custom field types. The following link may
include what you are looking for:

datacogs.com/datablogs/archive/2007/08/26/641.aspx

The code is offered to this solution. Use it, because there may be some minor
bugs that may require debugging. I used this to develop a "Grandchild dropdown"
so it goes 3 levels deep in its filtering.

Also, there's a quirk in this solution if you you use this CFT in development
and then deploy it as a list  template or site  template to production. In
production, you will have to go into the list settings for each field that uses
this CFT and verify its properties. This is because the development URL for the
dropdown list will be different that the production URL.

This is a lot to swallow, but the CFT is really cool to use.

 
Answer #4    Answered By: Britni Shepard     Answered On: Sep 30

This work on webpart. How do I get it to work with content  type. I'm attaching
a content type  that have these lookup list  to a document  library. So when I
click NEW from the document library  menu, Office 2007 open with the Document
Information Panel. This DIP will have metadata including my three dropdown
list. This is where i want it to be able to filter. Any idea?

 
Didn't find what you were looking for? Find more on Dropdown List Filter Or get search suggestion and latest updates.




Tagged: