Data Connections

Re: retrieve data from sharepoint lib list

Anson Hidajat — Fri, 16 Mar 2012 16:50:40 GMT

It depends on what kind of data connection you are using. For example, the list data connection in 2010 has support for query fields so you can filter you data that way. Web service connections can be set up to allow querying as well.

Re: retrieve data from sharepoint lib list

nymphsuitor — Fri, 16 Mar 2012 04:39:38 GMT

Thanks broda, I got it. We only can manage display data, hide or not. actually we can not filter the retrieving data, right? Or we can filter the data using code?

Re: retrieve data from sharepoint lib list

Anson Hidajat — Fri, 16 Mar 2012 04:31:36 GMT

The filter option is located in the control properties -> Display Tab -> Filter Data

Re: retrieve data from sharepoint lib list

nymphsuitor — Fri, 16 Mar 2012 04:15:30 GMT

i've already try to add filter but there is no available filter there. (in default setting, edit default value is disable)

Re: retrieve data from sharepoint lib list

Anson Hidajat — Thu, 15 Mar 2012 19:14:45 GMT

Hi there,

You can create a secondar data connection to your list/library and then drag the repeating node form that schema to your form as a repeating table. In the repeating table, you can either set up filters in the properties or conditional formatting to hide the rows based on the criteria you specified.

retrieve data from sharepoint lib list

nymphsuitor — Thu, 15 Mar 2012 03:32:42 GMT

Hi Everyone, Need your help. I want to retrieve data from sharepoint lib list and store them into repeating table. But i need filter those data which have column name modified, date data type. how can i filter the data? thanks in advise.