Answered

Filter on SharePoint Connector

11 years ago in UNIFYBroker/Microsoft SharePoint • updated by 9 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.

Vote

Replies 5
Oldest first
- Newest first
- Oldest first

11 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

11 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>

11 years ago

No, just the view name.

11 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.

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

Filter on SharePoint Connector

Votes left: 9/9

Topic stats