Data Connections

Re: Data connection sorting not being applied.

Patrick Halstead — Sun, 01 Sep 2013 22:12:09 GMT

Hi Jesse,

Yes, and Jimmy can help you with this when he meets with you on Tuesday.

Thanks for your patience!

Re: Data connection sorting not being applied.

jbrandenburg — Tue, 27 Aug 2013 18:50:40 GMT

I found 2 xsl files (upgrade.xsl, view1.xsl). I am not sure which one to modify. I want to add this in somewhere (I think): <xsl:template match="my:CustomerData" mode="xd:preserve">
   <div>
   <xsl:sort select="CustomerName"/>
      The value of Customer Name is <xsl:value-of select="CustomerName"/>
   </div>
</xsl:template>

I am also seeing 'copy-of' values that I do not know how to handle. Am I headed in the right direction?

Thanks again,

Jesse

Re: Data connection sorting not being applied.

Patrick Halstead — Sun, 25 Aug 2013 23:35:52 GMT

Yes, go to File->Publish->Export Source Files and create a folder and click OK. Close InfoPath Designer and go to that folder. Open your XSL file in Notepad. Find out where you want to do the sort and add it. I believe we have examples from a long time ago that show how to do this. You may need to use xdPreserve to make sure it roundtrips.

Re: Data connection sorting not being applied.

jbrandenburg — Mon, 19 Aug 2013 13:32:54 GMT

Is there anywhere that has a way to setup a custom xsl:sort? I would be interested in pursuing that further if possible. I do not see the ability to attach anything to a post, can you provide further direction?

Thank you for your response!

Jesse

Re: Data connection sorting not being applied.

Patrick Halstead — Mon, 19 Aug 2013 08:20:35 GMT

Hi Jesse,

I don't think you can fix how the cached values are sorted.

You may be able to use a custom xsl:sort in your view or qRules Sort command to fix this when opening from workspace.

Please attach your form and we'll take a look.

Data connection sorting not being applied.

jbrandenburg — Mon, 12 Aug 2013 19:44:29 GMT

I have setup a data source that works correctly in the browser-sorted by customer name descending. I have an issue when I try to create an item through SharePoint workspace (using the same form) it sorts the same data source by ID descending. I cannot figure out where to look to try to resolve this issue. Is there anyway to control the form behavior offline? Thanks, Jesse