Results 1 to 10 of 10
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    Switzerland
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SQL filter ? (XP SP1)

    Folks,

    Go to customize current view -> filter

    See that "SQL" Tab ?

    Any idea how to use it ? No reference to it in the online help, as far as i can tell...

    Regards

    --alex

  2. #2
    5 Star Lounger
    Join Date
    Oct 2002
    Location
    Wellington, Wellington, New Zealand
    Posts
    621
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SQL filter ? (XP SP1)

    You may (or may not) wish to fire up VBA and then VBA help and look up the AdvancedSearch method which also makes reference to SQL search strings with a lot more information than help.

    (Oh how I wish MS help gave 'Why to' information, rather than just 'How to' information)

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Location
    Switzerland
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SQL filter ? (XP SP1)

    Well, not sure I see what you see...

    All I can find relevant is

    "Performs a search based on a specified SQL search string and returns a Search object."

    Doesn't help much, does it ?

    --alex

  4. #4
    5 Star Lounger
    Join Date
    May 2001
    Location
    Washington, USA
    Posts
    750
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SQL filter ? (XP SP1)

    Mine has the following text in it: "DAV:isfolder" = false AND "DAV:ishidden" = false

    For what little bit it's worth, DAV: is a WebDAV (.Net) programing class. Exchange has an OLEdB provider which can be used with CDO and ADO data access methods. The above text is part of a larger query string WHERE clause.

    I'm sorely tempted to play with this, but I have a feeling one could do some big, bad things in short order.

  5. #5
    5 Star Lounger
    Join Date
    Oct 2002
    Location
    Wellington, Wellington, New Zealand
    Posts
    621
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SQL filter ? (XP SP1)

    OldDog

    "but I have a feeling one could do some big, bad things in short order"

    - that's what's so tempting isn't it <img src=/S/grin.gif border=0 alt=grin width=15 height=15> I appreciated the snippets of information - that really underlined I don't want to play with it.

    Alex - that's the basic message (sorry I wasn't clearer). SQL is obviously there for use by undocumented Microsoft tools and the clear implication is - it may be fun to play with, but requires a whole lot of caution and you'll get no help from Microsoft.

  6. #6
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    Portland, Maine, USA
    Posts
    296
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SQL filter ? (XP SP1)

    If you create other things in the other tabs, such as filtering on multiple categories, etc., the SQL window will contain all of the information from these. What I have been able to do a couple of types (very carefully I might add) is to modify existing things to change OR to AND to control exactly what the filter is doing.

    If you do get something wrong, uncheck the "Edit these criteria directly" and this window will be cleared.

  7. #7
    Star Lounger
    Join Date
    Jan 2001
    Location
    Switzerland
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SQL filter ? (XP SP1)

    <hr>For what little bit it's worth, DAV: is a WebDAV (.Net) programing class. Exchange has an OLEdB provider which can be used with CDO and ADO data access methods<hr>
    Is this part of Exchange 2000 or a Titanium feature ?

    --alex

  8. #8
    5 Star Lounger
    Join Date
    May 2001
    Location
    Washington, USA
    Posts
    750
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SQL filter ? (XP SP1)

    I haven't dug very deeply into this technology. I understand the dav is partly a client/middle layer standard that only depends on OLEdB. We're running Exchange 5.5 for example; waiting for Titanium. But OLEdB knows about newer back ends like SQL 2000 and offers a richer feature set.

  9. #9
    Star Lounger
    Join Date
    Jan 2001
    Location
    Switzerland
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SQL filter ? (XP SP1)

    Hello !

    Doing some more digging I came accros this site:

    http://www.webdav.org

    <hr>What is WebDAV?

    Briefly: WebDAV stands for "Web-based Distributed Authoring and Versioning". It is a set of extensions to the HTTP protocol which allows users to collaboratively edit and manage files on remote web servers.<hr>
    IMHO we are not speaking about the same animal (or I am missing something...) !

    Any idea ?

  10. #10
    5 Star Lounger
    Join Date
    May 2001
    Location
    Washington, USA
    Posts
    750
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SQL filter ? (XP SP1)

    It's all part and parcel. In effect you can use http in conjunction with data access like ADO to read and write data. I imagine we'll see more of this as XML comes into heavier use and/or .Net begins to take over the world. I think a search on "DAV" in MSDN.microsoft.com would turn up some interesting programming examples.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •