topic Re: Dynamic contraint loading query with searchService in Alfresco Archive

Dynamic contraint loading query with searchService

anita_platos — Mon, 26 Aug 2013 10:50:10 GMT

I am trying to have a constraint loading its data through a searchService-query. The problem is that when I start the Alfresco, it keeps locked in the query, but it never starts.This is the code I´m using:- The java code for constraintackage org.myproject.mycontraints;import java.util.ArrayList;im

Re: Dynamic contraint loading query with searchService

anita_platos — Tue, 27 Aug 2013 06:39:49 GMT

The fact is that the java code with the query is called when the Alfresco is still starting - I don´t know why, for indexing, cache.. -. This queryes fails because the searchService needs Alfresco already started up, so I think this is the reason because it fails. If I use a counter in my java class to prevent calling the method the first times - while it´s starting -, it will do right once the Alfresco is started. I don´t like this solution because it is far from ellegant although it works..If somebody have a better idea, please let me know,
Thank you

Re: Dynamic contraint loading query with searchService

kaynezhang — Wed, 28 Aug 2013 05:16:00 GMT

Why do you want to use a dynamic list of values constraint, if you just want to let the user choose a value from a dropdown list or a combo box,you should customize alfresco share ui instead of dictionary model.
Frequently modify dynamic list of constraints(especially remove item from your constraints) may lead repository into a invalid state.
If you really want to do it in your way ,make your ListOfValuesConstraint implements ApplicationContextAware interface,and get NodeService and SearchService from spring ApplicationContext .


import org.springframework.context.ApplicationContext;
import org.springframework.context.ApplicationContextAware;
public class LoadingMyCombo extends ListOfValuesConstraint  implements ApplicationContextAware{

