Application: gvSIG desktop

    private Map<String,DynObjectValueItem[]> availableValues = null;

      this.availableValues = null;

    public DynObjectValueItem[] getAvailableValues(DynObject contextValues, FeatureStore myStore, FeatureAttributeDescriptor descriptor) {

        String keyName = myStore.getFullName() + ":columnName=" + descriptor.getName();

        if( this.availableValues==null ) {

            this.availableValues = new HashMap<>();

        }

        DynObjectValueItem[] values = this.availableValues.get(keyName);

        if( values != null ) {

            return values;

        }

        if( !descriptor.isForeingKey() ) {

            return null;

        }

        ForeingKey foreingKey = descriptor.getForeingKey();

        FeatureStore foreingStore = null;

        DisposableFeatureSetIterable  set = null;

        try {

            StoresRepository theStoresRepository;

            FeatureStore store = descriptor.getStore();

            if (store == null) {

                theStoresRepository = DALLocator.getDataManager().getStoresRepository();

            } else {

                theStoresRepository = store.getStoresRepository();

            }

            foreingStore = (FeatureStore) theStoresRepository.getStore(

                foreingKey.getTableName()

            );

            Expression labelExpression = foreingKey.getLabelExpression(null);

            String codeName = foreingKey.getCodeName();

            FeatureSymbolTable featureSymbolTable = this.createFeatureSymbolTable("feature");

            MutableSymbolTable symbolTable = featureSymbolTable.createParent();

            Expression filter = descriptor.getAvailableValuesFilter();

            if( filter != null ) {

                MutableSymbolTable filterFeatureSymbolTable = ExpressionUtils.createSymbolTable(

                        "filter", contextValues

                );

                featureSymbolTable.addSymbolTable(filterFeatureSymbolTable);

            }

            List<DynObjectValueItem> values_list = new ArrayList<>();

            int n = 0;

            for (Feature feature : set = foreingStore.getFeatureSet().iterable()) {

                Object value = feature.get(codeName);

                Object label;

                if (labelExpression == null) {

                    label = value;

                } else {

                    featureSymbolTable.setFeature(feature);

                    label = labelExpression.execute(symbolTable);

                }

                if( filter != null ) {

                    symbolTable.setVar("$value", value);

                    symbolTable.setVar("$label", label);

                    featureSymbolTable.setFeature(feature);

                    Object include = filter.execute(featureSymbolTable);

                    if( DataTypeUtils.isFalse(include, false) ) {

                        continue;

                    }

                }

                values_list.add(new DynObjectValueItem(value, Objects.toString(label, Objects.toString(value, "##ERROR##"))));

                if( n>=MAX_AVAILABLE_VALUES ) {

                    break;

                }

            }

            values = values_list.toArray(new DynObjectValueItem[values_list.size()]);

            if( filter==null ) {

                this.availableValues.put(keyName, values);

            }

            return values;

        } catch (Exception ex) {

            LOGGER.warn("Can't get available values for field '"+myStore.getName()+"."+descriptor.getName()+"' from table '" + foreingKey.getTableName() + "'.", ex);

        } finally {

            DisposeUtils.disposeQuietly(set);

            DisposeUtils.disposeQuietly(foreingStore);

        }

        return null;

    }

    @Override

    }