Data Connections

Re: adding sorting column info in data connection file

rajkumar.bathula — Wed, 13 Nov 2013 18:25:35 GMT

Thank u. I understood ur approach. i will give a try. I have the working copy i.e., design file of the form :)

Re: adding sorting column info in data connection file

Hilary Stoupa — Wed, 13 Nov 2013 15:32:33 GMT

Make a backup copy of your form. Save your form as source files (Publish > Export as source files). Open manifest.xsf in a text editor - find and modify the UDCX location. Are you telling me you currently don't have a working copy of the template because the UDCX files were moved?

Re: adding sorting column info in data connection file

rajkumar.bathula — Wed, 13 Nov 2013 14:49:18 GMT

Thank you hilary. I cant do your suggested steps in the design mode. Because the server nor site collection (where earlier dc files are stored) is no more exists. Hence, when i try to click on modify, it is trying to connect to the old site collection where my udcx files are stored and throwing message saying, site not found. Which is expected behavior.

Re: adding sorting column info in data connection file

Hilary Stoupa — Wed, 13 Nov 2013 14:37:54 GMT

Open the template in design mode. Open the data connections dialog. Select the data connection you need to modify. Click the Modify button. Walk through the dialogs for the data connection - on the dialog where you select the fields returned by the data connection, you should also be able to indicate the sort field.

Re: adding sorting column info in data connection file

rajkumar.bathula — Wed, 13 Nov 2013 12:41:41 GMT

Hi Hilary, thanks for prompt response. Dev environment in the scenes, the sp server on which the form was actually designed. If that would be there, i can easily modify the dataconnection and select my required column for sorting. Let me try modifying the manifest file and if it works, all good :) thank you once again.

Re: adding sorting column info in data connection file

Hilary Stoupa — Wed, 13 Nov 2013 02:28:21 GMT

I don't believe the sort column info is stored in the UDCX - I think it is in the data connection information in the manifest for the template. You should be able to just open the form in design mode and walk through the data connection again - not sure what you mean by dev environment here - do you have InfoPath designer installed?

adding sorting column info in data connection file

rajkumar.bathula — Tue, 12 Nov 2013 20:21:35 GMT

Hi Is there a way to specify sort column name in a data connection file? I have a browser based 2010 form where referring a udcx file. Now I dont hav dev environment to modify data connection file n specify my new sort column. Hence I am looking for udcx file modification as solution. I saw there is query, viewfields elements. But with empty even I am using few columns frm that data connection. My earlier udcx file was created by considering ID as sort column. Now I want to change to another column. Looking forward for ur valuable ideas. THANKS Raj