Re: Where are the list items stored?
- From: Bob Mixon <bob.mixon@xxxxxxxxx>
- Date: Tue, 27 Dec 2005 16:32:29 -0800
As Bill indicated, they are in the database but it is rare you ever need to retrieve them from there. Would you like to retrieve list items in XML? If so, here is how you do it:
======================================================= This approach uses the (GET) URL Protocol.
1) Determine the GUID of a list whose data you need in XML.
1.a) Navigate to the allitems.aspx view of the list in question
1.b) Click the "Modify Settings and Columns" link on the left side
1.c) Copy the List's GUID (including curly braces) from the address bar
2) Construct the URL to retrieve the list's data in XML format (it's case sensitive, be careful!)
2.a) The requested object is http://servername/sitename/_vti_bin/owssvr.dll
2.b) The object will expect three parameters: Cmd, List and XMLDATA (case sensitive)
2.c) Since we're displaying items (in XML format), the value of the Cmd parameter should be Display
2.d) We want to grab the list whose GUID we determined in step one; the value of the List parameter is this GUID (including curly braces)
2.e) Of course, we want XML data to be returned; the value of the XMLDATA parameter will be TRUE
Putting this together, we get a URL that looks like this: http://server/site/_vti_bin/owssvr.dll?Cmd=Display&List={E1D9FED5-2531-413F-8C0F-CAA5C6280E51}&XMLDATA=TRUE
Sit back and marvel at how easy it is to get a rowset out of SharePoint without using the Object Model or the Web Services. You can point a Data View web part to this URL and grab data from another SharePoint site without adding the whole site to your DV catalog listing. You may find that it doesn't return EVERY field. That's right: It returns fields that are defined in the default "allitems" view of that particular list. If you want more fields, you have two choices:
Modify the allitems.aspx view to show more fields (easy) Pass an additional URL parameter, View, with the GUID value of the view whose fields you want to return (a little more involved/tedious)
=======================================================
A note about the tip listed above -- I didn't write it, nor can I take credit for it. This super geek, super cool tip came directly from Dustin Miller who had posted it on MSD2D (8/25/2004).
------------------------ Bob Mixon (Blog) http://bobmixon.xwiki.com ------------------------
Hi,
I'm wondering where I can find the list items in WSS? Are they in XML? Because I can't seem to find them in the database.
//Pia
.
- Follow-Ups:
- Re: Where are the list items stored?
- From: Mrs Beata
- Re: Where are the list items stored?
- References:
- Where are the list items stored?
- From: Mrs Beata
- Where are the list items stored?
- Prev by Date: Re: Audience filtering not working
- Next by Date: Re: default view to show the filter
- Previous by thread: Re: Where are the list items stored?
- Next by thread: Re: Where are the list items stored?
- Index(es):
Relevant Pages
|
