Databases
StackOverflow2013
Postsdbo
POQuery External Content Type (External List) with using Data Source Filters - Sharepoint SOAP
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POQuery External Content Type (External List) with using Data Source Filters - Sharepoint SOAP
    text
    copied!<p>I connect sharepoint to sql server db. I made a list based on External Content Type. Because of <strong>amounth of data</strong> I had to add filter parameters during adding External Content Types Operations - on List. I add wildcard and limit filters with default values. I created list on External Content Type. I run default list web site. I didn't saw any data. So I edit web page and </p> <pre><code> &lt;Method Name="ExternalList"&gt; &lt;Filter Name="Filter" Value="A*"/&gt; &lt;Filter Name="Limit" Value="50"/&gt; &lt;/Method&gt; </code></pre> <p>In that way it works.</p> <p>I wrote in C# wpf application</p> <pre><code> server.Lists client = new server.Lists(); client.Url = string.Format("{0}/_vti_bin/Lists.asmx", FixUrl("http://server:port/sites/SiteCollecion/")); client.Credentials = System.Net.CredentialCache.DefaultCredentials; try { string xmlQueryContent = @"&lt;Query xmlns=""http://schemas.microsoft.com/sharepoint/soap/""&gt;&lt;/Query&gt;"; XmlDocument docQuery = new XmlDocument(); docQuery.LoadXml(xmlQueryContent.ToString()); XmlNode QueryNode = docQuery.DocumentElement; string xmlQueryOptionsContent = @"&lt;QueryOptions&gt;&lt;/QueryOptions&gt;"; XmlDocument docQueryOptions = new XmlDocument(); docQueryOptions.LoadXml(xmlQueryOptionsContent.ToString()); XmlNode QueryOptionsNode = docQueryOptions.DocumentElement; XmlNode clientsNode = client.GetListItems("ExternalList", null, QueryNode, null, null, null, null); DataSet clientsListsDataSet = new DataSet(); XmlReader clientsReader = new XmlNodeReader(clientsNode); XmlReadMode oko = clientsListsDataSet.ReadXml(clientsReader); Console.WriteLine(clientsNode.InnerText); Console.WriteLine(clientsNode.InnerXml); } </code></pre> <p>I got 0 rows results. So the filters were not populated. Is it possible to set them up i C# application?</p> <p>Connection works fine because I got results when I connect to not external list.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload