Hi Howard,
I got one more solution but the problem is here when I am clicking.
http://localhost:8080/services it is giving
Dadobe.workflow.service.test.enabled=true
step are as follows
1st workflow just a SQL Q-PAC that performs the query and returns the results to a process variable.
- 2nd workflow the main workflow. This will be executed when the user clicks the Submit button on the form via Form Manager.
Here are the high level steps:
Create a workflow with 1 SQL Q-PAC to query the database and return the results. Ive attached a document I put together a while back describing how to use the SQL Q-PAC. Its unsupported documentation, but has worked for people trying to use it. Make sure the workflow is web server enabled via the Workflow properties and any necessary in and out variables that are required for the webservice are created for the workflow.
Save and Deploy this workflow.
Retrieve the WSDL address for this web service. There is an unsupported feature if you go to
http://servername:8080/services, you can click the WSDL link for that workflow and copy it from the URL bar.
Open the form in Designer (form Designer) that contains the drop down list.
Click the Data View tab and select File > New Data Connection.
Click the WSDL File radio button and click Next.
Paste the address copied above into the WSDL File field and click Next.
Select the synchronoushInvoke option (unless you created the workflow to be asynchronous, the click invoke), but workflows are synchronous by default.
Click Finish.
Click on the field that should receive the results of the query and click the Binding tab on the Object palette.
Map the result of the web service to the drop down list field by using the Import/Export Bindings option on this tab to the variable designated as the out variable. (I included a screen shot to show this tab).
Map the request parameter to the variable designated as the in variable.
Add the web services execute button somewhere on the form. You can make this invisible by click on the button after youve dragged it on the form and setting the Presence to Hidden on the Field tab of the Object palette. (I attached a screen shot of this palette as well.)
Add script to click the execute button when the form is opened. This will execute the web service. For example, click on the root node of the form from the Hierarchy and select the docReady event from the Show drop down list of the Script Editor. Then, add the following script (Ive included a screen shot of this as well:
synchronousInvokeBtn.execEvent(click);
Save the form and re-publish it to Form Manager.
Create the main workflow.