Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SharePoint > SharePoint Development
|
SharePoint Development Programming and development for SharePoint Portal Server and Windows SharePoint Services
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SharePoint Development section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 13th, 2010, 02:33 AM
Friend of Wrox
 
Join Date: Jan 2007
Posts: 115
Thanks: 2
Thanked 0 Times in 0 Posts
Question Web Service Get List ID with VBSCRIPT to filter on for UpdateListItems

Hi, I'm using Web Service with VBScipt

I can no longer go Title to do my filtering. I need to determine the ID to the filtering.
My UpdateListItems Method works when i have Title or ID (which is now unkown), Then I used the FileRef
Code:
dates the columns where items are listed
batch = batch + "  <Field Name='ID'>3</Field>"
batch = batch + "  <Field Name='FSObjType'>1</Field>"
batch = batch + "  <Field Name='Vendor'>8888888</Field>"
batch = batch + "  <Field Name='Site'>8888888</Field>"
 
---Updates document within Library then filter works on FileRef
---but it works only when renaming the document within the folder. 
batch = batch + "  <Field Name='FSObjType'>1</Field>"
batch = batch + "  <Field Name='FileRef'>http://.../Test/temp4.txt</Field>"
batch = batch + "  <Field Name='BaseName'>temp4.txt</Field>"
Please are there any other options i can filter on to get the item on item list level or perhaps the GETID method as last resort

I have started with the GETLISTITEMS Method to return the ID, my filter works & i can see all the values for that specific Item:
Code:
batch = "<Query><Where><Eq><FieldRef Name='FileLeafRef'/><Value Type='Folder'>AB Test</Value></Eq></Where></Query>"
wfields = "<viewFields><FieldRef Name='ows_ID'/></viewFields>"
 
request =  request + "<soap:Envelope xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'"
request =  request + "            xmlns:xsd='http://www.w3.org/2001/XMLSchema'"
request =  request + "            xmlns:soap='http://schemas.xmlsoap.org/soap/envelope/'>"
request =  request + "  <soap:Body>"
request =  request + "  <GetListItems xmlns='http://schemas.microsoft.com/sharepoint/soap/'>"
request =  request + "              <listName>" & list & "</listName>"
request =  request + "              <query>" & batch & "</query>"  
request =  request + "              <ViewFields>" & strviewfields & "</ViewFields>" 
request =  request + "  </GetListItems>"
request =  request + "  </soap:Body>"
request =  request + "</soap:Envelope>"
But how do i retrun the 'ows_ID' value & insert to Vbscript Var

Please Assist!

Last edited by ismailc; January 13th, 2010 at 02:35 AM..
 
Old January 13th, 2010, 04:32 AM
Friend of Wrox
 
Join Date: Jan 2007
Posts: 115
Thanks: 2
Thanked 0 Times in 0 Posts
Question

Please, i need to get the retunring filed "ows_ID" value
in my vbscript wscript.echo .responseText then i see all the values but no clue on getting the "ows_ID" value

Please Help
 
Old January 27th, 2010, 08:32 AM
Authorized User
 
Join Date: Jan 2010
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to elizas
Default Web service get list ID

Generally web applications in SharePoint are created using the out-of-box functionality provided within Central Administration. But because of some client's needs there might be a requirement of creating these web applications within a custom utility solution. This functionality can be achieved programmatically using Microsoft SharePoint APIs. By this, one can easily create a web application & associate a content database to it, register the web application in the IIS server, create an associated application pool and define different credentials for the web aplication.

Thanks
Eliza
__________________
Cheers,
Eliza

Mindfire: India's Only Company to be both Apple Premier & Microsoft Gold certified.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Combobox list filter headworth Visual Studio 2008 1 December 21st, 2009 11:16 AM
List Box Refresh When Invoking Filter RodM Access VBA 0 January 4th, 2009 09:54 AM
Invalid Drop down list ID efactory BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 2 November 30th, 2008 05:14 PM
UpdateListItems ruso77 Infopath 1 December 25th, 2007 04:40 AM
VBScript to verify if service running in IIS savoym VBScript 0 July 30th, 2003 12:53 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.