Newbie Questions

Re: Connection data. Get all nodes from SharePoint server.

warrtalon — Tue, 26 May 2009 14:06:49 GMT

Filtering can be done on the SharePoint side using a modified list view and an XML data view data connection to that view.

Re: Connection data. Get all nodes from SharePoint server.

Scroll — Tue, 26 May 2009 09:59:14 GMT

Thank you, Samir Farid! This is not exactly what I needed, but it helped me!

Re: Connection data. Get all nodes from SharePoint server.

Samir Farid — Tue, 26 May 2009 09:09:00 GMT

Hi Scroll,

The solution can be implemented without using code, but the filtering cannot be done on the sharepoint side, it has to be done on the infopath side.

Let's assume for my response that we have a dropdownlist on the form called EmployeeType. The dropdownlist contains 2 items "Programmers" & "Engineers".

Implement the following steps on the repeating table holding the SharePoint data:

[1] Double-click the Repeating Table to open its Properties dialog box.
[2] On the Repeating Table Properties dialog box, click Display, and then Conditional Formatting.
[3] On the Conditional Formatting dialog box, click Add.
[4] On the Conditional Format dialog box, add the following condition:

@EmployeeType (from SharePoint list) is not equal to EmployeeField (Dropdownlist)

[5] On the Conditional Format dialog box, select the Hide this control check box, and click OK.

This tells infopath to filter the repeating table and hide everything that does not match the selection in the dropdownlist.

[6] Click OK on all open dialog boxes.
[7] Test the InfoPath form template.

I managed to create this solution using some of the steps in the following article:

http://www.bizsupportonline.net/infopath2007/filter-sharepoint-list-infopath-repeating-table-date-range.htm

Hope it helps.

Re: Connection data. Get all nodes from SharePoint server.

Scroll — Tue, 26 May 2009 06:26:07 GMT

I need to put data from SharePoint server to repeating table. And if the initial condition = "programmers" - in a repeating table should be placed data about the programmers. If the initial condition = "engineers" - should be placed data about the engineers. I thought that it can not be done without code. [if variable="programmers"] get data "programmers" from SharePoint server; put data to repeating table; [endif] [if variable="engineers"] get data "engineers" from SharePoint server; put data to repeating table; [endif]

Re: Connection data. Get all nodes from SharePoint server.

warrtalon — Mon, 25 May 2009 15:55:29 GMT

I don't understand the question. if you want to get data from a SharePoint list or library, then you create a data connection, which will pull all the data from a given list or a library. Very simple without any code.

Connection data. Get all nodes from SharePoint server.

Scroll — Mon, 25 May 2009 10:01:57 GMT

Hello! I have a data on SharePoint server. How get and print all nodes from this data? I do (JScript): XDocument.DataObjects('names').Query(); data = XDocument.DataObjects('names').DOM.documentElement; But I do not know what to do next. As far as I know SelectNodes() gets only selected nodes and SelectSingleNode() gets only single node. Excuse me for my English. Thanks.