Run external stored procedure using a date parameter and show results
Confluence User - 18 Sep, 2024
I need a page that I set a date in a text input then click on a button that runs a Sql Server stored procedure to external database with this date as parameter. The SP returns a list of one column data. Then this data must be shown with some way (datalist?). Also you should be able to take row based action with hyperlink button that calls URL with url parameter the returned row data. If I use datalist I can figure out the creation of the hyperlink based on the data column (using hyperlink action) but there is not an obvious way to use a date search input box and a button that uses this input date as a parameter to the srored procedure, execute the SP, and then use the returned data to fill out the datalist.
datalists;databinder;database
