User Input Filtering Options

[oakridge]

What are the methods allowed to give the user capability to enter a
paramerter to filter data in a repeating table?

 

[oakridge]

I am using SQL as the database for this project. Do I add an additonal field
into that database for this inquiry? Further, I would like for the query to
reflect a data range. Is this possible?

 

[oakridge]

Thanks. I have been able to get the date range to work.

Ann

You can use a secondary data source. It doesn't need to be in the database.

For a date range, you'll need to allow for two dates and have appropriate validation on them to make sure they meet your criteria. Then use of those in your custom query code (you have to write your own code to create the query and execute it). Use the dates like you would in any SQL query... checking if date1 >= myate1 and date2 <= myate2 (or whatever).

--
Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com



I am using SQL as the database for this project. Do I add an additonal field
into that database for this inquiry? Further, I would like for the query to
reflect a data range. Is this possible?

Create a text box for the user to type into, then filter the repeating table based on the value of that text box.

--
Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com



What are the methods allowed to give the user capability to enter a
paramerter to filter data in a repeating table?