Qdabra qRules

Re: Question on FilterQwssvr

Marzipan — Wed, 02 Feb 2011 15:19:58 GMT

For the User Information List, it look like you need to use http://hscsbidev2:1105/_catalogs/users as the sharepoint URL

http://www.beyondweblogs.com/post/User-Information-List-URL-in-SharePoint.aspx

Re: Question on FilterQwssvr

ErnestoM — Wed, 02 Feb 2011 14:55:22 GMT

QueryBuilder allows you to query a SQL database or a SharePoint list. Can you check that the option for SharePoint is selected? That error message seems to indicate that QueryBuilder is trying to connect to a SQL database.

Re: Question on FilterQwssvr

Marzipan — Wed, 02 Feb 2011 14:18:27 GMT

Query Builder

Using http://hscsbidev2:1105/_layouts/people.aspx as the Sharepoint list URL.

I got an exception "List could not be found"

---------------------------
Qdabra Query Builder
---------------------------
Could not determine the database schema.

Check your connection string and try again.

Details:The query cannot be run for the following DataObject: DescribeListSchema

InfoPath cannot run the specified query.
The SOAP response indicates that an error occurred on the server:

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.ApplicationException: List could not be found (http://hscsbidev2:1105/_layouts/people.aspx )
   at Qdabra.Dbxl.WebService.Implementation.QuerySharePointServiceImpl.GetListGuids(String listUrl, String& siteUrl, String& webUrl, String& listId, String& webId)
   at Qdabra.Dbxl.WebService.QuerySharePointService.DescribeListSchema(String listUrl)
   --- End of inner exception stack trace ---

---------------------------
OK
---------------------------

Re: Question on FilterQwssvr

ErnestoM — Wed, 02 Feb 2011 13:55:32 GMT

Hi-

1. The command FilterOwssvr only works with SharePoint's http://<servername>/_vti_bin/owssvr.dll.

2. I don't believe owssvr.dll will handle wildcards, but I will have to check. If you have DBXL, you could use QuerySharePoint to do server side filtering.

Question on FilterQwssvr

Marzipan — Wed, 02 Feb 2011 13:11:15 GMT

1) does it only work on a data source created with http://hscsbidev2:1105/_vti_bin/owssvr.dll?Cmd=Display&List=.... or can it work on any data source

2) does the "value=" have to be an exact match, I want to filter on items that contain "*HS"