Qdabra qRules

Re: Help constructing SortTable syntax

Hilary Stoupa — Wed, 02 Feb 2011 17:28:19 GMT

Ah, sorry! I didn't see the space when I pasted my sample in. I've fixed it so that it is correct now.

Re: Help constructing SortTable syntax

Marzipan — Wed, 02 Feb 2011 12:27:55 GMT

I was getting the error with the full command line, I was trying to test the dll alone. It seems it was a space after List= that was the issue. Syntax is kinda a pain. Works now.

Re: Help constructing SortTable syntax

Hilary Stoupa — Tue, 01 Feb 2011 19:56:18 GMT

Hi -- that link is incomplete -- you need to have the List GUID, and a few other parameters. The URL should look something like:

http://server/_vti_bin/owssvr.dll?Cmd=Display&List={1CC3F2DD-4251-4A98-9BC9-E584496C0727}&XMLDATA=TRUE

With your server URL and your List GUID. Please refer to page 2, item C, bullet 2 in the document Ernesto referred you to for additional info. Item B explains how to get the correct GUID.

Re: Help constructing SortTable syntax

Marzipan — Tue, 01 Feb 2011 19:52:12 GMT

I'm getting and error when I go to the Owssvr.dll

http://hscsbidev2:1105/_vti_bin/owssvr.dll

"cannot complete this action"

Can I use FilterOwssvr against the Secondary data source after the sorttable?

Re: Help constructing SortTable syntax

ErnestoM — Tue, 01 Feb 2011 18:00:05 GMT

You can filter a SharePoint list on the server using qRules (read more here). CopyTable cannot filter when copying, unfortunately.

Re: Help constructing SortTable syntax

Marzipan — Tue, 01 Feb 2011 17:51:53 GMT

That worked. Other than I need to change the order to ASC.

This is a browser form. I'd love to be able to find a way to filter this dropdown list to only those whose Content_type = "Person" and Name contains "*HS"

I can do this using a caml query and the U2U tool. Sample .caml file appended. (remove the .txt).

Can I copy only some items from this data source to another? I don't see that copytable has that option.

Most of the people using this from are "techies" so it is not critical, however, I would like to be able to limit the dropdown list.

any suggestions?

Re: Help constructing SortTable syntax

ErnestoM — Tue, 01 Feb 2011 17:30:18 GMT

Because you are sorting the data in a secondary data source, you'll need to add one more parameter. The dsname parameter is optional and only needs to be declared if it is not the Main DOM. So your command becomes:

SortTable /dsname=User Information List /row=/dfs:myFields/dfs:dataFields/dfs:User_Information_List /compare=@Name /order=DESC

Can you please try adding that parameter? Thanks!

Re: Help constructing SortTable syntax

Marzipan — Tue, 01 Feb 2011 17:08:30 GMT

I am getting the following error in qrules: An error has occurred executing the rule. Failed to select the table to sort.

I have included a sample form

Re: Help constructing SortTable syntax

Marzipan — Thu, 27 Jan 2011 19:41:11 GMT

Ernesto,

Thanks,

The code did not error out in my form. (good news). I won't know if it really worked until I publish it to SP and run it from the server since that is the condition in with the User Information List does not sort when loaded as a data source. I will let you know.

Marlene

Re: Help constructing SortTable syntax

ErnestoM — Thu, 27 Jan 2011 15:15:47 GMT

I'll assume that dfs:User_Information_List is the repeating field, but let me know if this is not correct.

SortTable /row=/dfs:myFields/dfs:dataFields/dfs:User_Information_List /compare=@Name /order=DESC

Can you try that?

Thanks.

Help constructing SortTable syntax

Marzipan — Thu, 27 Jan 2011 14:10:56 GMT

I need help fomulating the SortTable command.

It is a secondary data source.

Here is the XPATH of the field I want to sort on.

/dfs:myFields/dfs:dataFields/dfs:User_Information_List/@Name