1. UNIFYBroker Forum
  2. UNIFYBroker/Microsoft SharePoint
  3. Questions
0
Answered

Filter on SharePoint Connector

Matthew Woolnough 12 years ago in UNIFYBroker/Microsoft SharePoint • updated by anonymous 10 years ago • 5

Is it possible to filter out list items from a SharePoint list?

I want to use the EmployeeID in the DN, however it will not be populated initially, which means not all list items will have a value. This will result in errors being thrown & I'd like to avoid this.

If this is not already possible, can you advise on how long it would take to implement.

Adam van Vliet 12 years ago

This is already possible:
http://office.microsoft.com/en-au/sharepoint-designer-help/create-a-custom-list-view-using-sharepoint-designer-HA010379079.aspx
http://office.microsoft.com/en-au/sharepoint-server-help/create-modify-or-delete-a-view-HA010377693.aspx

Matthew Woolnough 12 years ago

OK, When specifying a viewName, is it still necessary to specify the listName (config below)? When I specify both I get the following error:

20130910,02:19:27,Change detection engine import all items failed.,Change detection engine,Warning,"Change detection engine import all items for connector SharePoint eMinerva Exceptions Connector failed with reason Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown.. Duration: 00:00:02.5059556
Error details:
System.Web.Services.Protocols.SoapException: Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown.
   at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   at Unify.Communicators.ListService.Lists.GetListItems(String listName, String viewName, XmlNode query, XmlNode viewFields, String rowLimit, XmlNode queryOptions, String webID)
   at Unify.Communicators.Moss2007ListWebServiceCommunicatorBase.<GetListItems>d__f.MoveNext()
   at Unify.Connectors.MossListConnector.<GetAllEntities>d__1a.MoveNext()
   at Unify.Framework.EnumerableExtensions.<ActionOnFirst>d__1c`1.MoveNext()
   at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
   at Unify.Framework.ActionOnExceptionEnumerator`1.MoveNext()
   at Unify.Framework.EnumerableExtensions.<ActionOnLast>d__16`1.MoveNext()
   at Unify.Framework.EnumerableExtensions.<ProduceAutoPages>d__9`1.MoveNext()
   at Unify.Framework.Visitor.ThreadsafeVisitorEvaluator`1.Visit()
   at Unify.Framework.Visitor.VisitEvaluateOnThreadPool[T](IEnumerable`1 visitCollection, Action`2 visitor, Int32 maxThreads)
   at Unify.Framework.RepositoryChangeDetectionWorkerBase.PerformChangeDetection(IEnumerable`1 connectorEntities)
   at Unify.Framework.ChangeDetectionImportAllJob.ImportAllChangeProcess()
   at Unify.Framework.ChangeDetectionImportAllJob.RunBase()
   at Unify.Framework.MutexJobDecorator.Run()
   at Unify.Framework.DefinedScopeJobAuditTrailJobDecorator.Run()
   at Unify.Framework.AsynchronousJobExecutor.PerformJobCallback(Object state)",Normal

		  <communicator
							ignoreCertificateError="True"
							pollingChangeTokenOffset="-1.00:00:00"
							credentials="Custom"
							proxy="Default"
							preauthenticate="true"
							timeout="02:00:00"
							proxyUri=""
							uri="http://kweb.bne.catholic.edu.au/informationservices/SSAS/SSA/"
							domain="CATHOLIC"	
							user="svc_FIM_SharePoint"
							securePassword="TE+bBSNefb5uHPQAhhSpsw==" certificate="" listName="eMinerva Exceptions" viewName="IdentityManagement" rowLimit="100">
			  </communicator>
Adam van Vliet 12 years ago

No, just the view name.

Shane Day (Chief Technology Officer) 12 years ago

This support issue has remained resolved for 2 weeks. Please check the status of the issue and close or readdress the issue if necessary.

Patrick Johannessen 11 years ago

Closing this issue as it has been resolved and is now inactive. If this issue has not been resolved, please reopen or log a new issue accordingly.

Customer support service by UserEcho