Hi All, I am a developer and am working on a webdav application to process emails on a particular public folder. I have also added a property on emails which are processed so when I reply to them and receive them back I can check if they have been sent from my application. My problem is that when I try to do a webdav select on the public folder to retrieve emails with my new property, the request fails since it is invalid. I guess the problem is that webdav fails since these properties do not exist on normal email. I would like to find a way how I can do a webdav select on items with and without my property without failing. I was also reading about schemas and how to define contentclass but I am finding it quite complicated. Is there anyone who can guide me to solve my issue? Thanks
Post your sql query here. Michael ------------------------------- If you need WebDAV API for Exchange server, use our component WebDAV .NET for Exchange. Check out http://www.independentsoft.com "Startatrix" wrote in message news:CC6413EA-45E1-4B71-9DC9-5C60D2CED712@microsoft.com... > Hi All, > > I am a developer and am working on a webdav application to process emails > on a particular public folder. I have also added a property on emails which > are processed so when I reply to them and receive them back I can check if > they have been sent from my application. > > My problem is that when I try to do a webdav select on the public folder to > retrieve emails with my new property, the request fails since it is invalid. > I guess the problem is that webdav fails since these properties do not exist > on normal email. > > I would like to find a way how I can do a webdav select on items with and > without my property without failing. I was also reading about schemas and how > to define contentclass but I am finding it quite complicated. > > Is there anyone who can guide me to solve my issue? > > Thanks >
Hi, I am using this sql sQuery = "<?xml version='1.0'?>" & _ "<g:searchrequest xmlns:g='DAV:' >" & _ "<g:sql>SELECT ""DAV:displayname"" , ""xmlns:d='http://domain.com.au/ebit/e5SiteURL"" " sQuery = sQuery & " FROM SCOPE('SHALLOW TRAVERSAL OF """ & sUri & """')" ' 'SHALLOW TRAVERSAL OF """ & sUri & """' sQuery = sQuery & " WHERE ""DAV:isfolder"" = false" sQuery = sQuery & "</g:sql>" & _ "</g:searchrequest>" I also tried to put the xmlns bit between the searchrequest but is does not work since the items do not usually have the property I am looking for Thanks "Michael" wrote: > Post your sql query here. > > Michael > ------------------------------- > If you need WebDAV API for Exchange server, > use our component WebDAV .NET for Exchange. > Check out http://www.independentsoft.com > > "Startatrix" wrote in message news:CC6413EA-45E1-4B71-9DC9-5C60D2CED712@microsoft.com... > > Hi All, > > > > I am a developer and am working on a webdav application to process emails > > on a particular public folder. I have also added a property on emails which > > are processed so when I reply to them and receive them back I can check if > > they have been sent from my application. > > > > My problem is that when I try to do a webdav select on the public folder to > > retrieve emails with my new property, the request fails since it is invalid. > > I guess the problem is that webdav fails since these properties do not exist > > on normal email. > > > > I would like to find a way how I can do a webdav select on items with and > > without my property without failing. I was also reading about schemas and how > > to define contentclass but I am finding it quite complicated. > > > > Is there anyone who can guide me to solve my issue? > > > > Thanks > >
I just generate your query with our API and works fine. You request body must be: <?xml version="1.0" encoding="utf-8"?> <D:searchrequest xmlns:D="DAV:"> <D:sql> SELECT "DAV:displayname","http://domain.com.au/ebit/e5SiteURL","DAV:isfolder" FROM "http://server/exchange/User1/Inbox" WHERE "DAV:isfolder" = False </D:sql> </D:searchrequest> Michael ------------------------------- If you need WebDAV API for Exchange server, use our component WebDAV .NET for Exchange. Check out http://www.independentsoft.com "Startatrix" wrote in message news:29DA042D-AB4B-42D0-8214-D300AA2D1644@microsoft.com... > Hi, > I am using this sql > > sQuery = "<?xml version='1.0'?>" & _ > "<g:searchrequest xmlns:g='DAV:' >" & _ > "<g:sql>SELECT ""DAV:displayname"" , > ""xmlns:d='http://domain.com.au/ebit/e5SiteURL"" " > sQuery = sQuery & " FROM SCOPE('SHALLOW TRAVERSAL OF """ & sUri > & """')" ' 'SHALLOW TRAVERSAL OF """ & sUri & """' > sQuery = sQuery & " WHERE ""DAV:isfolder"" = false" > sQuery = sQuery & "</g:sql>" & _ > "</g:searchrequest>" > > I also tried to put the xmlns bit between the searchrequest but is does not > work since the items do not usually have the property I am looking for > > Thanks > > "Michael" wrote: > > > Post your sql query here. > > > > Michael > > ------------------------------- > > If you need WebDAV API for Exchange server, > > use our component WebDAV .NET for Exchange. > > Check out http://www.independentsoft.com > > > > "Startatrix" wrote in message news:CC6413EA-45E1-4B71-9DC9-5C60D2CED712@microsoft.com... > > > Hi All, > > > > > > I am a developer and am working on a webdav application to process emails > > > on a particular public folder. I have also added a property on emails which > > > are processed so when I reply to them and receive them back I can check if > > > they have been sent from my application. > > > > > > My problem is that when I try to do a webdav select on the public folder to > > > retrieve emails with my new property, the request fails since it is invalid. > > > I guess the problem is that webdav fails since these properties do not exist > > > on normal email. > > > > > > I would like to find a way how I can do a webdav select on items with and > > > without my property without failing. I was also reading about schemas and how > > > to define contentclass but I am finding it quite complicated. > > > > > > Is there anyone who can guide me to solve my issue? > > > > > > Thanks > > >
