Property group

[vincentk222]

I'm testing the possibilities of property group
I had look on Form Element Description

I tested succesfully the "Suggestbox" but "Select" do not work
here is the definition :

Code: Select all

   <select label="Provincia" name="okp:provincia" type="simple" 
      	table="provincia"
        optionsQuery="select $pro_id, $pro_nombre from DatabaseMetadataValue dmv where dmv.table='provincia'"/>

Is there somewhere example with iframe?

[jllort]

Iframe feature is only available from version 6.4 ( professional editon ).

Have you executed the inserts described at http://wiki.openkm.com/index.php/Form_E ... escription:

Code: Select all

-- NORMAL
DELETE FROM OKM_DB_METADATA_TYPE WHERE DMT_TABLE='provincia';
INSERT INTO OKM_DB_METADATA_TYPE (DMT_TABLE, DMT_REAL_COLUMN, DMT_TYPE, DMT_VIRTUAL_COLUMN) VALUES ('provincia', 'col00', 'integer', 'pro_id');
INSERT INTO OKM_DB_METADATA_TYPE (DMT_TABLE, DMT_REAL_COLUMN, DMT_TYPE, DMT_VIRTUAL_COLUMN) VALUES ('provincia', 'col01', 'text', 'pro_nombre');
 
-- SOME DATABASES NEED SET DMT_ID, LIKE ORACLE
DELETE FROM OKM_DB_METADATA_TYPE WHERE DMT_TABLE='provincia';
INSERT INTO OKM_DB_METADATA_TYPE (DMT_ID, DMT_TABLE, DMT_REAL_COLUMN, DMT_TYPE, DMT_VIRTUAL_COLUMN) VALUES (HIBERNATE_SEQUENCE.NEXTVAL, 'provincia', 'col00', 'integer', 'pro_id');
INSERT INTO OKM_DB_METADATA_TYPE (DMT_ID, DMT_TABLE, DMT_REAL_COLUMN, DMT_TYPE, DMT_VIRTUAL_COLUMN) VALUES (HIBERNATE_SEQUENCE.NEXTVAL, 'provincia', 'col01', 'text', 'pro_nombre');

the metadata field should be:

Code: Select all

<select label="Provincia" name="okp:provincia" type="simple" table="provincia"
        optionsQuery="select $pro_id, $pro_nombre from DatabaseMetadataValue dmv where dmv.table='provincia'"/>

[vincentk222]

Yes I did execute the NORMAL sql script.
I checked the metadata table and everything seems OK

I still get this error :

Application error
Class: com.openkm.core.ParseException
Message: Attribute "table" must be declared for element type "select".
Date: Thu Jan 30 09:44:08 CET 2014

Note: I did the test with the Suggestbox and it works fine.

here is my PropertyGroups.xml

Code: Select all

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE property-groups PUBLIC "-//OpenKM//DTD Property Groups 2.0//EN"
                                 "http://www.openkm.com/dtd/property-groups-2.0.dtd">
<property-groups>
  <property-group label="Consulting" name="okg:consulting">
    <input label="Name" type="text" name="okp:consulting.name"/>
    <input label="Name" type="date" name="okp:consulting.date" />
    <checkbox label="Important" name="okp:consulting.important"/>
    <textarea label="Comment" name="okp:consulting.comment"/>
  </property-group>
  
  <property-group label="Technology" name="okg:technology">
    <select label="Type" name="okp:technology.type" type="multiple">
      <option label="Alfa" value="t1"/>
      <option label="Beta" value="t2" />
      <option label="Omega" value="t3" />
    </select>
    <select label="Language" name="okp:technology.language" type="simple">
      <option label="Java" value="java"/>
      <option label="Python" value="python"/>
      <option label="PHP" value="php" />
    </select>
    <input label="Comment" name="okp:technology.comment"/>
    <textarea label="Description" name="okp:technology.description"/>
    <input label="link" type="link" name="okp:technology.link"/>
  </property-group>

  <property-group label="Demo" name="okg:demo">
   <select label="Provincia" name="okp:provincia" type="simple"
         table="provincia"
        optionsQuery="select $pro_id, $pro_nombre from DatabaseMetadataValue dmv where dmv.table='provincia'"/>
  </property-group>