   private static  ApplicationContext applicationContext;
   public void setApplicationContext(ApplicationContext applicationContext) throws BeansException{
      this.applicationContext = applicationContext;
   }
   @Override
   public void initialize() {

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

   private List<String> getSearchResult()
   {
      NodeService nodeService =(NodeService)applicationContext.getBean("alfresco NodeServiceid");
      SearchService searchService = (SearchService)applicationContext.getBean("alfresco searchServcieid");
      List<String> allowedValues = new ArrayList<String>();
      String query = "PATH:\"/app:company_home/cm:DOCUMENTS\"";
      ResultSet resultSet = searchService.query(
            StoreRef.STORE_REF_WORKSPACE_SPACESSTORE,
            SearchService.LANGUAGE_SOLR_FTS_ALFRESCO, query);
      for (ResultSetRow row : resultSet)
         allowedValues.add((String) nodeService.getProperty(
               row.getNodeRef(), ContentModel.PROP_NAME));
      Collections.sort(allowedValues);
      if (allowedValues.size() == 0)
         allowedValues.add("");
      return allowedValues;
   }
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Dynamic contraint loading query with searchService

anita_platos — Mon, 02 Sep 2013 11:50:00 GMT

Thank you for reply me kaynezhang. Maybe I am wrong, but I think that the difference between your code and mine is that you use the ApplicationContextAware to get the
nodeService and searchService, while I do it putting the parameters in the bean. I don´t think that it´s gonna be relevant in the fact of having or not inconsistences.
Moreover, I have 2 problems:
1. The most important. How can I get the current node in the java constraint code?. At least, I need to read a property of the node - it´s a read-only protected
property, so I don´t need to do it like cascade interdependences refreshing and doing things like that.
2. I don´t know why, but the method getSearchResult() is called some times while Alfresco is starting - maybe for indexing or cache, I don´t know -. The problem is
that it gets locked indefinetly in the point of the query - I guess that it´s because it makes a mess trying to do a query without having finally started the content server -. Likewise I tryed with your code and it occurs the same.
I have figured out this problem doing something far from ellegant, with a counter to say - don´t do nothing the first 3 times when Alfresco is starting.
As simple as this:


    public List<String> getAllowedValues() {

         conta++;
         P.p ("getAllowedValues() "+conta);
          
          if (conta<4)  allowedValues = getEmptyList ();
          else     allowedValues = getSearchResult();
           super.setAllowedValues(allowedValues);
           return allowedValues;
    }

private List getEmptyList ()
       {
           List valuesResult = new ArrayList();
           valuesResult.add("");
           return valuesResult;
       }
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

This solution is not very pretty but is works OK doing it, if somebody knows any other way to fix it, please let me know,
Than you

Re: Dynamic contraint loading query with searchService

kaynezhang — Mon, 02 Sep 2013 15:18:17 GMT

Sine you implements a dynamic list of constraints like this ,then some one can change your dynamic list of constraints by adding/modifying/deleting node. Adding nodes will not be a problem, but deleting nodes will leave nodes with this property value in an invalid state.

I think the reason why it gets locked indefinetly in the point of the query is because during alfresco startup the search component is busy doing some initialization work ( for example checks consistence between the metadata, indexes and content) and not ready to provide search searvice.

You can try to define your bean like this


   <bean id="mytests.myconstraints.ConstraintInitializer" class="org.myproject.mycontraints.LoadingMyCombo" depends-on="repositoryEndBootstrapBean"> 
‍‍‍

Or you can just deploy your custom model into Company Home/Dictionary/Models in Alfresco repository instead of deploying content model XML file in classpath

Re: Dynamic contraint loading query with searchService

anita_platos — Tue, 03 Sep 2013 09:05:00 GMT

Thank you again, but it doesn´t work anyway. It tryes to do the queries while the repository is starting eitherway, even I try putting the depends-on="repositoryEndBootstrapBean" in the constaint definition and neither. That´s not my priority because I figure out with the counter - resolutive although not ellegant -.
My main problem is to get the node. I have seen some code in internet that does something like this:


…
import org.alfresco.web.bean.repository.Node;
…
 public Node getNode() {return node;}
public void setNode(Node node) {this.node = node;}
…
‍‍‍‍‍‍‍‍

What do I have to do to get the node?. It catch me as null, but I don´t know how does it work!

Re: Dynamic contraint loading query with searchService

kaynezhang — Tue, 03 Sep 2013 09:48:00 GMT

I'm sorry I am not clear which node do you want to get?
org.alfresco.web.bean.repository.Node is used in web-client .
If you get a NodeRef ,then you construct a org.alfresco.web.bean.repository.Node like this


import org.alfresco.web.bean.repository.MapNode;
import  org.alfresco.web.bean.repository.Node;

  MapNode node = new MapNode(nodeRef);
‍‍‍‍‍‍

Re: Dynamic contraint loading query with searchService

anita_platos — Thu, 05 Sep 2013 12:13:00 GMT

Ok kaynezhang, I changed my mind radically in the way to figure out the requirement: I was thinking what you told me about inconsistences risks using constraints so I decided to avoid touching models in the alfresco core and instead of it implement new ftl controls to be used in the alfresco share that makes the queries and get the values by Web Scripts. I think this is better, more flexible and more secure than touch the alfresco core, models, constraints… Anyway thank you so much kaynezhang, you have shown me the right way :-))

Re: Dynamic contraint loading query with searchService

kaynezhang — Thu, 05 Sep 2013 16:10:00 GMT

You are welcome.
If you just want to let the user choose a value from dynamic list of options ,it is a ui problem not a dictionary problem.Solving it by customizing UI is a good option,goodluck.

Re: Dynamic contraint loading query with searchService

genesy — Wed, 10 Dec 2014 11:41:54 GMT

Hi Anita,
I had the same yours problem and I resolved him with your suggestions about counter!
Like you said this is not a very elegant solution.
Can you give me an example about the better solution with ftl control you were talking about?

Thank you very much!

Re: Dynamic contraint loading query with searchService

shubhada — Fri, 18 Dec 2015 14:34:32 GMT

Hi Kaynezhang and Anita
I am loading a aspect which is a contraint of country. I have palced it in path , Path= ""/app:company_home/cm:metadatalist""
On startup of alfresco , with serach service am running the query to read this file. And it is stuck and not processing as search service is not avialable before startup.

I am trying to add some more country values to the list in run time, so that it gets reflected in the country dropdown while saving a content without restart of server.
As Anitha said, if I put a condition that count till 4, dont search for file while restarting.That works fine. But I dont want to hardcode any count value.
Can you please guide in achieving this ?

Thanks,