Hi all,
I tried to use udc connection file type="XmlQuery" along with owssvr.dll so that I can filter data returned from the sharepoint list.
However, it always complains "specifies a connection of type XmlQuery. Expected type was SharePointList." when I test the form in preview.
I've listed my udcx file below, please have a look if there is any syntax errors or what cause this. It would be good if someone can provide an example of how to use <udc:Query> tag along with <udc:Type Type="XmlQuery">. Thanks a lot
<?xml
version="1.0" encoding="UTF-8" ?>
<?MicrosoftWindowsSharePointServices
ContentTypeID="0x010100B4CBD48E029A4ad8B62CB0E41868F2B0"?>
- <udc:DataSource MajorVersion="2"
MinorVersion="0" xmlns:udc="http://schemas.microsoft.com/office/infopath/2006/udc">
<udc:Name>Regions</udc:Name>
<udc:Description>Format: UDC V2; Connection Type: XmlQuery;
Purpose: ReadOnly;</udc:Description>
- <udc:Type MajorVersion="2"
MinorVersion="0" Type="XmlQuery">
<udc:SubType MajorVersion="0" MinorVersion="0" Type="" />
</udc:Type>
- <udc:ConnectionInfo Purpose="ReadOnly"
AltDataSource="">
<udc:ServiceUrl UseFormsServiceProxy="false" />
<udc:Query>https://myserver/_vti_bin/owssvr.dll?Cmd=Display&List={0D0FB7E3-C63D-41B3-BFE3-F24163BB9556}&XMLDATA=TRUE&noredirect=true&FilterField1=Category&FilterValue1=All</udc:Query>
</udc:SelectCommand>
<udc:ServiceUrl UseFormsServiceProxy="false" />
<udc:FileName>Specify a filename or formula</udc:FileName>
<udc:FolderName AllowOverwrite="" />
</udc:UpdateCommand>
</udc:ConnectionInfo>
</udc:DataSource>