Data Connections

Re: Filter Data Received from SQL Data Connection

WSU54 — Mon, 15 Sep 2008 20:50:26 GMT

Thanks for the quick reply.

OK, so I have this working. Data connection to SQL, pull down menu that filters on what the user types in a text box.

One issue...

Filtering is not supported in browser-based forms, only the full InfoPath client.

Is there a way to do this with browser-based forms that anyone in this forum has run across?

Thanks!

Re: Filter Data Received from SQL Data Connection

Hilary Stoupa — Thu, 11 Sep 2008 14:37:43 GMT

Hi --

Are you looking to filter the data before it is returned to your form? Or do you return all the data to your form and you only want to be able to filter the items shown to the user?

If you are looking to filter the data before it is returned to your form, you'll either need to modify the query before it is run using code, or use a web service such as our Database Accelerator product that will allow you to create a dynamic query using rules.

If you have already returned all 1000 names to the form (and you aren't finding it a performance hit) you can use a filter on your table. You'll need to add a field to your form to allow your user to enter (or select) the leter they are looking for, and then, in your table, under Properties, selec the Display tab, and filter the data to display the rows where the name begins with the letter entered in the field. Let me know if you need more detail, okay?

Filter Data Received from SQL Data Connection

WSU54 — Thu, 11 Sep 2008 13:01:15 GMT

I have been working with InfoPath for a while now, but have yet to run into this situation.

I have a user directory form that will connect to an SQL database and return the results of a table which contains user names. I want to return that list of user names to my form, however I need to incorporate some way to filter them alphabetically. So that if I have 1000 names in the table, end users can filter down to just those where the last name starts with "A", or "M", etc.

I would like to do this with no code, if possible, as I am not a developer.

Thanks for your help in advance!