Qdabra qRules

Re: Query Sharepoint List - Partial Match

Patrick Halstead — Sat, 13 Jul 2013 20:35:54 GMT

My reading of the above suggests that they got REST to work by switching SSL off.

REST should work with SSL for that's what O365 uses. Certainly the qRules owssvr technique will work as well.

Re: Query Sharepoint List - Partial Match

sucheta — Thu, 11 Jul 2013 21:43:14 GMT

I am having exact same issue. I used REST web connection to get a filtered data from the SharePoint list in the InfoPath form. It worked fine on my dev server as the dev sharepoint site is not SSL, but it is not working on production as my production site is SSL enabled. Can you please explain me your work around?

Re: Query Sharepoint List - Partial Match

Den12 — Thu, 21 Mar 2013 20:42:06 GMT

As posted below, the post with details about the partial-match search/filter has been moved to forum "Infopath 2010" here.

Check the link guys.

Re: Query Sharepoint List - Partial Match

tech_ware — Sun, 10 Mar 2013 11:57:26 GMT

Den12:

Most web searches on Infopath & wildcards filtering still deliver either code-based solutions via ADO & Database use or REST approch mentioned here.

Unless I am missing an important detail, I was able to do partial-match search on SP List & Form Libray Forms data with Infopath 2010.

Screenshot attached. If there are people still interested in the topic, please reply to this post and I will provide some details.

Hi Den12,

I am facing a similar challange. Can you help me out on how did you set the rules? I am using SP2010 and IP 2010. My requirement is that the column head should be selected from a dropdown list on the form and the partial value should come from a text box.

Re: Query Sharepoint List - Partial Match

Den12 — Thu, 07 Mar 2013 14:17:58 GMT

Ok, as it is not related to qRules I will move the partial-match description to a separate post, Infopath 2010 here.

Re: Query Sharepoint List - Partial Match

Hilary Stoupa — Tue, 05 Mar 2013 22:04:39 GMT

Very cool stuff - details would be great!

Re: Query Sharepoint List - Partial Match

Den12 — Tue, 05 Mar 2013 21:20:40 GMT

Most web searches on Infopath & wildcards filtering still deliver either code-based solutions via ADO & Database use or REST approch mentioned here.

Unless I am missing an important detail, I was able to do partial-match search on SP List & Form Libray Forms data with Infopath 2010.

Screenshot attached. If there are people still interested in the topic, please reply to this post and I will provide some details.

Re: Query Sharepoint List - Partial Match

w2truong — Thu, 02 Jun 2011 17:12:06 GMT

Thanks. This is going to give me more flexibility. But can you have multiple filters in a REST URI?

Re: Query Sharepoint List - Partial Match

jchilde — Sat, 28 May 2011 15:08:15 GMT

Just in case you need to help others with this issue - I could not use REST with my CaseMaster list becuase I had a calculated Yes/No column. This apparently breaks the REST service for a list.

Re: Query Sharepoint List - Partial Match

jchilde — Mon, 23 May 2011 15:43:09 GMT

No. In fact it is a normal list on the same server and site that I have been using exclusively up to this point.

Re: Query Sharepoint List - Partial Match

Hilary Stoupa — Mon, 23 May 2011 15:10:32 GMT

Any chance CaseMaster is an external list?

Re: Query Sharepoint List - Partial Match

jchilde — Mon, 23 May 2011 13:08:18 GMT

I did get everything working; however, I have run into another snag that perhaps you can point me in the right direction on.

I am now implementing my solution on a production list; however, I have one list that I cannot seem to connect to with REST.

In the data connection wizard, I enter my connection string properly, just like I did on the test list. I get the error "could not open "http:/..../_vti_bin/ListData.svc/CaseMaster" and then when I click ok i get a second message "InfoPath cannot open the XML document: http://..../_vti_bin/ListData.svc/CaseMaster Not enough storage is available to process the command."

I know this is a generic message.

To troubleshoot, I entered into my web brower http://..../_vti_bin/ListData.svc/CaseMaster and I get a 404 error. When I do the same and enter any other production list, I get the first 1000 records of that list. So something about this list is not working. (The list has 20,000 entries; however, I have made appropriate adjustments to resource throttling without solving the problem - I am able to connect to other lists with over 100,000 entries)

Here is a snippet from my raw ListData.svc xml

- <collection href="CaseMaster">

<atom:title>CaseMaster</atom:title>

</collection>

- <collection href="CaseMasterArchived">

<atom:title>CaseMasterArchived</atom:title>

</collection>

- <collection href="CaseMasterAssignedAttorney">

<atom:title>CaseMasterAssignedAttorney</atom:title>

Can you point me in the right direction for troubleshooting?

Re: Query Sharepoint List - Partial Match

jchilde — Fri, 20 May 2011 03:25:51 GMT

I appologize - I see "tolower" in the link now. Not sure why it didn't jump out at me sooner. You rock! Thanks.

Re: Query Sharepoint List - Partial Match

Hilary Stoupa — Thu, 19 May 2011 19:43:34 GMT

URI protocol to the rescue again - change it to lower, using the tolower() function:

concat("http://[my server]/_vti_bin/ListData.svc/Clients?$filter=startswith(tolower(LastName), tolower('", Last Name, "')) eq true")

Re: Query Sharepoint List - Partial Match

jchilde — Thu, 19 May 2011 19:27:07 GMT

I am using a work around - just opened up the site to non-html over the internet. May be my only option since it appears that https won't work.

I have one other question that you probably know off the top of your head - here is my REST string:

concat("http://[my server]/_vti_bin/ListData.svc/Clients?$filter=startswith(LastName, '", Last Name, "') eq true")

How can I change this to not be case sensitive. For example, I have a client named A'Miracle. Some will put A'miracle and others the actual spelling. I don't think the translate function will work. Any ideas?