InfoPath Dev

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.

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.

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

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

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?

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.