Wiki

Scale Your Enterprise

User Tools

Site Tools

Trace: • Control Types • Control Settings • Trigger Configuration for Versago Multi-Select Report Processing • Using APP Report Maintenance and Delivery • Custom Stored Procedures • Workflow Schedules Version 2.5 and after • downloads • Versago Archive • Credit Card Processing (CC) Installation • Invoking a Bizweaver Workflow Using POST
bw:bizweaver_multiselect_trigger

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision 		Previous revision
bw:bizweaver_multiselect_trigger [2019/12/13 11:31]
runger created 		bw:bizweaver_multiselect_trigger [2020/04/28 15:23] (current)
runger
Line 1: Line 1:
 ======Trigger Configuration for Versago Multi-Select Report Processing====== ======Trigger Configuration for Versago Multi-Select Report Processing======
  
-<WRAP center round help 80%> +Create the trigger on the table where records are saved by your Versago multi-select report.
-A sample of the trigger code used in a VersagoData table is found **//[[bw:bizweaver_multiselect_trigger|here]]//**. +
-</WRAP> +
- +
-Create a trigger on the table where records are saved by your Versago multi-select report.+
  
 Values in <YourValue> are specific to your installation and need to be changed accordingly.  The < and > symbols are removed when the desired value is entered. Values in <YourValue> are specific to your installation and need to be changed accordingly.  The < and > symbols are removed when the desired value is entered.
Line 23: Line 19:
 EXECUTE [dbo].[spCallBizweaverWS] EXECUTE [dbo].[spCallBizweaverWS]
 @wsMethod='POST' @wsMethod='POST'
--- add your URL.  Be sure to use http or https as appropriate. +-- add your URL.  Be sure to use http:// or https:// as appropriate. 
-,@wsURL='https:<YourURL>' +,@wsURL='https://<YourURL>' 
-,@wsContent='application/json'+,@wsContent ='application/json'
 -- Add your Auth Token from Bizweaver -- Add your Auth Token from Bizweaver
-,@wsAuthToken='<YourBizweaverToken>'+,@wsAuthToken ='<YourBizweaverToken>'
 -- Add your workflow ID from Bizweaver -- Add your workflow ID from Bizweaver
-,@wsTaskId='<YourWorkflowID>' +,@wsTaskId = <YourWorkflowID> 
-,@wsStartAfter='' +,@wsStartAfter = 0 
-,@wsParameters= @Arguments+,@wsParameters = @Arguments
 -- Add your port number -- Add your port number
-,@wsPort='<YourPort>'+,@wsPort = <YourPort>
 END END
 </code> </code>
 +
 +If your are calling Bizweaver without any parameters the @Arguments value will look like this:
 +
 +SET @Arguments = '{}'
 +
 +<WRAP center round tip 80%>
 +Be aware that when you call Bizweaver using this method the target table of the Versago multi-select report is locked until the workflow completes.  This means that to get records for processing you will need to use the "with (NOLOCK)" modifier in any SELECT statement that reads the target table.  It also means that you cannot write directly back to the target table if needed.  In this case you may need to write the results from the processing to another table that can be linked to the original target table for reporting purposed.
 +</WRAP>
 +
 +
 +----
 +
  
 The following video illustrates this process. The following video illustrates this process.
bw/bizweaver_multiselect_trigger.1576254685.txt.gz · Last modified: 2019/12/13 11:31 by runger

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial 4.0 International
CC Attribution-Noncommercial 4.0 International Valid HTML5 Valid CSS Driven by DokuWiki