Passing a value in a URL to a custom list to filter

I have a custom sp 2007 list that has records by a value called "job ID".  I am trying to find a way to pass that in a url so that when the list display execute that only the records with the selected job ID will show.

Matt PinkstonAsked:
Who is Participating?
 
Matt PinkstonAuthor Commented:
actually I figured a slicker way which was easy

assignments.aspx?FilterField1=Title&FilterValue1=CRMAM1%2D3%2D3BM1QQ9
0
 
Kent DyerIT Security Analyst SeniorCommented:
Can you show what you have already?

Thanks,

Kent
0
 
Matt PinkstonAuthor Commented:
I just created a list called assignments that has the following fields.
Job ID
Employee Name
Employee ID
Hours

From my other custom list that has Job ID as a value I would like to build a link on one of the custom pages that points at assignments via assignments.aspx?job%20ID=xxx but not sure how to ensure that passing that value will make the list then only show the records that match the job ID.
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
FastFngrzCommented:
Using SharePoint Designer, you can create a dataview webpart that has a parameter of type Query String URL, whereby the variable is passed into the page via the URL, plucked out by the DVWP and used as the filter.

See http://www.sharepoint911.com/blogs/laura/Lists/Posts/Post.aspx?List=676af157-7d96-4e15-a987-54b8a3e4d948&ID=77 for details.

Depending on what version of SharePoint you have, you might have some solutions already available!  See Laura's post above.
0
 
FastFngrzCommented:
Winner!
0
 
Matt PinkstonAuthor Commented:
found this solution doing further research on other sites plus trial and error
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.