composeSQLStatement
public SQLComposer.SQLComposerInfo composeSQLStatement(java.lang.String sqlName,
java.lang.String entityTableName,
java.util.List resultSetInfo,
java.lang.String sqlstatement,
java.util.List params)
throws DataServiceSystemException
Compose the SQL statement to get the list of recurring orders/subscriptions. Based on the SubscriptionTypeCode passed, the appropriate SQL is composed. If the SubscriptionTypeCode is 'RecurringOrder', then compose the SQL with subscription type Id set to 'NONE' and 'Recurring' flag set to 1. If the SubscriptionTypeCode is 'All', then compose the SQL with subscription type Id set to the values from the 'subscptype' table except the value 'NONE'.
- Specified by:
- composeSQLStatement in class SQLComposer
- Parameters:
- sqlName - The name of the SQL statement specified in the query template
- entityTableName - The entity table name specified in the query template
- resultSetInfo - The current resultSet information, which is a list of ResultSetData. If there is no result set information, this will an empty list and the value will never be null.
- sqlstatement - The optional SQL statement specified in the query template. This could be null if there is no SQL statement specified in the query template
- params - A list of optional parameters of type String specified in the query template. If no parameters are specified, this would be an empty list and will never be null.
- Returns:
- A structure representing the updated SQL statement, its resultSet information.
- Throws:
- DataServiceSystemException