General

Re: Multiple data connection so re query data connection

welshartnow — Tue, 10 Mar 2020 08:54:46 GMT

Add a new data connection GetUserProfileByName, location something like http://mysite/_vti_bin/userprofileservice.asmx?WSDL , operation select GetUserProfileByName, untick automatically retrieve data when form is opened
This data connection can be queried multiple times but you need to supply the particular account name each time you query the connection
For user1 make sure you have a field storing their accountusername on your view then on this field set a rule AccountName = user1account name
Now set another rule on this field which queries for data (getuserprofilebyname) based on the new account name
Now add another rule on this field which picks up one of the returned fields for the particular user and allocates it to a field on your form eg Rule , User1email (field) = Value[Name="WorkEmail"]
Then keep repeating for each of the fields you require returned for user1
Now for user2 have a field storing their particular account name and repeat the above to do the same as above--

Does this make any sense?

Regards Martin

Re: Multiple data connection so re query data connection

Sgt Shagrat — Mon, 09 Mar 2020 16:59:03 GMT

Can you explain me how u did it? Wich rules I had to use? I'm confusing just a little sorry. Thanks in advance

Re: Multiple data connection so re query data connection

welshartnow — Mon, 24 Feb 2020 16:23:34 GMT

Thank you very much for your reply. Yes I have tried this and it does work, originally I was binding the fields to the data query fields and of course they kept changing as I queried the connection each time, so I cleared those bindings out and set the value of the fields within the rules. And I can query as many times as I wish . Thank you Hillary!!

Re: Multiple data connection so re query data connection

Hilary Stoupa — Mon, 24 Feb 2020 15:48:20 GMT

It depends on how you are using the results. If you query the data connection, use rules to set some fields, and then query the data connection again with a different filter, that will work fine. If you are using it for a dropdown, however, whatever the last result set is will display (same issue with a default value).

Multiple data connection so re query data connection

welshartnow — Sat, 22 Feb 2020 18:07:02 GMT

I need to query the same data source multiple times. Can I re filter the same data source multiple times or do I need to create multiple data connections of exactly the same type? Thank you for any advice on this.