General

Re: infopath query specific sharepoint list data programmatically

Hilary Stoupa — Tue, 06 Feb 2018 16:05:20 GMT

How odd. I would think as long as it is indexed, you'd be able to query on it.

Re: infopath query specific sharepoint list data programmatically

Richter Belmont — Tue, 06 Feb 2018 10:00:37 GMT

Yes, ORG is the renamed Title field.

Re: infopath query specific sharepoint list data programmatically

Hilary Stoupa — Mon, 05 Feb 2018 17:46:31 GMT

That would indicate that the title field isn't indexed. Is it? I see in your screenshot that "ORG" is indexed, I was assuming that was a renamed Title field...

Re: infopath query specific sharepoint list data programmatically

Richter Belmont — Mon, 05 Feb 2018 12:57:55 GMT

Unsure what happens but it works now when i commented out the setting of the "Title" field. //bomDS.SelectSingleNode("/dfs:myFields/dfs:queryFields/q:SharePointListItem_RW/q:Title", NamespaceManager).SetValue(org); bomDS.SelectSingleNode("/dfs:myFields/dfs:queryFields/q:SharePointListItem_RW/q:AssemblyItemNumber", NamespaceManager).SetValue(assyItemNum);

Re: infopath query specific sharepoint list data programmatically

Richter Belmont — Mon, 05 Feb 2018 06:16:12 GMT

No threshold issue in the default view, its folderize. 5k each folder.

Re: infopath query specific sharepoint list data programmatically

Hilary Stoupa — Fri, 02 Feb 2018 16:04:08 GMT

Interesting - I'd expect that having indexes added would resolve the issue... what about the default view for the list? Is it under the threshold?

Re: infopath query specific sharepoint list data programmatically

Richter Belmont — Thu, 01 Feb 2018 08:18:25 GMT

indexes

Re: infopath query specific sharepoint list data programmatically

Richter Belmont — Thu, 01 Feb 2018 08:00:55 GMT

Hilary Stoupa:
Under the List Settings, scroll down till you are beneath all the columns - there should be links there for the pages for adding indexes.

Unsure what to do but im still getting the issue list threshold. :( i already added the two column to indexes i get the error when it goes to spConn2.execute

Re: infopath query specific sharepoint list data programmatically

Hilary Stoupa — Wed, 24 Jan 2018 15:44:56 GMT

Under the List Settings, scroll down till you are beneath all the columns - there should be links there for the pages for adding indexes.

Re: infopath query specific sharepoint list data programmatically

Richter Belmont — Wed, 24 Jan 2018 12:10:58 GMT

How to add indexes to the column, im using O365 sharepoint? Thank you

Re: infopath query specific sharepoint list data programmatically

Hilary Stoupa — Fri, 29 Sep 2017 14:40:18 GMT

Hi - sorry I missed this last week. If you are getting an error based on the list threshold, usually adding indexes to the columns you are likely to query on will resolve that issue.

infopath query specific sharepoint list data programmatically

Richter Belmont — Thu, 21 Sep 2017 16:18:02 GMT

Hi, Is it possible to perform query to the query fields of secondary datasource? I have a list of 10K rows and i throws an error (The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator) something like this, but this one doesnt work

xIter = bomDS.Select("/dfs:myFields/dfs:dataFields/q:SharePointListItem_RW[q:AssemblyItemNumber = '" + assyItemNum + "']", NamespaceManager);

bomDS = DataSources["BOM"].CreateNavigator().SelectSingleNode("/dfs:myFields/dfs:dataFields/q:SharePointListItem_RW[q:Title = '" + c_ItemNumber + "']", NamespaceManager);

spConn = this.DataConnections["BOM"];

spConn.Execute();