CAML in udcx ?

changchang500 — Thu, 22 Dec 2011 01:19:58 GMT

Hi All,

I have a data connection in my infopath form which is based on a udcx file on the sharepoint site. It works fine.
However, I don't want to retrieve all items from the list specified in the udcx file. Is it possible to insert any query (maybe CAML) into the udcx file so that it only returns what I want ?
I've attached the udcx file below, maybe I can insert some queries into <udc:query> tag ?

Thanks & Regards

<udc:ConnectionInfo Purpose="ReadOnly" AltDataSource="">

<udc:WsdlUrl />

- <udc:SelectCommand>

<udc:ListId>{0F0FB1E3-D63D-81B3-B1E3-F23163DB9559}</udc:ListId>

<udc:WebUrl>https://mywebsite</udc:WebUrl>

<udc:ConnectionString />

<udc:ServiceUrl UseFormsServiceProxy="false" />

<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>

Data Connections

CAML in udcx ?