SharePoint Integration

Re: Wildcard Text filter infopath 2013

Palvayi — Wed, 18 Nov 2015 20:22:29 GMT

Perviously I was used sharepoint list as the data source so I used REST web service for wildcard search in infopath. Now I am using sql server as data source so how to use this REST webservice. Or is there any other way to do the wild card search in infopath form.

Re: Wildcard Text filter infopath 2013

Palvayi — Fri, 06 Nov 2015 15:19:24 GMT

I have created another REST Data source to my other filters but only one filter is working. Like I created data source for wild card search field and equipmentName(drop down filter) when I try to apply both filters only one filter is working. If I remove DROP DOWN filter then the search filter is working fine and when two filters are added only drop down filter is working. Both filters are not working at a time. Can't we use two filters with REST data source. I didn't get this conflict when I used Sharapoint data source. Can I use different data sources on the same repeating table or can I implement this wild card search without REST data source. ? I used these formulas concat("https://[server]/_vti_bin/ListData.svc/Equipment_federal?$filter=(DESCR eq '", EquipmentName, "') eq true") for drop down list is it correct ?

Re: Wildcard Text filter infopath 2013

Hilary Stoupa — Thu, 05 Nov 2015 00:40:35 GMT

Yeah, I'm confused, sorry. Does your filter in your REST URL use lowercase and you need it to be upper case? I think there is a to upper in SharePoint REST. Maybe this will help you? http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part2-url-conventions/odata-v4.0-errata02-os-part2-url-conventions-complete.html#_Toc406398124

Re: Wildcard Text filter infopath 2013

Palvayi — Thu, 05 Nov 2015 00:35:52 GMT

yes filter is not finding lower case letters as my list data contains all in upper case

Re: Wildcard Text filter infopath 2013

Hilary Stoupa — Thu, 05 Nov 2015 00:29:35 GMT

You'll need to change your dropdowns to use your new data source I think? Not sure about the case sensitivity. Do you mean that the filter isn't finding items with a different casing than you are using in the REST URL?

Re: Wildcard Text filter infopath 2013

Palvayi — Wed, 04 Nov 2015 17:47:56 GMT

Thank you very much. I did some small mistakes but finally I made it and its working fine. Thanks for you help. I need some other help below is my output. I have changed the repeating table data connection with REST web service. Now the drop down lists are not working(I created drop downs with sharepoint list data connection) how can I use REST web service drop down lists ? and my new filter is case sensitive how to make it non-case sensitive

Re: Wildcard Text filter infopath 2013

Hilary Stoupa — Wed, 04 Nov 2015 17:05:56 GMT

I'm suggesting you try what you believe the output of the formula would be. So - something like: https://[server]/dor/OCG/_vti_bin/ListData.svc/Equipment_federal?$filter=substringof('Whatever the value of the Equipment Search field would be',DESCR) eq true

I'm sorry that I'm not explaining this in a way you can understand, but I don't know how else to explain it. I suggest you review some online tutorials for using SharePoint REST queries in InfoPath - maybe follow one precisely until you feel you understand the concept before trying to implement it in your specific form?

Re: Wildcard Text filter infopath 2013

Palvayi — Wed, 04 Nov 2015 16:29:13 GMT

Re: Wildcard Text filter infopath 2013

Palvayi — Wed, 04 Nov 2015 16:27:26 GMT

Now I am not getting any errors but filter is not working on Infopath

Re: Wildcard Text filter infopath 2013

Palvayi — Wed, 04 Nov 2015 15:18:00 GMT

I used https://[server]/dor/OCG/_vti_bin/ListData.svc/Equipment_federal?$filter=substringof('", EquipmentSearch, "',DESCR) eq true

Re: Wildcard Text filter infopath 2013

Hilary Stoupa — Mon, 02 Nov 2015 22:12:09 GMT

What I was wondering is what happens if you try the URL with the filter in the browser. Did you try that? Didn't you already create a data connection in InfoPath to the REST service?

Re: Wildcard Text filter infopath 2013

Palvayi — Mon, 02 Nov 2015 20:02:26 GMT

I am getting this error. But am able to retrieve XML data from the URL

Re: Wildcard Text filter infopath 2013

Palvayi — Mon, 02 Nov 2015 18:49:59 GMT

I Used this formula concat("https://[server]/_vti_bin/ListData.svc/Equipment_federal?$filter=substringof('", DESCR, "',my:EquipmentSearch) eq true") and its working fine and the URL also fetching XML data when I opened in a browser(https://[server]/_vti_bin/ListData.svc/Equipment_federal). The form fetching data with other filters except this equipmentSearch filter. Am I missing something in infopath to link with the formula ??

Re: Wildcard Text filter infopath 2013

Hilary Stoupa — Mon, 02 Nov 2015 18:37:05 GMT

Test the URL your Change Rest URL rule should be creating - take the same formula you are using there and add it to the form in a calculated value, so you can see what the URL is. Try the URL in your browser's address bar. If the filter does not work, try making modifications to the URL until you have the syntax right. Sometimes IE will return a message that the content can't be displayed, but you can use view source to determine if your filter is returning data.

Re: Wildcard Text filter infopath 2013

Palvayi — Mon, 02 Nov 2015 18:06:58 GMT

I have changed the fields in the formula first I Used DESCR and then EquipmentSearch. Now I am not getting any error but the filter is not working. I have added Change REST URL and Query Data to the submit button.