</property-groups>

[jllort]

Change the http://www.openkm.com/dtd/property-groups-2.0.dtd to a newer one like http://www.openkm.com/dtd/property-groups-2.1.dtd ( see here table http://wiki.openkm.com/index.php/Proper ... definition )

[vincentk222]

Yes
Thanks , it works now.
Vincent

[intel74]

hi
I've a similar problem with SELECT elemen .... no one error displayed but drop down was empty.
I followed example
If I use SUGGESTBOX it run perfectly but with SELECT nothig to do...

Code: Select all

<select label="Provincia" name="okp:fatturaemessa.provincia" type="simple" 
      	table="provincia" suggestion="com.openkm.form.suggestion.DocumentContentTokenizerSuggestion"
        optionsQuery="select $pro_id, $pro_nombre from DatabaseMetadataValue dmv where dmv.table='provincia'"/>

any idea?
thanks in advance

[jllort]

Take this as example ( I think your previous definition was right ):

Code: Select all

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE property-groups PUBLIC "-//OpenKM//DTD Property Groups 2.5//EN"
                                 "http://www.openkm.com/dtd/property-groups-2.5.dtd">
<property-groups>
  <property-group label="Consulting" name="okg:consulting">
     <select label="country" name="okp:consulting.country" type="simple" 
      	table="country" 
        optionsQuery="select $country_id, $country_name from DatabaseMetadataValue dmv where dmv.table='country' order by $country_name"/>
  </property-group>
</property-groups>

Try first without suggestion="com.openkm.form.suggestion.DocumentContentTokenizerSuggestion" and later with suggestion ( if then is not going right we will have isolated the problem ).

[intel74]

thanks for your help, I followed your instructions but the result is the same
I attach the screenshot and there you can see the definition of the property group:

Code: Select all

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE property-groups PUBLIC "-//OpenKM//DTD Property Groups 2.5//EN"
                                 "http://www.openkm.com/dtd/property-groups-2.5.dtd">

<property-groups>
    <property-group label="Consulting" name="okg:consulting">
     	<select label="Provincia" name="okp:consulting.country" type="simple" 
        	 table="country"  optionsQuery="select $pro_id, $pro_nombre from DatabaseMetadataValue dmv where dmv.table='provincia' order by $pro_nombre"/>
               
         <suggestbox label="Provincia" name="okp:consulting.provincia2" width="200px"
		 table="provincia" dialogTitle="Seleccionar Provincia" filterMinLen="3"
		 filterQuery="select $pro_id, $pro_nombre from DatabaseMetadataValue dmv where dmv.table='provincia' and lower(dmv.$pro_nombre) like '%{0}%' order by dmv.$pro_nombre"
		 valueQuery="select $pro_id, $pro_nombre from DatabaseMetadataValue dmv where dmv.table='provincia' and dmv.$pro_nombre='{0}'" />            
	  </property-group>

I think it is a trivial problem but I do not understand what
thanks again

[jllort]

which OpenKM version are you using ?

[intel74]

I'm using the Community version 6.3 on Windows Server 2011 and MS SQL 2008 sp4

I begin to think that the problem is due to the db, Perhaps the compatibility with sql is not complete

I tried to use the same metadata definitions in a workflow form. The behavior is the same, select box was empty while suggest box fill box correctly but if i fill form and click on button to submit form the system show an error that i do not understand.(you can ycheck screenshots attached)

I don't know the DB Layer but it seems that a sql command or store procedure goes wrong

thank you so much for your availability

[jllort]

Post here your form.xml and also go to Administration > Database query and execute :
SELECT * FROM okm_db_metadata_type;

[intel74]

