[
https://jira.nuxeo.org/browse/NXP-6172?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mariana Cedica updated NXP-6172:
--------------------------------
Status: Open (was: Triage)
> Problem with hierarchical vocabulary on Oracle
> -----------------------------------------------
>
> Key: NXP-6172
> URL: https://jira.nuxeo.org/browse/NXP-6172
> Project: Nuxeo Enterprise Platform
> Issue Type: Bug
> Components: Directory
> Affects Versions: 5.4.0.1
> Reporter: Mariana Cedica
> Priority: Major
> Fix For: 5.4.1
>
>
> When creating/editing documents having a layout widget bound to a
> hierarchical vocabulary, the values from the vocabulary are not displayed.
> For the values in the vocabulary considered as parents, the parent is empty.
> In this case, on an Oracle database, in the corresponding table the "parent"
> field is null.
> So a query like :
> select * from "studio_hierarchical_vocabulary" where "obsolete" = 0 AND
> "parent" = "" order by "ordering" asc,"id" asc
> doesn't return anything . ( Note that zero-length identifier are illegal in
> Oracle).
> The fix for Oracle is to change this to : AND "parent" IS NULL .
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.nuxeo.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
ECM-tickets mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
