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:ListId>{0F0FB1E3-D63D-81B3-B1E3-F23163DB9559}</udc:ListId>
<udc:WebUrl>https://mywebsite</udc:WebUrl>
<udc:ServiceUrl UseFormsServiceProxy="false" />
</udc:SelectCommand>
<udc:ServiceUrl UseFormsServiceProxy="false" />
<udc:FileName>Specify a filename or formula</udc:FileName>
<udc:FolderName AllowOverwrite="" /></udc:UpdateCommand>
</udc:ConnectionInfo>
</udc:DataSource>