InfoPath 2010

Re: Dynamically filter a stored procedure

jaxkookie — Thu, 20 Oct 2011 12:47:29 GMT

Thanks Jimmy,

I kinda figured that by the end of the day yesterday. What about filtering the results. I am tring to build cascading dropdowns from an SQL data source. If I cant add form field values in my stored procedure, is there a way to add a rule to filter the returned results, just like you would on other secondary data sources?

Re: Dynamically filter a stored procedure

Jimmy — Thu, 20 Oct 2011 05:27:45 GMT

Hello JaxKookie,

I don't believe InfoPath has a built-in way to dynamically include form field values in stored procedure queries. It is something people are often looking to do, and that's why we added the ExecuteSqlQuery command to qRules. I recommend having a look.

Dynamically filter a stored procedure

jaxkookie — Wed, 19 Oct 2011 15:39:39 GMT

I am using a SQL db for my data source. I have several stored procedures to populate my dropdowns. My first ddl is for regions, and it works perfectly. no filter and it pulls down all the regions to populate the field. I want to use the value of this field to filter my next stored procedure. But I can't get it to work. If I hard code the region value in my exec statement, it filters perfectly.

EXEC Get_CPMSupportData_VendorbyRegion 'Southeast'

Maybe I am missing the correct syntax.

I tried this:

EXEC Get_CPMSupportData_VendorbyRegion @Region

EXEC Get_CPMSupportData_VendorbyRegion /my:Region.value

but neither one works. Any help or suggestion would be greatly appreciated.