Application: gvSIG desktop

import java.util.List;

import org.gvsig.tools.util.UnmodifiableBasicList;

    public static final String FETCH_NAME = "FETCH";

    private class FetchFunction extends AbstractFunction {

        public FetchFunction() {

            super(

                    "Project",

                    FETCH_NAME,

                    Range.between(2, 4),

                    "Access to the features of a table and retuen a list with the values.",

                    FETCH_NAME+"({{value}}, store, where, order)",

                    new String[]{

                        "value - value to retrieve from the store, usually an expression in the columns of this are involved.",

                        "store - data store from which values will be collected",

                        "where - Optional. String value with a filter expression",

                        "order - Optional. String value with the order. must be a string with the names of separate fields with commas"

                    },

                    "Object"

            );

        }

        @Override

        public Object call(Interpreter interpreter, Object[] args) throws Exception {

            Object value;

            String where = null;

            String order = null;

            String expression_s = getStr(args, 0);

            FeatureStore store = (FeatureStore) getObject(args, 1);

            switch (args.length) {

                case 3:

                    where = getStr(args, 2);

                    break;

                case 4:

                    where = getStr(args, 2);

                    order = getStr(args, 3);

                    break;

            }

            try {

                List<Feature> features;

                if (where == null && order == null) {

                    features = store.getFeatures();

                } else {

                    FeatureQuery query = store.createFeatureQuery();

                    if (where != null) {

                        query.addFilter(where);

                    }

                    if (order != null) {

                        query.getOrder().add(order);

                    }

                    query.retrievesAllAttributes();

                    features = store.getFeatures(query);

                }

                UnmodifiableBasicList<Object> list = new ListOfFeaturesWrapper(

                        features,

                        interpreter.getSymbolTable(), 

                        expression_s

                );

                return list;

            } catch (Exception ex) {

                throw new ExpressionRuntimeException("Problems calling '"+FETCH_NAME+"' function", ex);

            }

        }

    }

        this.addFunction(new FetchFunction());