Qdabra qRules

Re: Determine which subsite called form?

ChrisJackson19 — Fri, 05 Dec 2014 14:38:15 GMT

klink, nice one and good detail.

I've was having a play with it earlier this morning and got it to work, although I think I'll update my method for retrieving the list GUID to how your doing it above.

I'm currently storing the GUIDs in a list at the site collection root (all my subsites are provisioned programmatically anyway, so only slight amendment to record the GUIDs for my lists/libraries) but your way is more robust I think (especially if people delete the list items in my root GUIDs list by mistake).

So I guess for anyone else in the future we've got a pretty good method for doing this.

Syntax for Changing a SharePoint List Data Connection for future reference:

ChangeConnectionUrl /dsname= /url= /listguid=

Re: Determine which subsite called form?

klink — Fri, 05 Dec 2014 14:07:42 GMT

Well, if you have read the first page of this message string, Hilary says:

"So - use ChangeConnectionUrl on the connection to lists.asmx to change it to your "current" site. Query the getlist method with your list name and one piece of info you'll get back is the GUID. Use ChangeConnectionUrl with the top secret undocumented listguid parameter for your SharePoint list connection......and you will now be querying your "current" site. :) you will see that the listguid parameter is top secret and not documented anywhere yet except this message string."

Here is what I did in my form:

SiteURL - Field with value = function SharePointSiteUrl()
GUID - Field that contains the list's GUID
ListName - Field for the name of the list I'm changing (Mine is set to "Agency")
GetListUDC - Data Connection for GetList

On Qdabra's finishLoading parameter, I set a rule to set the current URL:

concat("ChangeConnectionUrl /dsname=GetListUDC /url=", SiteURL, "_vti_bin/lists.asmx")

Expanded: concat("ChangeConnectionUrl /dsname=GetListUDC /url=", my:TestFields/my:SiteURL, "_vti_bin/lists.asmx")

To get the GUID for a specific list:

Set a field's value: listName (from the GetList data connection queryFields) to ListName (this is where I stored the name for my list)
Query using a data connection: GetListUDC (the name of my data connection for GetList)
Set a field's value: GUID to: *[local-name() = "List"]/@*[local-name() = "ID"]

Expanded: xdXDocument:GetDOM("GetListUDC")/dfs:myFields/dfs:dataFields/tns:GetListResponse/tns:GetListResult/*[local-name() = "List"]/@*[local-name() = "ID"]
see Hilary's excellent explanation on Page 2 of this message string.

To retrieve the list you want with the correct URL/GUID (this is the super-secret part!!!) (NOTE: My list name is "Agency")

Set a field's value: Command (from QdabraRules) to: concat("ChangeConnectionUrl /dsname=Agency /url=", SiteURL, " /listguid=", GUID)

Expanded: concat("ChangeConnectionUrl /dsname=Agency /url=", my:TestFields/my:SiteURL, " /listguid=", my:TestFields/my:GUID)

Query using a data connection: mine is "Agency"

Hopefully this makes sense. Hilary, if you happen to be looking at this, please correct anything that I have wrong, or could have been done better! =)

Re: Determine which subsite called form?

ChrisJackson19 — Fri, 05 Dec 2014 09:06:24 GMT

Sorry, I should have put it in context and given a bit more detail.

I've been using qrules for quite a while now on various projects, and have read both the documents you suggested, but this is the first time i've had cause to use the ChangeConnectionUrl function.

I specifically need the syntax or examples when you are changing the connection URL for a "SharePoint List" Data Connection, and specifically the listguid switch.

This doesn't seem to be documented anywhere for this type of data connections despite being advertised as a new feature in v5.2.

Thanks again.

Re: Determine which subsite called form?

klink — Thu, 04 Dec 2014 19:43:17 GMT

I used the Command Overview document to start with. You'll find ChangeConnectionUrl under the Data Connection section. I also used Dynamically Set Submission for a Form Library and a List. And a LOT of help from Hilary in this post!

Re: Determine which subsite called form?

ChrisJackson19 — Thu, 04 Dec 2014 18:30:34 GMT

Is there any documentation for the changeconnectionurl command for sharepoint list connections or examples of the required syntax? Thanks

Re: Determine which subsite called form?

Hilary Stoupa — Mon, 24 Nov 2014 15:53:32 GMT

WHOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO HOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO!

Good job!

Re: Determine which subsite called form?

klink — Mon, 24 Nov 2014 15:47:25 GMT

It is working with the .udcx data connection! After figuring out what to do without a developer, and then waiting until the developer got back to set the permissions correctly, it now works like a charm! Even the super-secret listguid parameter!!!

As always, THANKS for your HELP!

Re: Determine which subsite called form?

Hilary Stoupa — Fri, 21 Nov 2014 16:28:47 GMT

Pop your form over to me via email again and I'll take a look at your logic, okay?

Re: Determine which subsite called form?

klink — Fri, 21 Nov 2014 16:00:42 GMT

Sorry, I should have stated that better.

When I am changing the url, it is to a subsite, not a completely different site.

Re: Determine which subsite called form?

Hilary Stoupa — Fri, 21 Nov 2014 15:10:41 GMT

Well - the whole point here is that you'll be changing your GetList connection to the same site as the form is published to. So if you don't have an error as long as the URL is the same site as the form is published to, I'd guess you are good without UDCX.

If I were testing this, I would set up the logic to change the GetList connection to the same site as the form is published to, and try publishing the form to a different site - isn't that the original problem you are trying to solve?

Re: Determine which subsite called form?

klink — Fri, 21 Nov 2014 15:03:56 GMT

Not in Office 365, but am in a claims-based site. Developer decided to take off for 3 days, so I can't see what the errors are until Monday. =(

I have made two data connections for GetList.

GetList
GetListUDC (that has been converted to a udcx file)

GetList

If I do a ChangeConnectionUrl to the same site as the original GetList settings, and then query GetList, it works.
If I do a ChangeConnectionUrl to a site different from the original, and then query GetList, I get an error.

GetListUDC

If I do a ChangeConnectionUrl to the same site as the original GetListUDC settings, I get an error.
If I do a ChangeConnectionUrl to a site different from the original, and then query GetListUDC, I get an error.

No errors are showing up in Qdabra's "Error" field in any instance.

I've had to jump through hoops before because of a claims-based site, so this may be part of the problem. What I need to know is:

Does ChangeConnectionUrl for GetList work if the data connection has been converted to .udcx? If so, I will continue down this road. If not, I will stop!

THANKS!

Re: Determine which subsite called form?

Hilary Stoupa — Thu, 20 Nov 2014 20:00:26 GMT

What is going wrong in the browser? Is it a data connection error? You aren't using Office 365, are you (sorry, should have asked that right at the start)?

Re: Determine which subsite called form?

klink — Thu, 20 Nov 2014 16:04:56 GMT

ARGH!!! This works GREAT from my desktop, but NOT when I publish.

So, will this still work if I convert GetList to udcx file?

Re: Determine which subsite called form?

klink — Thu, 20 Nov 2014 13:21:45 GMT

LOL! Thought of that in the middle of the night! Trying this morning.

Re: Determine which subsite called form?

Hilary Stoupa — Wed, 19 Nov 2014 22:17:29 GMT

Well - remember, the URL to the lists service is http://server/site/_vti_bin/lists.asmx. So, if you set it http://server/site it is going to fail. You'll need to concat in the rest of the URL.