This is the base SQL used for fetching records. This can be a simple SQL statement or complex SQL statement containing joins and sub queries.
Place holders (?) can be used in base SQL. For each place holder a corresponding batch attribute must be defined.
For Example:
If the base SQL is “Select Customer_Id from Customer where OpentityType=?” then an attribute must be defined as “EntityType” of type “Opentitytype” with data type as “Varchar”.
If the base SQL has more than one place holder then the attributes must be defined in the sequence with the sequence of the place holders, so that each place holder is replaced with respective defined attribute values sequentially. In this case, first placeholder will be replaced with first attribute value, second placeholder with second attribute value and so on.
Defining Base SQL:
Data Type: Numeric or Number or Varchar or Char
Value Type:
Single
“select CUSTOMERID from customer where CUSTOMERID = ?”
Discrete
“select CUSTOMERID from customer where CUSTOMERID in ( ? )”
Range
“select CUSTOMERID from customer where CUSTOMERID between ?”