|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface SQLQueryLov
A representation of the model object 'SQL Query Lov'.
This interface represents a list of values that is based on a custom SQL expression. Each value is defined as a result of this query.
You can access this SQL expression through the getSQLExpression()
and setSQLExpression(String)
methods.
To instantiate a list of values based on a custom SQL query, you can use:
BusinessLayerFactory.createSQLQueryLov(String, BusinessLayer)
DataFoundationFactory.createSQLQueryLov(String, DataFoundation)
The columns describing the values returned by this expression can be retrieved with the getColumns()
method.
In the information design tool, the user builds the query in the SQL Expression Editor. See the Information Design Tool User Guide for more information.
The following features are supported:
Query Execution Timeout Enabled
Query Execution Timeout
Max Row Count Enabled
Max Row Count
SQL Expression
Method Summary | |
---|---|
java.util.List<SQLQueryLovColumn> |
getColumns()
Returns the columns of a SQLQueryLov object. |
int |
getMaxRowCount()
Returns the value of the 'Max Row Count' attribute. |
int |
getQueryExecutionTimeout()
Returns the value of the 'Query Execution Timeout' attribute. |
java.lang.String |
getSQLExpression()
Returns the value of the 'SQL Expression' attribute. |
boolean |
isMaxRowCountEnabled()
Returns the value of the 'Max Row Count Enabled' attribute. |
boolean |
isQueryExecutionTimeoutEnabled()
Returns the value of the 'Query Execution Timeout Enabled' attribute. |
void |
setMaxRowCount(int value)
Sets the value of the ' Max Row Count ' attribute. |
void |
setMaxRowCountEnabled(boolean value)
Sets the value of the ' Max Row Count Enabled ' attribute. |
void |
setQueryExecutionTimeout(int value)
Sets the value of the ' Query Execution Timeout ' attribute. |
void |
setQueryExecutionTimeoutEnabled(boolean value)
Sets the value of the ' Query Execution Timeout Enabled ' attribute. |
void |
setSQLExpression(java.lang.String value)
Sets the value of the ' SQL Expression ' attribute. |
Methods inherited from interface com.sap.sl.sdk.authoring.datafoundation.Lov |
---|
getDescription, isHidden, setDescription, setHidden |
Methods inherited from interface com.sap.sl.sdk.authoring.commons.Identifiable |
---|
getIdentifier |
Methods inherited from interface com.sap.sl.sdk.authoring.commons.Nameable |
---|
getName, setName |
Methods inherited from interface com.sap.sl.sdk.authoring.commons.Inheritable |
---|
getInheritedData |
Method Detail |
---|
boolean isQueryExecutionTimeoutEnabled()
"false"
.
Tells if there is a limit to the time in seconds that the query runs.
setQueryExecutionTimeoutEnabled(boolean)
void setQueryExecutionTimeoutEnabled(boolean value)
Query Execution Timeout Enabled
' attribute.
There is a limit to the time in seconds that the query runs, if value
is true
.
value
- the new value of the 'Query Execution Timeout Enabled' attribute.isQueryExecutionTimeoutEnabled()
int getQueryExecutionTimeout()
"100"
.
This is the limit to the time in seconds that the query runs.
setQueryExecutionTimeout(int)
void setQueryExecutionTimeout(int value)
Query Execution Timeout
' attribute.
This is the limit to the time in seconds that the query runs.
value
- the new value of the 'Query Execution Timeout' attribute.getQueryExecutionTimeout()
boolean isMaxRowCountEnabled()
"false"
.
Tells if there is a maximum number of rows to be returned by the query.
setMaxRowCountEnabled(boolean)
void setMaxRowCountEnabled(boolean value)
Max Row Count Enabled
' attribute.
There is a maximum number of rows to be returned by the list of values query, if value
is true
.
value
- the new value of the 'Max Row Count Enabled' attribute.isMaxRowCountEnabled()
int getMaxRowCount()
"500"
.
This is the maximum number of rows to be returned by the query.
setMaxRowCount(int)
void setMaxRowCount(int value)
Max Row Count
' attribute.
This is the maximum number of rows to be returned by the query.
value
- the new value of the 'Max Row Count' attribute.getMaxRowCount()
java.lang.String getSQLExpression()
""
.
This is the SQL expression from which the list of values is built.
setSQLExpression(String)
void setSQLExpression(java.lang.String value)
SQL Expression
' attribute.
This is the SQL expression from which the list of values is built.
value
- the new value of the 'SQL Expression' attribute.getSQLExpression()
java.util.List<SQLQueryLovColumn> getColumns()
SQLQueryLov
object.
These columns are computed when the data foundation or business layer is loaded or saved.
They can be also computed explicitly with DataFoundationService.detectLovColumns(SQLQueryLov)
and BusinessLayerService.detectLovColumns(SQLQueryLov)
methods.
SQLQueryLovColumn
objects
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |