topic Re: Custom Aspect Property reading Values from a database Field in Alfresco Archive

Custom Aspect Property reading Values from a database Field

ctraversa — Sun, 16 Dec 2007 22:36:27 GMT

Hi all.I'd like to have a suggestion on the best way to implement Custom Aspect Property whose values come from a database field.In other words the possible values of the custom aspect property cannot be entered freely but come from a database field with more then 5000 entries.Does exist a best prac

Re: Custom Aspect Property reading Values from a database Field

acis — Fri, 14 Mar 2008 14:16:46 GMT

Hi ctraversa,

You have to create a new custom constraint for your property.

So your model should look like



…

<constraints>
      <constraint name="tc:CodeLabel" type="org.alfresco.sample.CodeLabelExtend.ListOfValuesQueryConstraint" />
   </constraints>
   
   <types>
      <type name="tc:codecontent">
         <title>Contenu Ã©tendu</title>
         <parent>cm:content</parent>
         <properties>
            <property name="tc:codestr">
               <title>Code str</title>
               <type>d:text</type>
               <constraints>
                  <constraint ref="tc:CodeLabel" />
               </constraints>
            </property>
         </properties>
      </type>
   </types>

…

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

After you have to define your ListOfValuesQueryConstraint class like this :



package org.alfresco.sample.CodeLabelExtend;

import java.util.ArrayList;
import java.util.List;
import java.sql.*;
import org.alfresco.i18n.I18NUtil;
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 = "org.gjt.mm.mysql.Driver";
        String serverName = "localhost";
        String mydatabase = "alfresco";
        String username = "alfresco";
        String password = "alfresco";
       
        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 code,label from codelabel");
            while (rs.next()) {
                av.add(rs.getString("code"));
                al.add(rs.getString("label"));
            }
        }
        catch (Exception e) {}
       
      super.setAllowedValues(av);
      this.setAllowedLabels(al);
   }
}

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

And that's it.

After you can create a component generator and a converter to custom displaying in the web client but it's not compulsary.

Re: Custom Aspect Property reading Values from a database Field

marcostopper — Fri, 29 Aug 2008 08:31:26 GMT

I have a db with 3 different fields. Is possible to change value of a property when the user select a value from one of the fields. When the user insert a document he choose from a name from the combo box. Is possible to view the other related information in the next text box? I suppose I have to make a query using value selected from the user. How can I get this value to make the query? Have you any example?

Re: Custom Aspect Property reading Values from a database Field

archana_bonkanp — Tue, 30 Sep 2008 10:12:10 GMT

Hi All,

I just dont want the values to be displayed fro the db.
but i just want to add some static values in the drop down list ,so that user selects them instaed of typing.
please hel[p me in implementing the same.

Thanks & regards,
Archana

Re: Custom Aspect Property reading Values from a database Field

jpfi — Tue, 30 Sep 2008 11:00:23 GMT

Hi,
a simple list constraint solves your prob. here is an example:
http://wiki.alfresco.com/wiki/Content_Model_Constraints
Cheers, Jan

Re: Custom Aspect Property reading Values from a database Field

archana_bonkanp — Tue, 30 Sep 2008 12:13:30 GMT

HI Jan,

Thanks for providing the link.but i was confused in which file to add the constraint list.
I need a list with "DG" title and values "ARC" ,"ARC1","ARC2".
i have aded following in the custommodel.xml file

   <aspects>
   <aspect name="custom:CustomerDetails">
   <title>Lessons Learned Database</title>
   <properties>
   <property name="custom:deliverygroup">
   <title>Delivery Group</title>
   <type>d:text</type>
   </property>
   <property name="custom:domain">
   <title>Domain</title>
   <type>d:text</type>
   </property>
   <property name="customroducttype">
   <title>Produst Type</title>
   <type>d:text</type>
   </property>
   <property name="customhase">
   <title>Phase</title>
   <type>d:text</type>
   </property>
   <property name="custom:dropdowntest">
   <title>Dropdownlist</title>
   <type>d:category</type>
   </property>
   </properties>
</aspect>
</aspects>

and in webclient config custom,we added

<config evaluator="string-compare" condition="Action Wizards">
<aspects>
     <aspect name="custom:CustomerDetails"/>
</aspects>
</config>

<config evaluator="aspect-name" condition="custom:CustomerDetails">
<property-sheet>
<separator name="sepCust1" display-label="Lessons Learned Database"
          component-generator="HeaderSeparatorGenerator"/>

<show-property name="custom:deliverygroup"/>
<show-property name="custom:domain"/>
<show-property name="customroducttype"/>
<show-property name="customhase"/>
<show-property name="custom:dropdowntest">
<list>
                <value>BFSI</value>
                <value>SAM</value>
         </list>

</show-property>

</property-sheet>
</config>

<config evaluator="string-compare" condition="Advanced Search">
<advanced-search>
<content-types>
<type name="custom:CustomerDetails"/>
</content-types>

<custom-properties>

<meta-data aspect="custom:CustomerDetails"
property="custom:deliverygroup"/>
<meta-data aspect="custom:CustomerDetails"
property="custom:domain"/>
<meta-data aspect="custom:CustomerDetails"
property="customroducttype"/>
<meta-data aspect="custom:CustomerDetails"
property="customhase"/>
<meta-data aspect="custom:CustomerDetails"
property="custom:dropdowntest"/>

</custom-properties>
</advanced-search>
</config>

please solve my issue
its urgent

Regards,
Archana

Re: Custom Aspect Property reading Values from a database Field

archana_bonkanp — Wed, 01 Oct 2008 10:17:58 GMT

Hi

how to implement drop down box box custom proeprties,please help.
we need only static values to be define in the combo box.
Its urgent

Re: Custom Aspect Property reading Values from a database Field

dgenard — Wed, 01 Oct 2008 11:29:43 GMT

Simply set a LIST constraint on the property in your model.
Here is an example :

            <property name="acme:type">
               <type>d:text</type>
               <mandatory>true</mandatory>
               <default>simple</default>
               <constraints>
                  <constraint type="LIST">
                     <parameter name="allowedValues">
                        <list>
                           <value>simple</value>
                           <value>double</value>
                           <value>triple</value>
                        </list>
                     </parameter>
                  </constraint>
               </constraints>
            </property>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Cheers,
Denis

Re: Custom Aspect Property reading Values from a database Field

archana_bonkanp — Mon, 13 Oct 2008 08:36:21 GMT

HI Denis,

Please give us the detail list of the steps to be written in the custom model.xml,web-cleint -config-cutom.xml file to get the drop down list of static values .

im getting an error if add above code

Re: Custom Aspect Property reading Values from a database Field

dgenard — Mon, 13 Oct 2008 09:04:56 GMT

For complete reference, all details are here :
http://wiki.alfresco.com/wiki/Data_Dictionary_Guide#Step_by_Step_Model_Definition

Without any details on your error (model file and log extract), it won't be easy to give you more precise help…

Regards,
Denis

Re: Custom Aspect Property reading Values from a database Field

archana_bonkanp — Mon, 13 Oct 2008 10:32:54 GMT

hi,

i have renamed the custom-model-context.xml.sample file as custom-model-context.xml,
then in custom model.xml file

<model name="custom:customModel" xmlns="http://www.alfresco.org/model/dictionary/1.0">

   <!– Optional meta-data about the model –>
   <description>Custom Model</description>
   <author></author>
   <version>1.0</version>

   <imports>
        <!– Import Alfresco Dictionary Definitions –>
      <import uri="http://www.alfresco.org/model/dictionary/1.0" prefix="d"/>
      <!– Import Alfresco Content Domain Model Definitions –>
      <import uri="http://www.alfresco.org/model/content/1.0" prefix="cm"/>
   </imports>

   <!– Introduction of new namespaces defined by this model –>
   <!– NOTE: The following namespace custom.model should be changed to reflect your own namespace –>
   <namespaces>
      <namespace uri="custom.model" prefix="custom"/>
   </namespaces>

<types>
<type name="customneType">
         <title>One kind of type</title>
         <parent>cm:content</parent>
         <properties>
            <property name="custom:whatever">
               <type>d:text</type>
               <multiple>false</multiple>
                    <index enabled="true">
                  <tokenised>true</tokenised>
               </index>
                    <constraints>
<constraint ref="custom:yesno"/>
               </constraints>
                  </property>
               </properties>
            </type>

<constraint name="pre:yesno" type="LIST">
         <parameter name="allowedValues">
            <list>
               <value>Yes</value>
               <value>No</value>
               <value>Indeterminated</value>
            </list>
         </parameter>
      </constraint>
</types>
</model>

then in thew web-client config custom.xml,added the following code

<config evaluator="string-compare" condition="Action Wizards">
<aspects>
     <aspect name="custom:CustomerDetails"/>
</aspects>
<subtypes>

<type name="customneType"/>

</subtypes>
</config>

<config evaluator="aspect-name" condition="custom:CustomerDetails">
<property-sheet>
<separator name="sepCust1" display-label="Lessons Learned Database"
          component-generator="HeaderSeparatorGenerator"/>

<show-property name="custom:Geography"/>

</property-sheet>
</config>

Re: Custom Aspect Property reading Values from a database Field

archana_bonkanp — Mon, 13 Oct 2008 13:15:58 GMT

im nt getting any error but i cant see that property
hw to set that property to a document

Re: Custom Aspect Property reading Values from a database Field

marcostopper — Tue, 18 Nov 2008 00:02:14 GMT

I've acces to my SQL Server 2005 database. So my custom property can get only permetted value froma my database.

I've wrote an application to write file in the repository (using API Web Services C#) with their "custom" meta-data.

Now the problem is how to refresh Alfresco to get database changing. Sometimes I tried to write file with databse updatated value for the custom property and I got an Integrity error for my Alfresco. The repository doesn't refresh the custom constraint with new value from db.
How can I get the repository refreshed?
Remember that the user doesn't access by the standard graphic interface but throw my custom application.