invalid column name in vocabulary mapping

pibou_Bouvret — Tue, 03 May 2016 07:23:52 GMT

I have the following columns in a view

id	VARCHAR2(40)
exercice	VARCHAR2(40)
label	VARCHAR2(40)
ordering	NUMBER
obsolete	NUMBER
comm_reference	VARCHAR2(50)
comm_libelle	VARCHAR2(500)
comm_date_creation	VARCHAR2(19)
utilisateur	VARCHAR2(50)

that I try to map to a vocabulary based on the following schema

> <xs:element name="id" type="xs:string"/>
> <xs:element name="exercice" 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:element name="comm_reference" type="xs:string"/>
> <xs:element name="comm_libelle" type="xs:string"/>
> <xs:element name="comm_date" type="xs:string"/>
> <xs:element name="comm_date_creation" type="xs:string"/>
> <xs:element name="utilisateur" type="xs:string"/>

Querying the view / vocabulary seems okay :

SELECT * FROM "STUDIO_VOCABULARY_COMMANDE" WHERE "utilisateur" = 'XXX' AND "obsolete" = 0 AND LOWER("label") LIKE '1999%' Note : I have a custom operation based on Directory.SuggestEntries that adds the "utilisateur" = 'XXX' part of the query.

But it is followed by a java.sql.SQLException about an invalid column name http://pastebin.com/StLQpkfC I supposed there is something wrong with the mapping but what ?

Re: invalid column name in vocabulary mapping

pibou_Bouvret — Tue, 03 May 2016 09:56:00 GMT

Silly problem : comm_date was referenced in the schema and not present in the view

topic invalid column name in vocabulary mapping in Nuxeo Forum

invalid column name in vocabulary mapping

Re: invalid column name in vocabulary mapping