具有2个数据连接的MS InfoPath表单。 [英] MS InfoPath Form with 2 data connections.

问题描述

我创建了一个SharePoint网站，其中有一个InfoPath表单，其中有几个

字段。在该表单中有4个文本框，用于从Windows Server 2008 R2的
的Active Directory中检索数据。



我创建了一个数据InforPath表单中的连接，用于检索First

Name，Last Name，Job Title和Department等数据。现在我创建了一个SharePoint列表，用于

商店'名字'，'姓氏'，'年度离职'，'职业离职'和'其他叶子'。



这意味着MS InfoPath表单中有2个数据连接，一个用于Active Directory

数据检索，一个用于SharePoint列表数据检索。



现在我只想查看InfoPath表单中的内容，如下所示。



Active Directory应该检索名字，姓氏，标题和部门。

SharePoint列表应该查看年度假期，职业假期和其他假期

对应于Active Directory的名字和姓氏。



我想要的是链接同一InfoPath表单中2个数据连接的数据。我无法想象

算法或任何其他方法来解决这个问题。



有人可以给我一些关于此的提示问题。



谢谢，

Chiranthaka

I have created a SharePoint site and within it there is an InfoPath form that has several
fields. Within that form there are 4 text boxes that retrieve data from the Active Directory of
Windows Server 2008 R2.

I have created a data connection within that InforPath form to retrieve data like 'First
Name', 'Last Name', 'Job Title' & 'Department. Now I have created a SharePoint list that used to
store 'First Name', 'Last Name', 'Annual Leaves', 'Vocational Leaves' & 'Other Leaves'.

It means that there are 2 data connections within the MS InfoPath form one for Active Directory
data retrieval & one for the SharePoint list data retrieval.

All I want is now to view the contents in the InfoPath form as the following.

The Active Directory should retrieve the First Name, Last Name, Title, & Department.
The SharePoint list should view the Annual Leaves, Vocational Leaves & Other leaves
corresponding to the First Name & Last Name of the Active Directory was supplied.

All I want is to link the data from 2 data connections in the same InfoPath form. I can't figure
out the algorithm or any other method to solve that problem.

Can someone please give me some tip about this matter.

Thank You,
Chiranthaka

推荐答案

所以你想要的将参数作为名字和姓氏发送到SharePoint列表，并检索相应的年度叶和其他值。您可以在数据连接属性中使用过滤器。在后端，它将检索所有列表值，但在表单上它将根据您已应用的过滤器显示结果。



关于我博客文章的更多细节：

使用过滤器在InfoPath数据连接中

So you want to send parameters to SharePoint list as first name and last name and retrieve the corresponding annual leaves and other values. You can make use of filters within the data connection property. In the back end it will retrieve all the list values but on the form it will show the result based on the filter you have applied.

More details on my blog post :
Using filters within InfoPath Data Connection

这篇关于具有2个数据连接的MS InfoPath表单。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！