Connection data. Get all nodes from SharePoint server. - InfoPath Dev
in

InfoPath Dev

Connection data. Get all nodes from SharePoint server.

Last post 05-26-2009 07:06 AM by warrtalon. 5 replies.
Page 1 of 1 (6 items)
Sort Posts: Previous Next
  • 05-25-2009 03:01 AM

    • Scroll
    • Not Ranked
    • Joined on 05-25-2009
    • Posts 7

    Connection data. Get all nodes from SharePoint server.

    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.
  • 05-25-2009 08:55 AM In reply to

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

    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.

  • 05-25-2009 11:26 PM In reply to

    • Scroll
    • Not Ranked
    • Joined on 05-25-2009
    • Posts 7

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

    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]
  • 05-26-2009 02:09 AM In reply to

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

    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:
     
    Hope it helps.
  • 05-26-2009 02:59 AM In reply to

    • Scroll
    • Not Ranked
    • Joined on 05-25-2009
    • Posts 7

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

    Thank you, Samir Farid! This is not exactly what I needed, but it helped me!
  • 05-26-2009 07:06 AM In reply to

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

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

Page 1 of 1 (6 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.