Code: Select all

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE workflow-forms PUBLIC "-//OpenKM//DTD Workflow Forms 2.4//EN" "http://www.openkm.com/dtd/workflow-forms-2.4.dtd">
<workflow-forms>
  <workflow-form task="Inserimento">
  	<input label="Numero Fattura" type="text" name="numeroFattura">
		<validator type="req"/>
	</input>
    <input label="Data Fattura" type="date" name="dataFattura">
         <validator type="req"/>
    </input>     
    <suggestbox label="FORNITORE" name="fornitoreFattura" width="200px" table="FORNITORE" dialogTitle="Seleziona il fornitore" filterMinLen="3"
                filterQuery= "select $fornitore_id, $fornitore_ragionesociale, $fornitore_piva from DatabaseMetadataValue dmv where dmv.table='FORNITORE' and lower(dmv.$fornitore_ragionesociale) like '%{0}%' order by dmv.$fornitore_ragionesociale"
                valueQuery="select $fornitore_id, $fornitore_ragionesociale, $fornitore_piva from DatabaseMetadataValue dmv where dmv.table='FORNITORE' and dmv.$fornitore_id='{0}'" />
 	<input label="Imponibile" type="text" name="imponibileFattura">
		<validator type="dec"/>  
    </input>
     
    <input label="% IVA" name="ivaFattura">
    	<validator type="num"/>
    </input>
    <select label="Tipo di pagamento" name="tipopagamentoFattura" type="simple">
	    <option label="Per cassa" value="1"/>
	    <option label="Carta di credito" value="2"/>
	    <option label="Bonifico anticipato" value="3"/>
	    <option label="Bonifico posticipato" value="4"/>
	    <option label="Assegno" value="5"/>
        <option label="Altro" value="6"/>
    </select> 
    <suggestbox label="Centro di costo" name="ccFattura" width="200px"  table="CENTRO_COSTO" dialogTitle="Seleziona il centro di costo" filterMinLen="0"
                filterQuery= "select $centro_costo_id, $centro_costo_descrizione from DatabaseMetadataValue dmv where dmv.table='CENTRO_COSTO' and lower(dmv.$centro_costo_descrizione) like '%{0}%' order by dmv.$centro_costo_descrizione"
                valueQuery="select $centro_costo_id, $centro_costo_descrizione from DatabaseMetadataValue dmv where dmv.table='CENTRO_COSTO' and dmv.$centro_costo_id='{0}'" />
    <input label="Note" name="noteFattura" />
	      
            <select label="Stato Fattura" name="fatturaStato" type="simple">
                <option label="Validazione" value="1"/>
                <option label="Registrazione" value="2" />
                <option label="Approvazione" value="3" />
                <option label="In Pagamento" value="4" />
                <option label="Pagata" value="5" />
                <option label="Scartata" value="6" />
                <option label="Contestata" value="7" />
                <option label="Parzialmente Pagata" value="8" />
            </select>
        
	    
            <input label="Numero" type="text" name="protocollonumeroregistro" >
		 <validator type="num" />
            </input>
            <input label="Data" type="date" name="protocollodataregistro" >
		 
            </input>
	
	
	
    <button name="submit" label="Invio" />
  </workflow-form>
  <workflow-form task="Approvazione">
  	<button name="submit" label="Approva" />
    <button name="submit" label="Rigetta" />
  </workflow-form>
  <workflow-form task="registrazione">
  	<input label="Numero Registrazione" type="text" name="nRegistroFattura" >
  		<validator type="req"/>
		<validator type="num" />
	</input>
    <input label="Data Registrazione" type="date" name="dataRegistroFattura" >
		<validator type="req"/>
	</input>  
    <button name="submit" label="Ok" />
  </workflow-form>
</workflow-forms>		
 
           
            

[jllort]

Tree suggestions:
1- try to change $centro_costo_id, $centro_costo_descrizione to dmv.$centro_costo_id, dmv.$centro_costo_descrizione
2- change type integer to text ( OKM_DB_METADATA_TYPE of col00 )
3- is a good practice use 001, 002 until 999 on option values, otherwise when search by lucene you will get incorrect results ( for example when looking for value 1, also will be retrieved 11, 12, etc... if you normalize with 0 at the begining the value of chain is distinct for each value and lucene will retrieve you correct results ).

If the error persists, will be interesting get see the comple error from catalina.log

[intel74]

hi jllort
your first suggestion solved my problem!!! now it works perfectly!
thanks a lot for your help

[intel74]

i forgot to specify... I solved problem about suggestbox, but I still have problems with the select box
using suggest box i found value in the box... using selectbox the dropdown list was empty.