How To: Set parametric WHERE clause for SAP Connector in a BOARD Procedure

Document created by mik1893 Employee on Jul 14, 2017Last modified by ggallo on Jul 14, 2017
Version 2Show Document
  • View in full screen mode

WHERE Clauses can be included in the SAP Query.

This implies the edit of the SAP Connector Query as the WHERE condition changes. A different and flexible approach can be taken in case a parametric WHERE clause based on specific user / dataloading conditions is required. 

1) While editing the "Where" Clause of the SAP Query, identify the SAP Table Field as a Parameter with the following syntax sap_table_field_name=@parameter_name

 

2) Test the clause, running the query in the web-browser with some expected "where" items (e.g. Country ='IT').

 

3) Use the parameter option in the SAP Data Read Procedure Command Row.

 

 The Syntax is @parameter_name=item_code.
 Multiple parameters can be used to create a range of values or concatenate different conditions as in a typical SQL Where statement like :

The Syntax in then @parameter_name_1=item_1_code&@parameter_name_2=item_2_code ; sample give is @StartDate=20170101&@EndDate=20171231 that takes all the recs of Year=2017.

The benefit of such approach is that you can re-use the same Query as many time as you like customzing your where clause in the Procedure Design Environment.

 

 Notes:

  • the "&" simble has no other meaning rather than identifing multiple parameters in the string. "AND", "OR" or any other logic condition must be edit in the SAP Connector Query Design Panel.
  • it is possible to list mutliple items for a single parameter using the "," like separators (e.g. @Country=IT,DE,UK)
4 people found this helpful

Attachments

    Outcomes