General

Re: how to create a wild card parameterized query for a dropdown control?

ryangibbonshr — Thu, 24 Jan 2013 21:40:27 GMT

@JAxkooki-- I'm looking to do something similar. I have an employee status change form I created where you can search for the employee you're looking for through search fields (screen shot below). Any recommendations you can make on building in the ability to throw a wildcard in would be helpful (i.e., if you're searching by Manager Last Name = Gregg, typing in Gre* and getting anyone in the table whose last name starts with Gre). Thanks!

Re: how to create a wild card parameterized query for a dropdown control?

william2 — Fri, 10 Feb 2012 07:16:18 GMT

yes. I have read this link before. Now the problem becoms how I can invoke the stored procedure and save the returned result into an xml file. Then the rest part is set. By the way, I am wondering if there is a simpler way to set up a parameteriized query directly for the dropdown list control.Thanks in advance for you advice! --- William

Re: how to create a wild card parameterized query for a dropdown control?

jaxkookie — Thu, 09 Feb 2012 14:25:30 GMT

funny you should ask. I struggled with this at first but was able to figure it out using this post.

http://www.bizsupportonline.net/infopath2007/programmatically-fill-populate-drop-down-list-box-infopath-2007.htm

This is a good writter for InfoPath solutions. Start with this and if you still cant get it I will post my updated code from the post that my help you.

Re: how to create a wild card parameterized query for a dropdown control?

william2 — Thu, 09 Feb 2012 08:47:53 GMT

Thanks for your advice. I have created the stored procedure. Then how can I populate the dropdown list with the returned dataset?

Re: how to create a wild card parameterized query for a dropdown control?

Test123 — Thu, 02 Feb 2012 16:45:23 GMT

I have a similar question, one of my drop down field look up from a sharepoint custom list column, i have 500 values in that column, so i want to enter search in the dropdown field, how can i do that? thanks in advance.

Re: how to create a wild card parameterized query for a dropdown control?

jaxkookie — Thu, 02 Feb 2012 16:39:53 GMT

If you already in SQL Server why not write a stored procedure to manage your query. Then you can return partial matches, and return values for all the other fields you want populated. If this is not an option You may need 2 fields to make this work, one for the search (wild card) and one for the results. the results will filter results based on your value in the search, but instead of equals you will use contains. Then apply rules to populate other form fields

how to create a wild card parameterized query for a dropdown control?

william2 — Thu, 02 Feb 2012 08:39:01 GMT

Hello all,

I have a a dropdown list control bound to the main data source in a SQL server. I would like to make the wild card query to the table by Supplier Name say Abc* and then pick only one record from the result set. In addition, the other fields in the form will be updated based on the record selected at the previous step. How can I do this? I am new to the Infopath. Thanks in advance.