InfoPath Dev

You would use a concat formula to set the URL, and it would look something like this: concat("http://URL/_vti_bin/owssvr.dll?CS=65001&XMLDATA=1&RowLimit=0&List={5166419E-2DB1-4EA4-8911-FC12ADE6D57A}&View={13217A3C-60A8-4FA9-9662-7BBD1EB19FC8}&XMLDATA=TRUE&FilterField1=@ows_ID&FilterValue1=", Path to the field ...

Thats what I read too but not sure how to use an ID field from the SHarePoint current list item and = to @ows ID. It retireves nothing but if I do @ows_ID = '81' or some number it works. in other words I have  a  1st data connection which recieves all IDs from the current active form and than I have the 2nd ...

Oh wonderful! Great job!

Thanks, got it, using the following  where SynopisID is on the main form and is the lookup column in the SP List xdXDocument:GetDOM("GetMetrics")/dfs:myFields/dfs:dataFields/dfs:Metrics[@SynopsisID = xdXDocument:get-DOM()/my:myFields/my:synopsisID][number(xdXDocument:GetDOM("ViewOptions")/Util/fields/Count)]/@ID

I just wanted to add - I'd not realized this, but Jimmy pointed out in email that: ...a REST connection in InfoPath was just any service that returns XML based on the URL it's passed So, if you are needing just basic equivalency, owssvr.dll is probably a great way to go! OData is great for more complex queries - if you check out the ...

[quote user="cpluce"]The form was already domain trust. Thanks Hilary you been very helpful. The disable loopback fixed it I have one little issue left. I am able to set the filters statically in this URL by using the filter in the default value by using ID = "1" /some number but I am having trouble using ID = field ...

I must not be being very clear. Yes, this can be done. You'll need to use a field for a counter - I think the original document I directed you to does that? You'll need to use multiple filters, like I mentioned in another earlier post - like group/repeatingGroup[ID = 1][1]/field So, the filter for the correct ID, and then your counter.

ok, so back to my earlier problem, how to apply a filter and step through the filtered results for each section in the repeating section. can this even be done?

Hi all, In my MOSS 2007 environment, I have successfully uploaded an InfoPath 2007 form (designed using IP 2010) to central admin and have a content type that for the most part works fine. However, I notice that I am unable to hide 6 of the 50 columns in the content type and was wondering if anyone had advice on what to do to resolve this ...

Nope - it is because your form is IP 2007 - it would need to be 2010 to have the query fields.