Revision 44740 trunk/org.gvsig.desktop/org.gvsig.desktop.compat.cdc/org.gvsig.fmap.dal/org.gvsig.fmap.dal.impl/src/main/java/org/gvsig/expressionevaluator/impl/function/dataaccess/SelectFunction.java
SelectFunction.java | ||
---|---|---|
50 | 50 |
public SelectFunction() { |
51 | 51 |
super(DALFunctions.GROUP_DATA_ACCESS, |
52 | 52 |
DALFunctions.FUNCTION_SELECT, |
53 |
Range.between(1,1000), |
|
54 |
"Returns a list of features of the indicated table by applying the filter and order indicated..", |
|
55 |
DALFunctions.FUNCTION_SELECT + "({{table_name}},filter, order, limit)", |
|
53 |
Range.between(1,5), |
|
54 |
"Returns a list of features of the table by applying the filter, order and limit indicated.\n"+ |
|
55 |
"The syntax is:\n\n"+ |
|
56 |
"SELECT * FROM table WHERE boolean_expression ORDER BY order_column LIMIT limit;\n\n"+ |
|
57 |
"Indicate a filter expression with WHERE, an order or LIMIT is optional.\n"+ |
|
58 |
"The SELECT statement must always end with a semicolon.", |
|
59 |
"SELECT * FROM {{table_name}} WHERE filter ;", |
|
56 | 60 |
new String[]{ |
57 | 61 |
"table_name - Name of the table", |
58 |
"filter - filter to apply",
|
|
59 |
"order - the order used to retrieve the features",
|
|
62 |
"filter - boolean expression to apply as filter",
|
|
63 |
"order_column - the order used to retrieve the features. It is a list of column names separated by a comma. The column name can optionally be followed by ASC or DESC to indicate whether the order should be ascending or descending.",
|
|
60 | 64 |
"limit - Maximum number of features to return" |
61 | 65 |
}, |
62 | 66 |
"List", |
... | ... | |
66 | 70 |
|
67 | 71 |
@Override |
68 | 72 |
public boolean isHidden() { |
69 |
return true;
|
|
73 |
return false;
|
|
70 | 74 |
} |
71 | 75 |
|
72 | 76 |
@Override |
Also available in: Unified diff