Challenge: Querying data connection then passing column to second

[Michael S]

Product: InfoPath 2007 browser enabled form connecting to multiple SharePoint
2007 list

Challenge:

I need to design a form that can query against one SharePoint list to
determine the department a user (using username()) is in then pass the
department’s unique identifier to another data connection (SharePoint list)
and return only those results specific to that department. I need the
filtering to happen on the server side because there are 65,000 rows.

My first design idea was to write some custom code, which would allow me to
call a specific SharePoint view. The view would be filtered by person or
group=me. This would work if I had only one user from each dept querying the
data and I associated their username with the rows, but I have multiple user
from each dept.

Any ideas on how I could query against one list to determine what department
the user is in then use that department’s unique identifier to query against
the second data source?

I would really appreciate any tips or links to resources.

Thanks!

 

[Paresh]

Product: InfoPath 2007 browser enabled form connecting to multiple SharePoint
2007 list

Challenge:

I need to design a form that can query against one SharePoint list to
determine the department a user (using username()) is in then pass the
department’s unique identifier to another data connection (SharePoint list)
and return only those results specific to that department. I need the
filtering to happen on the server side because there are 65,000 rows.

My first design idea was to write some custom code, which would allow me to
call a specific SharePoint view. The view would be filtered by person or
group=me. This would work if I had only one user from each dept querying the
data and I associated their username with the rows, but I have multiple user
from each dept.

Any ideas on how I could query against one list to determine what department
the user is in then use that department’s unique identifier to query against
the second data source?

I would really appreciate any tips or links to resources.

Thanks!

Hi,

Please take a look at the cascading dropdown article by InfoPath team
blog at the following url:
http://blogs.msdn.com/infopath/archive/2006/10/12/cascading-dropdowns-in-browser-forms.aspx

Hope this helps.

Thanks,
Paresh

 

[Michael S]

Thanks Paresh. Would this be easier to do with SQL instead of data
connections to SharePoint list?

Could you or anyone else expand on how I could pass the username including
the domain through to SharePoint list then use a column from that SharePoint
list to query against another SharePoint list? I'm basically trying to create
a solution where I can use the person/group column equal to multiple users
instead of single user (the users would be based on the first SharePonit
list).