Newbie Questions

Re: Filtering a Repeating table from a Secondary Data Source

mjaneczk — Mon, 22 Sep 2008 21:03:01 GMT

I found one little quirk with this. When starting from an empty list the view will thus not return anything. Thus, when you are in InfoPath design mode, you will not be able to create a repeating table from this empty list. To get around this, populate the list with a few rows of dummy data. One row doesn't work for a "repeating" table. Once the you get everything set up, remove the dummy data. The form should still work.

Re: Filtering a Repeating table from a Secondary Data Source

mjaneczk — Tue, 26 Aug 2008 18:34:01 GMT

I think I solved this. In order to get the URL for the view, I did the following:

Create the view - do whatever filtering you need.
View the view - click on the list and select the view.
Click Actions->Export to SpreadSheet.
Click Save - this will save an owssrv.iqy file.
Open up the owssrv.iqy file in Notepad.
You will see a long URL there. Copy this:

/_vti_bin/owssvr.dll?XMLDATA=1&List={C3AD1F34-C325-430E-BD9C-F6A3BF9D8E19}&View={E01AD6F9-0104-443D-9C3E-1FDBD1C856BE">https://<hidden>/_vti_bin/owssvr.dll?XMLDATA=1&List={C3AD1F34-C325-430E-BD9C-F6A3BF9D8E19}&View={E01AD6F9-0104-443D-9C3E-1FDBD1C856BE}

Build your data conenction -

select receive
select XML file
Paste in the URL from 6) 1). (above)
select "Access the data from specified location"
Uncheck Store copy of the data for offline use. <--- IMPORTANT - if checked this will keep old data in the form.
Name the conenction.
Check Automatically retreive data when form is opened. <-- IMPORTANT - will retreive each time form is opened.

From there you have a data connection to a view. I created a repeating table off this view.

The key to the article is to get the proper URL to the view. That is what gave me problems. It wasn;t until I was able to get the URL from "Exporting to SpreadSheet" that I was able to get over my trouble.

I hope this works out for people.

Re: Filtering a Repeating table from a Secondary Data Source

mjaneczk — Tue, 26 Aug 2008 15:44:26 GMT

Does anyone have any help on this? I am baffled.

Re: Filtering a Repeating table from a Secondary Data Source

mjaneczk — Fri, 15 Aug 2008 17:43:31 GMT

Thanks for the reply. I read the article and gave it a try. However I am having some difficulty. The XML that is returned is below. It describes all the columns but doesn't have the actual data. Am I doing something wrong? My URL is below also.

URL: https ://server/site/_vti_bin/owssvr.dll?Cmd=Display&List={C3AD1F34-C325-430E-BD9C-F6A3BF9D8E19}&View={E01AD6F9-0104-443D-9C3E-1FDBD1C856BE}&XMLDATA=TRUE

[NOTE: I had to put a space after https so that all of teh URL would show].

- <xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">

- <s:Schema id="RowsetSchema">

- <s:ElementType name="row" content="eltOnly" rs:CommandTimeout="30">

- <s:AttributeType name="ows_Attachments" rs:name="Attachments" rs:number="1">

<s:datatype dt:type="boolean" dt:maxLength="1" />

</s:AttributeType>

- <s:AttributeType name="ows_LinkTitle" rs:name="Title" rs:number="2">