topic Dynamic list constraint in Alfresco Archive

Dynamic list constraint

ajperez — Tue, 06 Jul 2010 13:00:02 GMT

Hi,I'm trying to follow the examples provided in this post, to create a dynamic list constraint in Alfresco 3.3.So, I've created my own class extending ListOfValuesConstraintublic class MyConstraint extends ListOfValuesConstraint { private static ServiceRegistry registry; @Override public vo

Re: Dynamic list constraint

robain — Thu, 22 Jul 2010 18:35:23 GMT

Hi Did you find any resolution to this. seems like I am having similar issue with this during upgrade.

Re: Dynamic list constraint

matjazmuhic — Wed, 06 Oct 2010 15:46:36 GMT

Anyone resolved this?

Is there any other way to populate constraint with lucene search results?

Re: Dynamic list constraint

paulo_fernandes — Fri, 17 Dec 2010 17:33:30 GMT

This post is rather old.
For documentation purposes, and because its an important question, here is the solution:

Something like this (tested with Alfresco v2.9 and later versions):

SearchBasedListConstraint.java



public abstract class SearchBasedListConstraint extends ListOfValuesConstraint {

   private static ServiceRegistry serviceRegistry = null;
   protected String strStoreRef = "workspace://SpacesStore";
   protected String query = null;
   protected String sortField = null;
   protected Boolean sortDescending = null;

   @Override
        public void initialize() {
      //List<String> allowedValues = getSearchResult();
      //super.setAllowedValues(allowedValues);
        }
   
   @Override
   public List<String> getAllowedValues()
   {
      List<String> allowedValues = getSearchResult();
      //super.setAllowedValues(allowedValues);
      //return super.getAllowedValues();
      return allowedValues;
   }

   protected abstract List<String> getSearchResult();

   
   public ServiceRegistry getServiceRegistry() {
      return serviceRegistry;
   }

   public void setServiceRegistry(ServiceRegistry serviceRegistryParam) {
      serviceRegistry = serviceRegistryParam;
   }

   public String getStrStoreRef() {
      return strStoreRef;
   }

   public void setStrStoreRef(String strStoreRef) {
      this.strStoreRef = strStoreRef;
   }

   public String getQuery() {
      return query;
   }

   public void setQuery(String query) {
      this.query = query;
   }

   public String getSortField() {
      return sortField;
   }

   public void setSortField(String sortField) {
      this.sortField = sortField;
   }

   public Boolean getSortDescending() {
      return sortDescending;
   }

   public void setSortDescending(Boolean sortDescending) {
      this.sortDescending = sortDescending;
   }
   
}

‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

LuceneSearchBaseListConstraint.java


public class LuceneSearchBasedListConstraint extends SearchBasedListConstraint {
   
   protected List<String> getSearchResult() {
      SearchService searchService = getServiceRegistry().getSearchService();
      NodeService nodeService = getServiceRegistry().getNodeService();
      List<String> allowedValues = new ArrayList<String>();

      try {
         StoreRef storeRef = new StoreRef(strStoreRef);
         ResultSet resultSet = null;
         if (sortField != null) {
            SearchParameters sp = new SearchParameters();
            sp.addStore(storeRef);
            sp.setLanguage(SearchService.LANGUAGE_LUCENE);
            sp.setQuery(query);
            sp.addSort(sortField, (sortDescending!=null) ? !sortDescending : true);
            resultSet = searchService.query(sp);
         } else {
            resultSet = searchService.query(storeRef, SearchService.LANGUAGE_LUCENE, query);
         }
      
         for (ResultSetRow row : resultSet) {
            allowedValues.add((String)nodeService.getProperty(row.getNodeRef(), ContentModel.PROP_NAME));
         }
      } catch (Exception e) {
         e.printStackTrace();
      }
   
      return allowedValues;
   }
}

‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Dynamic list constraint

pavaniakella — Thu, 17 Mar 2011 11:07:06 GMT

Hi Paulo,

I tried the following code. But the values are not getting updated dynamically when I add new values to database.



package org.alfresco.ryden;

import java.util.ArrayList;
import java.util.List;
import java.sql.*;
import org.alfresco.repo.dictionary.constraint.ListOfValuesConstraint;
import org.alfresco.web.bean.generator.BaseComponentGenerator;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

import java.io.Serializable;
import javax.faces.model.SelectItem;

public class ListOfValuesQueryConstraint extends ListOfValuesConstraint implements Serializable {

   private static Log logger = LogFactory.getLog(BaseComponentGenerator.class);
   
   private static final long serialVersionUID=1;
   
   private List<String> allowedLabels;
   
   public void setAllowedValues(List allowedValues) {}
   public void setCaseSensitive(boolean caseSensitive) {}

   public void initialize() {
       super.setCaseSensitive(false);
       this.loadDB();
    }
   
   public List<String> getAllowedLabels() {
      return this.allowedLabels;
   }
   
   public void setAllowedLabels(List<String> allowedLabels) {
      this.allowedLabels=allowedLabels;
   }
    
    public List<SelectItem> getSelectItemList() {
      List<SelectItem> result = new ArrayList<SelectItem>(this.getAllowedValues().size());
      for(int i=0;i<this.getAllowedValues().size();i++) {
         result.add(new SelectItem((Object)this.getAllowedValues().get(i),this.allowedLabels.get(i)));
      }
      return result;
   }
    
    protected void loadDB() {
       
       String driverName = "com.mysql.jdbc.Driver";
        String serverName = "localhost:3307";
        String mydatabase = "propertyrecord";
        String username = "propertyrecord";
        String password = "rydenproperty";
       
        List<String> av = new ArrayList<String>();
        List<String> al=new ArrayList<String>();
        
       
        try {
           Connection connection = null;
            Class.forName(driverName);
            String url = "jdbc:mysql://" + serverName +  "/" + mydatabase;
            connection = DriverManager.getConnection(url, username, password);
            Statement stmt = connection.createStatement();
            ResultSet rs = stmt.executeQuery("select propertyRef from propertyrecord");
            while (rs.next()) {
                av.add(rs.getString("propertyRef"));
                al.add(rs.getString("propertyRef"));
            }
        }
        catch (Exception e) {}
       
      super.setAllowedValues(av);
      this.setAllowedLabels(al);
   }
}

‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

<constraint name="dl:PropertyRef" type="org.alfresco.ryden.ListOfValuesQueryConstraint" />‍

So I changed the code to what you mentioned. The following is the code. With this code I got an error saying allowed values JSON object not found. Please let me know what am I doing wrong?



package org.alfresco.ryden;

import java.util.ArrayList;


import java.util.List;
import java.sql.*;
import org.alfresco.repo.dictionary.constraint.ListOfValuesConstraint;


public class ListOfValuesQueryConstraint extends ListOfValuesConstraint {

  
   @Override
   public void initialize() {
   }
   
   @Override
   public List<String> getAllowedValues()
   {
      List<String> allowedValues = loadDB();
      //super.setAllowedValues(allowedValues);
      //return super.getAllowedValues();
      return allowedValues;
   }


    protected List<String> loadDB() {
       
       String driverName = "com.mysql.jdbc.Driver";
        String serverName = "localhost:3307";
        String mydatabase = "propertyrecord";
        String username = "propertyrecord";
        String password = "rydenproperty";
       
        List<String> av = new ArrayList<String>();
        List<String> al=new ArrayList<String>();
        
       
        try {
           Connection connection = null;
            Class.forName(driverName);
            String url = "jdbc:mysql://" + serverName +  "/" + mydatabase;
            connection = DriverManager.getConnection(url, username, password);
            Statement stmt = connection.createStatement();
            ResultSet rs = stmt.executeQuery("select propertyRef from propertyrecord");
            while (rs.next()) {
                av.add(rs.getString("propertyRef"));
                al.add(rs.getString("propertyRef"));
            }
            rs=null;
        }
        catch (Exception e) {}
    
      return av;
   }
}
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

and the constraint declaration is

<constraint name="dl:PropertyRef" type="org.alfresco.ryden.ListOfValuesQueryConstraint" />‍

Regards,
Pavani

Re: Dynamic list constraint

alarocca — Wed, 20 Jul 2011 06:25:58 GMT

On Share 3.4.d, getAllowedValues() is called just once at startup. This is the reason why the list never updates.

Since I successfully used the same solution on an older release of Alfresco Explorer, I guess the problem is on gui instead of the custom constraint.

This post is rather old.
For documentation purposes, and because its an important question, here is the solution:

Override initialize() and do nothing
Don't override setAllowedValues()
Don't put allowedValues in the super class, return the list directly

Re: Dynamic list constraint

glaenen — Wed, 06 Jun 2012 14:48:14 GMT

On alfresco 4.0d adding

@Override
public List<String> getAllowedValues(){
this.loadDB();
return super.getAllowedValues();
}

to your constraint class does the trick, ou don't have to change the initialize.

Kind Regards,

Glenn