Data Connections

Re: Sort data connections

Shiva — Tue, 16 Dec 2008 07:28:10 GMT

Hello,

Here is the link related to sort,

http://www.infopathdev.com/forums/t/4733.aspx

Re: Sort data connections

cali_kid — Mon, 15 Dec 2008 16:48:21 GMT

Is there any way to sort a secondary data source in Browser Enabled form? I have a form with mulitple views, and in order to create a preserve code block I have to go and edit all XSL sheets that correspond that form. I'm populating a dropdown menu from a SharePoint List, in the thick client (Info Path) the form appears and renders the sort order that is being used from my SharePoint view. I've have created a preserve code block, but that feature is not supported in a browser enabled form.

Re: Sort data connections

Patrick Halstead — Thu, 09 Aug 2007 16:27:06 GMT

Hi Shaun,

Great question. There is sorting functionality for XML included in the Asset Tracking sample that ships with InfoPath 2003 (open in Designer, File->Save as Source, search for sort in the script.js file). It shows how to sort XML child nodes using an index and then rebuild the XML in one full swoop. Assuming you do that OnLoad the secondary data source, which is just XML, will show sorted. You will likely need to create a separate XML DOM to stream the child nodes into using the sorted indexes. Unfortuantely, the Asset Tracking example is javascript, but you should be able to get the technique. .NET as the same quick sort function.

I'd be happy to help further on this, but see what you can make of the Asset Tracking code first.

Cheers!

Sort data connections

shaun.nieves — Tue, 07 Aug 2007 18:42:07 GMT

I'm trying to figure out how to sort a secondary data connection to a sharepoint list. I'm aware that the sort on the view dictates the sort in the connection but I've read in these forums it can be changed using code. I think I have to use addsort but am not sure on how it works. I've tried this but it's not working.

The node selected in the expression is a dropdown box filled by a secondary data source

            Dim expr As XPathExpression
            expr = thisXDocument.DOM.selectSingleNode("//my:myFields/my:ProcessInfo/my:FilterMaterial")
            expr.AddSort("FilterMaterial", XmlSortOrder.Ascending, XmlCaseOrder.None, "", XmlDataType.Text)
            MsgBox("test", MsgBoxStyle.Critical)

Any help in the right direction would be greatly appreciated. Thanks!