Hello, I managed to integrate fields from a custom document in the advanced search. If I search for one field it seems to work quite fine, but if I search for two fields I get the above postgreSQL error.
Does anybody have any idea what's wrong?
I attached all the files from my jar which I think correspond to the advanced
search, I am very new to Nuxeo and hope someone will be able to help me out,
best regards
Raimund
-
RunSolutions
Open Source It Consulting
-
Email: [email protected]
Parc Bit - Centro Empresarial Son Espanyol
Edificio Estel - Local 3D
07121 - Palma de Mallorca
Baleares
----- Mensaje original -----
> Send ECM mailing list submissions to
> [email protected]
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://lists.nuxeo.com/mailman/listinfo/ecm
> or, via email, send a message with subject or body 'help' to
> [email protected]
>
> You can reach the person managing the list at
> [email protected]
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of ECM digest..."
>
>
> Today's Topics:
>
> 1. Re: Proposal for better Relations support in Nuxeo
> ([email protected])
> 2. Re: Proposal for better Relations support in Nuxeo (Kjetil Nyg?rd)
> 3. Re: Proposal for better Relations support in Nuxeo
> ([email protected])
> 4. Error: ..does not have the required schema: vocabulary or
> xvocabulary ([email protected])
> 5. Re: Proposal for better Relations support in Nuxeo
> ([email protected])
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Fri, 20 Aug 2010 14:12:05 +0200
> From: <[email protected]>
> Subject: Re: [Ecm] Proposal for better Relations support in Nuxeo
> To: [email protected]
> Cc: [email protected]
> Message-ID:
> <[email protected]>
> Content-Type: text/plain; charset="UTF-8"
>
> AFAIK, there's a reflexion in Nuxeo about embedding the relation
> system
> into the VCS (like they did with the tagging system in 5.3.2). This
> means the relation system will be really held in the same DB as the
> repository, allowing NXQL query to query on relations for instance.
>
>
> But I don't really know where it is now....
>
> Le vendredi 20 ao?t 2010 ? 11:52 +0000, [email protected] a
> ?crit :
> > After looking more into this, I found out that the sourceId changes
> > when I publish a new version of the document. Therefore my SQL-View
> > does not work.
> >
> > I will try to add an Uid to the document, and relate to this
> > instead.
> >
> > Anyways, I would like to know if there is some thoughts on this in
> > Nuxeo allready.
> > --
> > Posted by "kjetilny" at Nuxeo Discussions
> > <http://nuxeo.org/discussions>
> > View the complete thread:
> > <http://www.nuxeo.org/discussions/thread.jspa?threadID=4003#12294>
> > _______________________________________________
> > ECM mailing list
> > [email protected]
> > http://lists.nuxeo.com/mailman/listinfo/ecm
> > To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
>
>
>
>
> Ce message et toutes les pi?ces jointes sont ?tablis ? l'attention
> exclusive de leurs destinataires et sont confidentiels. Si vous
> recevez ce message par erreur, merci de le d?truire et d'en avertir
> imm?diatement l'exp?diteur. L'internet ne permettant pas d'assurer
> l'int?grit? de ce message, le contenu de ce message ne repr?sente en
> aucun cas un engagement de la part de Leroy Merlin.
>
>
>
> ------------------------------
>
> Message: 2
> Date: Fri, 20 Aug 2010 14:38:20 +0200
> From: Kjetil Nyg?rd <[email protected]>
> Subject: Re: [Ecm] Proposal for better Relations support in Nuxeo
> To: [email protected]
> Message-ID: <1282307900.3441.8.ca...@localhost>
> Content-Type: text/plain; charset="utf-8"
>
> Hi,
>
> This sounds good. I have a few questions in relation to this that you
> or
> Nuxeo could maybe answer:
>
> 1. Does this mean that the relations will be native SQL foreign key
> references also?
>
> 2. Will the relations point to a version or the document itself?
> We have a scenario where linking to specific version will create a
> "dependency hell". But I also see the need in some situations to link
> to
> specific versions.
> Will both be supported?
>
>
>
> I personally think that the best part of Nuxeo is the native SQL usage
> in VCS :-)
>
>
> Best regards,
>
> Kjetil Nyg?rd
>
>
>
> On Fri, 2010-08-20 at 14:12 +0200, [email protected]
> wrote:
>
> > AFAIK, there's a reflexion in Nuxeo about embedding the relation
> > system
> > into the VCS (like they did with the tagging system in 5.3.2). This
> > means the relation system will be really held in the same DB as the
> > repository, allowing NXQL query to query on relations for instance.
> >
> >
> > But I don't really know where it is now....
> >
> > Le vendredi 20 ao?t 2010 ? 11:52 +0000, [email protected] a
> > ?crit :
> > > After looking more into this, I found out that the sourceId
> > > changes when I publish a new version of the document. Therefore my
> > > SQL-View does not work.
> > >
> > > I will try to add an Uid to the document, and relate to this
> > > instead.
> > >
> > > Anyways, I would like to know if there is some thoughts on this in
> > > Nuxeo allready.
> > > --
> > > Posted by "kjetilny" at Nuxeo Discussions
> > > <http://nuxeo.org/discussions>
> > > View the complete thread:
> > > <http://www.nuxeo.org/discussions/thread.jspa?threadID=4003#12294>
> > > _______________________________________________
> > > ECM mailing list
> > > [email protected]
> > > http://lists.nuxeo.com/mailman/listinfo/ecm
> > > To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
> >
> >
> >
> >
> > Ce message et toutes les pi?ces jointes sont ?tablis ? l'attention
> > exclusive de leurs destinataires et sont confidentiels. Si vous
> > recevez ce message par erreur, merci de le d?truire et d'en avertir
> > imm?diatement l'exp?diteur. L'internet ne permettant pas d'assurer
> > l'int?grit? de ce message, le contenu de ce message ne repr?sente en
> > aucun cas un engagement de la part de Leroy Merlin.
> >
> > _______________________________________________
> > ECM mailing list
> > [email protected]
> > http://lists.nuxeo.com/mailman/listinfo/ecm
> > To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
>
>
> --
> Med vennlig hilsen
>
> Kjetil Nyg?rd
> [email protected]
> Tlf: +47 41 47 43 37
> MSN: [email protected]
> Skype: pol-pot78
>
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> <http://lists.nuxeo.com/pipermail/ecm/attachments/20100820/da0470b2/attachment.html>
>
> ------------------------------
>
> Message: 3
> Date: Fri, 20 Aug 2010 15:11:57 +0200
> From: <[email protected]>
> Subject: Re: [Ecm] Proposal for better Relations support in Nuxeo
> To: Kjetil Nyg?rd <[email protected]>
> Cc: [email protected]
> Message-ID:
> <[email protected]>
> Content-Type: text/plain; charset="UTF-8"
>
> Le vendredi 20 ao?t 2010 ? 14:38 +0200, Kjetil Nyg?rd a ?crit :
> > Hi,
> >
> > This sounds good. I have a few questions in relation to this that
> > you
> > or Nuxeo could maybe answer:
> >
> > 1. Does this mean that the relations will be native SQL foreign key
> > references also?
>
> For me, it's perhaps not very important. When you deal with documents,
> you deal with the document API, not with SQL. And it can be quite
> dangerous to make some change directly in the SQL db (although i know
> it
> works....)
>
> But, if it's integrated into VCS I don't see any reason to not put
> native sql foreign keys somewhere....
>
> >
> > 2. Will the relations point to a version or the document itself?
> > We have a scenario where linking to specific version will create a
> > "dependency hell". But I also see the need in some situations to
> > link
> > to specific versions.
> > Will both be supported?
>
> I think that Nuxeo needs some real User stories and feedback to work
> on
> the best implementation of relations.
>
> > I personally think that the best part of Nuxeo is the native SQL
> > usage
> > in VCS :-)
>
> I agree !
>
> >
> >
> > Best regards,
> >
> > Kjetil Nyg?rd
> >
> >
> >
> > On Fri, 2010-08-20 at 14:12 +0200, [email protected]
> > wrote:
> > > AFAIK, there's a reflexion in Nuxeo about embedding the relation
> > > system
> > > into the VCS (like they did with the tagging system in 5.3.2).
> > > This
> > > means the relation system will be really held in the same DB as
> > > the
> > > repository, allowing NXQL query to query on relations for
> > > instance.
> > >
> > >
> > > But I don't really know where it is now....
> > >
> > > Le vendredi 20 ao?t 2010 ? 11:52 +0000, [email protected] a
> > > ?crit :
> > > > After looking more into this, I found out that the sourceId
> > > > changes when I publish a new version of the document. Therefore
> > > > my SQL-View does not work.
> > > >
> > > > I will try to add an Uid to the document, and relate to this
> > > > instead.
> > > >
> > > > Anyways, I would like to know if there is some thoughts on this
> > > > in Nuxeo allready.
> > > > --
> > > > Posted by "kjetilny" at Nuxeo Discussions
> > > > <http://nuxeo.org/discussions>
> > > > View the complete thread:
> > > > <http://www.nuxeo.org/discussions/thread.jspa?threadID=4003#12294>
> > > > _______________________________________________
> > > > ECM mailing list
> > > > [email protected]
> > > > http://lists.nuxeo.com/mailman/listinfo/ecm
> > > > To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
> > >
> > >
> > >
> > >
> > > Ce message et toutes les pi?ces jointes sont ?tablis ? l'attention
> > > exclusive de leurs destinataires et sont confidentiels. Si vous
> > > recevez ce message par erreur, merci de le d?truire et d'en
> > > avertir imm?diatement l'exp?diteur. L'internet ne permettant pas
> > > d'assurer l'int?grit? de ce message, le contenu de ce message ne
> > > repr?sente en aucun cas un engagement de la part de Leroy Merlin.
> > >
> > > _______________________________________________
> > > ECM mailing list
> > > [email protected]
> > > http://lists.nuxeo.com/mailman/listinfo/ecm
> > > To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
> >
> > --
> > Med vennlig hilsen
> >
> > Kjetil Nyg?rd
> > [email protected]
> > Tlf: +47 41 47 43 37
> > MSN: [email protected]
> > Skype: pol-pot78
> >
> >
> >
> > _______________________________________________
> > ECM mailing list
> > [email protected]
> > http://lists.nuxeo.com/mailman/listinfo/ecm
> > To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
>
>
>
>
> ------------------------------
>
> Message: 4
> Date: Fri, 20 Aug 2010 16:30:01 CEST
> From: [email protected]
> Subject: [Ecm] Error: ..does not have the required schema: vocabulary
> or xvocabulary
> To: [email protected]
> Message-ID: <[email protected]>
> Content-Type: text/plain; charset=ISO-8859-1
>
> I'm getting this error when I'm trying to create my own virtual
> navigation using a custom vocubulary: document_typesdoes not have the
> required schema: vocabulary or xvocabulary.
>
> Here's what I have in my directories-contrib:
>
> <directory name="document_types">
> <schema>ssl_vocab_doctype</schema>
> <dataSource>java:/nxsqldirectory</dataSource>
> <table>documenttypes</table>
> <idField>ssl_vtype:id</idField>
> <dataFile>directories/ssl_doctypes.csv</dataFile>
> <createTablePolicy>on_missing_columns</createTablePolicy>
> </directory>
>
> Schema:
>
> <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema";
> targetNamespace="http://ecm.shireburn.com/schemas/vdoctype";
> xmlns:ssl_vtype="http://ecm.shireburn.com/schemas/vdoctype";>
>
> <xs:element name="id" type="xs:string" />
> <xs:element name="label" type="xs:string" />
> <xs:element name="obsolete" type="xs:integer" default="0" />
> <xs:element name="ordering" type="xs:integer" default="10000000" />
>
> </xs:schema>
>
> CSV File:
>
> ssl_vtype:id, ssl_vtype:label, ssl_vtype:obsolete
> "1","General","0"
> "2","Accounting","0"
> "3","Freight","0"
> "4","Correspondence","0"
>
> directorytreemanger-contrib:
>
> <directoryTree name="byDocumentTypeNavigation" label="Browsing by
> Document Type"
> querymodel="byDocumentTypeNavQueryModel" field="id"
> schema="ssl_vocab_doctype"
> outcome="doctype_virtual_navigation">
> <directory>document_types</directory>
> </directoryTree>
>
>
> Any idea what might be missing here?
> --
> Posted by "joekiddo" at Nuxeo Discussions
> <http://nuxeo.org/discussions>
> View the complete thread:
> <http://www.nuxeo.org/discussions/thread.jspa?threadID=4008#12298>
>
>
> ------------------------------
>
> Message: 5
> Date: Fri, 20 Aug 2010 18:06:58 CEST
> From: [email protected]
> Subject: Re: [Ecm] Proposal for better Relations support in Nuxeo
> To: [email protected]
> Message-ID: <[email protected]>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Yes, we've been thinking about improving the relation support to be
> mapped directly to SQL relational concepts.
>
> Already in Nuxeo 5.3.2, there is a new Relation document type similar
> to Document, which has two fields (source and target). This type can
> be subclassed, and in Nuxeo 5.3.2 the tags use a Tagging subclass of
> Relation to link a document and a Tag document. Relations are meant to
> be placeless documents, and as they have no place (no parent) they
> can't inherit security, so they should be created only by a superuser
> in an unrestricted session. That's what the tag service does
> internally.
>
> Subtypes or Relation can add new fields, which helps have rich
> relation objects if needed.
>
> In the database we don't yet make source and target foreign keys but
> this may be added later if it's shown to work for all use cases
> (although it will be foreign key to hierarchy.id, not a
> schema-specific table).
>
> For Nuxeo 5.4 we plan to refactor the current relation service that
> uses Jena to internally use this new Relation type instead. This gives
> a general many-to-many relation system that supports rich relations.
>
>
> Your proposal to add a field type that is a relation is interesting,
> and has been already considered, although the restriction on the
> target type is probably a bit too strong to be made generic in Nuxeo.
>
> The second part of your proposal that creates a vocabulary consisting
> of the document ids of a certain type is also interesting, but can
> probably be done by a specialized type of directory instead of using a
> view (views are very database-specific).
>
> Anyway this is all interesting, and rest assured that moving to a
> straightforward SQL relational model is indeed in our goals.
> --
> Posted by "fguillaume" at Nuxeo Discussions
> <http://nuxeo.org/discussions>
> View the complete thread:
> <http://www.nuxeo.org/discussions/thread.jspa?threadID=4003#12299>
>
>
> ------------------------------
>
> _______________________________________________
> ECM mailing list
> [email protected]
> http://lists.nuxeo.com/mailman/listinfo/ecm
>
>
> End of ECM Digest, Vol 52, Issue 24
> ***********************************
search_simpleform.xhtml
Description: application/xhtml
search-service.xml
Description: XML document
querymodel-contrib.xml
Description: XML document
_______________________________________________ ECM mailing list [email protected] http://lists.nuxeo.com/mailman/listinfo/ecm To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
