Web Services

Re: Show Data in alphabetical order

Shilpashree D.N — Thu, 08 Jul 2010 04:46:24 GMT

Remove the Data connection and try recreating

Re: Show Data in alphabetical order

Hilary Stoupa — Thu, 08 Jul 2010 00:28:18 GMT

This looks like a UDC file? Who wrote the code for the actual web service: http://######/AbilityClientList/service1.asmx, and it looks like the GetClients method?

Basically, InfoPath doesn't offer a way to sort a data source. qRules does, tho.... as well as a lot of other things that IP doesn't natively support.

Re: Show Data in alphabetical order

MarsdeNation — Wed, 07 Jul 2010 23:49:11 GMT

Hi Hilary,

If this is my Web Service Code, how do I do the "Ordered By" Command?

<?xml version="1.0"?><?MicrosoftWindowsSharePointServices ContentTypeID="#####"?><udc:DataSource MajorVersion="2" MinorVersion="0" xmlns:udc="http://schemas.microsoft.com/office/infopath/2006/udc">
    <udc:Name>GetAbilityClients</udc:Name>
    <udc:Description>Format: UDC V2; Connection Type: WebService; Purpose: ReadOnly; Generated by Microsoft Office InfoPath 2007 on 2008-06-26 at 15:33:57 by #####.</udc:Description>
    <udc:Type MajorVersion="2" MinorVersion="0" Type="WebService">
        <udc:SubType MajorVersion="0" MinorVersion="0" Type=""/>
    </udc:Type>
    <udc:ConnectionInfo Purpose="ReadOnly" AltDataSource="">
        <udc:WsdlUrl>http://######/AbilityClientList/service1.asmx?WSDL</udc:WsdlUrl>
        <udc:SelectCommand>
            <udc:ListId/>
            <udc:WebUrl/>
            <udc:ConnectionString/>
            <udc:ServiceUrl UseFormsServiceProxy="false">http://#####/AbilityClientList/service1.asmx</udc:ServiceUrl>
            <udc:SoapAction>http://tempuri.org/GetClients</udc:SoapAction>
            <udc:Query/>
        </udc:SelectCommand>
        <udc:UpdateCommand>
            <udc:ServiceUrl UseFormsServiceProxy="false"/>
            <udc:SoapAction/>
            <udc:Submit/>
            <udc:FileName>Specify a filename or formula</udc:FileName>
            <udc:FolderName AllowOverwrite=""/>
        </udc:UpdateCommand>
        
    </udc:ConnectionInfo>
</udc:DataSource>

Thanks in advance

Re: Show Data in alphabetical order

Hilary Stoupa — Wed, 07 Jul 2010 23:31:20 GMT

I think the initial response was for a SQL query. Since you are querying a web service, you'll need to modify your web service to return items in the order you want. Can you add an "Order By" clause to the SQL in your web service?

Re: Show Data in alphabetical order

MarsdeNation — Wed, 07 Jul 2010 21:59:18 GMT

Hey thanks,

I can't find the modify SQL button that you mention.

I go to tools/Data Connections, I modify my data connections, choose my web service, click next twice but I see no Edit SQL button.

Am I missing something?

Re: Show Data in alphabetical order

Shilpashree D.N — Wed, 07 Jul 2010 13:17:52 GMT

Modify the data connection query string to return a sorted list. I mean Modify the data connection..Open Data Connection
go to the data connection wizard where your table is selected and the field are displayed with checks.Look on the lower right and use the edit SQL..button.
Add an "Order By Name" or whatever the field name is and that will alphabetize a-z....

Show Data in alphabetical order

MarsdeNation — Wed, 07 Jul 2010 02:36:22 GMT

Hi Everyone,

I have a simple web service that looks up a table with a single column on a SQL Database, and puts the data into a drop down list box in my browser enabled form.

The data is basically a bunch of names in random order, and I want to display them in alphabetical order in the drop down list box.

Can someone help me do this please?

Thanks in advance.