topic Re: CMIS custom type query in Alfresco Archive

CMIS custom type query

lukas — Wed, 28 Aug 2013 21:49:37 GMT

HiI want to create a CMIS query to get informations about a custom folderSo I tried the followingELECT * FROM em:eventfolder WHERE em:eventfolder.eventid='1000'‍Unfortunately this select did not work.my content model:<type name="em:eventfolder"> <title>Event Fold

Re: CMIS custom type query

rjohnson — Wed, 28 Aug 2013 23:38:19 GMT

If I remember correctly, your query should be something like:-


SELECT * FROM F:em:eventfolder WHERE P:em:eventfolder.eventid='1000'
‍‍‍

You need to define what CMIS is looking at F = Folder, D = Document, P = property.

Re: CMIS custom type query

kaynezhang — Thu, 29 Aug 2013 02:00:00 GMT

There are several errors in you model definition and query:
1.Your property name should not include ".";
2.You should make your property searchable in property defintion;
3.You don't need to add prefix (such as F:,D:smileyhappy:before your type
And P is not for property but for Policy,and you don't need it in cmis query at all.

You can modify you model like this
<code>
      <type name="ca:eventfolder">
         <title>Event Folder</title>
        <parent>cm:folder</parent>
        <properties>
           <property name="ca:eventid">
              <type>d:text</type>
                        <index enabled="true">
                       <tokenised>false</tokenised>
                        </index>
           </property>
        </properties>
      </type>
<code>
and
Modify you query string like this "SELECT * FROM ca:eventfolder ef WHERE ef.ca:eventid='1000'";

Re: CMIS custom type query

lukas — Thu, 29 Aug 2013 08:48:00 GMT

Thanks for your help
I have modified my content model according to your post.
But I'm still not able to query em:eventfolder
I have tested the query with the CMIS-Workbench

select * from em:eventfolder‍

Is there anything else to consider?

thanks

Lukas

Re: CMIS custom type query

kaynezhang — Thu, 29 Aug 2013 09:01:40 GMT

please paste your model definition here

Re: CMIS custom type query

lukas — Thu, 29 Aug 2013 11:55:00 GMT

I the meantime i found out that Select * From em:doc works
em:folder still does not work
I'm also not able to query Select em:docdocID from em:doc but Select cmis:name from em:doc works


<?xml version="1.0" encoding="UTF-8"?>
<!– Definition of new Model –>
<model name="em:eventmodel" xmlns="http://www.alfresco.org/model/dictionary/1.0">
<!– Optional meta-data about the model –>
   <description>ProjectModel</description>
   <author>…</author>
   <version>1.0</version>
<!– Imports are required to allow references to definitions in other models –>
   <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 –>
   <namespaces>
      <namespace uri="http://www.em.com/model/content/1.0" prefix="em"/>
   </namespaces>
   <types>
<!– Enterprise-wide generic document type –>
      <type name="em:emailfolder">
         <title>Email Archive</title>
         <parent>cm:folder</parent>
         <properties>
            <property name="em:emailfolderemailid">
               <type>d:text</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:emailfolderfrom">
               <type>d:text</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:emailfolderto">
               <type>d:text</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:emailfoldersubject">
               <type>d:text</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
         </properties>
         <mandatory-aspects>
            <aspect>cm:titled</aspect>
         </mandatory-aspects>
      </type>
      <type name="em:email">
         <title>Email</title>
         <parent>cm:content</parent>
         <properties>
            <property name="em:emailemailid">
               <type>d:text</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:emailsubject">
               <type>d:text</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:emailfrom">
               <type>d:text</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:emailto">
               <type>d:text</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:emaildate">
               <type>d:datetime</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
         </properties>
         <mandatory-aspects>
            <aspect>cm:titled</aspect>
         </mandatory-aspects>
      </type>
      <type name="em:doc">
         <title>Project Document</title>
         <parent>cm:content</parent>
         <properties>
            <property name="em:doceventid">
               <type>d:text</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:docemailid">
               <type>d:text</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:docProjektleiter">
               <type>d:text</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:docdocID">
               <type>d:text</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:docSales">
               <type>d:text</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:docVAKlasse">
               <type>d:text</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:docVAJahr">
               <type>d:text</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:docmodifier">
               <type>d:text</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:docfileextension">
               <type>d:text</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:docVAKategorie">
               <type>d:text</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:docBeschreibung">
               <type>d:text</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:docMonat">
               <type>d:text</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:docVAStatus">
               <type>d:text</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:docGesamt">
               <type>d:text</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:docCreator">
               <type>d:text</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:docDokumentenklasse">
               <type>d:text</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:docVeranstalterKonto">
               <type>d:text</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:docEinstufung">
               <type>d:text</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:docCreationDate">
               <type>d:datetime</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:docVAAufbau">
               <type>d:datetime</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:docVAAbbau">
               <type>d:datetime</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:docVAStart">
               <type>d:datetime</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:docVAEnde">
               <type>d:datetime</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:docModified">
               <type>d:datetime</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            
         </properties>
         <mandatory-aspects>
            <aspect>cm:titled</aspect>
         </mandatory-aspects>
      </type>
      <type name="em:eventfolder">
         <title>Event Folder</title>
         <parent>cm:folder</parent>
         <properties>
            <property name="em:eventfoldereventid">
               <type>d:text</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:eventfolderVAKategorie">
               <type>d:text</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:eventfolderprojektleiter">
               <type>d:text</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>&gt;
            <property name="em:eventfolderVAKlasse">
               <type>d:text</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:eventfolderVAStart">
               <type>d:datetime</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:eventfolderVAAufbau">
               <type>d:datetime</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:eventfolderVAAbbau">
               <type>d:datetime</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:eventfolderVAEnde">
               <type>d:datetime</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:eventfolderSales">
               <type>d:text</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:eventfolderGesamt">
               <type>d:text</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:eventfolderVAMonat">
               <type>d:text</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:eventfolderVAJahr">
               <type>d:text</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:eventfolderVeranstalterKonto">
               <type>d:text</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>
            <property name="em:eventfolderVAStatus">
               <type>d:text</type><index enabled="true"><tokenised>false</tokenised></index>
            </property>            
         </properties>
         <mandatory-aspects>
            <aspect>cm:titled</aspect>
         </mandatory-aspects>
      </type>
   </types>
   
</model>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Thanks for your help

Re: CMIS custom type query

kaynezhang — Thu, 29 Aug 2013 15:26:00 GMT

It seems there is noting wrong with your model definition,have you tried to redeploy you model or rebuild your index?
I have deployed you model in my envionment,Both

 Select em:docdocID From em:doc and Select * from em:emailfolder ‍

work well

Re: CMIS custom type query

lukas — Thu, 29 Aug 2013 19:56:00 GMT

Thanks a lot for testing my model.
I have reinstalled Alfreco, now it works

Re: CMIS custom type query

kaynezhang — Fri, 30 Aug 2013 01:31:28 GMT

You are welcome ,good luck.