CMISql can't retrieve properties of custom type

__3 — Fri, 24 Feb 2017 12:59:00 GMT

Hi there!

This questien is connected to question here: https://answers.nuxeo.com/general/q/dd5e7c4e1a5f4a3187eb8196af824ffb/NXQL-Cast-string-column-to-integ I would like to ask why some(not all) of my custom properties in custom types can't be retrieved. Let's say I have document in Nuxeo with my custom type (customType) having my custom property (customProperty). And altough I can see it in nuxeo IDE, my cmisql query can't see it. So if I execute such query:

SELECT customProperty FROM customType WHERE customProperty IS NOT NULL

i got empty results, but I would think that I will have at least one result of document which I see in Nuxeo IDE. (IS NULL returns all results)

And however one customType (the one i need) can't be seen in this queries the other one (eg. customProperty2) is available.

Regards, Michal Wochnik

Re: CMISql can't retrieve properties of custom type

Florent_Guillau — Fri, 24 Feb 2017 13:01:59 GMT

We'd need a more concrete example with the exact query used and the actual schemas (XSD) and document-type/schema definition (XML).

topic Re: CMISql can't retrieve properties of custom type in Nuxeo Forum

CMISql can't retrieve properties of custom type

Re: CMISql can't retrieve properties of custom type