locked
Filter Data in WEBPART List - according to Data From Another List RRS feed

  • Question

  • I have two Lists:

    Users
    Courses

    Each user has a Level so does each Course

    Levels:
    1
    2
    3

    I want to be able to sort 'avaliable' courses by the Level of the USER and fitler out others not avaliable to the USER.

    So:
    If USER = Level 1 then filter 2 and 3
    If USER = Level 2 then filter 3
    If USER = Level 3 no filter


    I am curious as to how to do this, I am close and trying my best any help would be appreciated.
    • Edited by design4fun Thursday, April 19, 2012 11:47 PM
    Thursday, April 19, 2012 11:47 PM

All replies

  • Hi design4fun,

    I think you should do some change of your two list, then it will easy to achieve. In your course list, create a column1 , this column is lookup to your user ID. Then create a column2, this column is lookup to your user level . Now, in your course list, you can create a view, in the view ,you can sort and filter with the two column .If column1 contains level1, you can filter level2 and level3.

    More about SharePoint list view filter please refer to the following link.

    http://blog.pentalogic.net/2008/10/advanced-sharepoint-view-and-filters/

    Thanks,

    Jack

    Wednesday, April 25, 2012 3:43 AM
    Moderator
  • Not really sure I follow you.

    In COURSE LIST you are saying create two COLUMNS.

    COURSE LIST
    Column1 = Lookup to UserID  : [Me]?
    Column2 = Lookup User Level : ??? How do I do a lookup to a differnet List, User List and populate the data to Course List??

    Also, you are filtering on the VIEW correct?


    More Data:
    USER LIST
    Name [Lookup:NT_USER ID]
    User Level [Calc Column:DEFINED BY; Less than 100 PTs = L1]
    Points[Number]

    COURSE LIST
    Name of Course[Text: Defined]
    Course Link[Link:Supplied for location]
    Points[Number:Defined at creation]

    Monday, April 30, 2012 1:28 PM
  • Ok, I have been trying to find a way to create the two columns... they would have to be dynamic values however.
    The courses are assigned to multiple users.
    I did the lookup value for name.
    The lookup value for Level... which 'works' but only for the one user...

    I would need a lookup that would lookup according to the [ME] or current user on page then also a [me]level for the second coulmn2 for that way to work.

    Otherwise I would be looking up only the courses for the one person correct??

    Friday, May 4, 2012 1:14 PM
  • The current way I am trying to get this to work is by reading the ListID then filter via javascript to on the page.

    Seems like this may be the most logical way to do this with a javascript snippet added to the .aspx page

    Now to get this to work better.

    Friday, May 4, 2012 1:20 PM
  • The above is still not working.

    Still need help. It was a work around that is 'somewhat' working..

    If someone has accomplished this please post suggestions.

    Monday, May 7, 2012 12:51 PM
  • Jack,

    Your suggestion would have to have multipel users or a lookup that would change as users are on the page. A standard lookup is yielding a single value.

    If there was a way to make a lookup that used [ME] or did a lookup with filter for level then this would be a viable and usable solution!

    If you know those answers or have a suggestion I am all ears.

    Tuesday, September 18, 2012 9:32 PM