Filtered Lookup Columns

Question

While creating Lookup columns can we filter the values, instead of showing all the items from the list using OOB

---

Satheesh

Answer 1

This looks as if it is a WSS 3.0 / MOSS 2007 question.

Is it ?

---

FAQ sites: (SP 2010) http://wssv4faq.mindsharp.com; (v3) http://wssv3faq.mindsharp.com and (WSS 2.0) http://wssv2faq.mindsharp.com
Complete Book Lists (incl. foreign language) on each site.

Answer 2

Sorry for not elobroting the question.

We do not have any out of the box way of having this feature in 2007. Wanted to know any improvements has been taken in 2010 for this.

---

Satheesh

Answer 3

There is no setting for it when creating the Lookup column in 2010, but there are 2 features that may achieve this when combined:
1) You can choose to customize your list forms with InfoPath 2010
2) Upon doing so, InfoPath 2010 can now do parameterized (filtered) queries to SharePoint list data connections, which means you can pass a value to the data connection so that it only returns a filtered set instead of the whole set.  Using this for a lookup field may not work, so I'll go try it.  It may not work, because I may not be able to tell that lookup connection not to fire automatically when the form is opened.  You can do this with data connections you create, but I'm not sure that will be configurable on the lookup field.

---

SharePoint Architect || My Blog

Answer 4

While creating Lookup columns can we filter the values, instead of showing all the items from the list using OOB

---

Satheesh

Why not create a view and filter the columns? Was there any particular reason you werent able to create views?

I think creating filtered views would be the best option.

---

Regards,
Chakkaradeep
SharePoint Developer - MCTS SharePoint Dev, WSS Dev

Intergen: http://www.intergen.co.nz
Twitter: http://twitter.com/chakkaradeep
Blog: http://www.chakkaradeep.com

Answer 5

Filter which views?  He needs to filter the values that show up in his lookup columns when users are creating/editing list items in the destination list, I thought.

---

SharePoint Architect || My Blog

Answer 6

Filter which views?  He needs to filter the values that show up in his lookup columns when users are creating/editing list items in the destination list, I thought.

---

SharePoint Architect || My Blog

Not sure, I think the thread starter needs to elaborate more, may be with some examples on what he is trying to achieve.

---

Regards,
Chakkaradeep
SharePoint Developer - MCTS SharePoint Dev, WSS Dev

Intergen: http://www.intergen.co.nz
Twitter: http://twitter.com/chakkaradeep
Blog: http://www.chakkaradeep.com

Answer 7

In many scenarios we have parent child relationship concept in lists. Where child is having look up on parent list column. In this scenario when make new items in the child list (newform.aspx) we want to show only specific items from parent list instead of all the items.

Was wondering is there any improvements made in 2010 look up fields this can be achieve out of the box.

---

Satheesh

Answer 8

There is no setting for it when creating the Lookup column in 2010, but there are 2 features that may achieve this when combined:
1) You can choose to customize your list forms with InfoPath 2010
2) Upon doing so, InfoPath 2010 can now do parameterized (filtered) queries to SharePoint list data connections, which means you can pass a value to the data connection so that it only returns a filtered set instead of the whole set.  Using this for a lookup field may not work, so I'll go try it.  It may not work, because I may not be able to tell that lookup connection not to fire automatically when the form is opened.  You can do this with data connections you create, but I'm not sure that will be configurable on the lookup field.

---

SharePoint Architect || My Blog

Dear Clayton Cobb,

I do have same problem with SP 2007, Do we follow the same 2 ways or any other alternate is also ?

---

Thanks n Regards, RB. Twit me @ranjeetbhargava Follow me @Bhargavablog.wordpress.com, www.assigncorp.com, www.assigninfo.com, Assign Lab India

Answer 9

Hi Clayton,

Can we do using any object model concepts??? please let me know if possible.

 

Thanks

Bijay

http://www.fewlines4biju.com/2011/05/look-up-column-in-sharepoint-2010.html

Answer 10

Hi Sateesh

The Filtered lookup values in SharePont can be achieved by using Javascript. Read the following article to know more about the cascading drop down in SharePoint.

Filtered Lookup Values in SharePoint

---

Cheers!

Maruthu | http://sharepoint-works.blogspot.com