As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.
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
We'd need a more concrete example with the exact query used and the actual schemas (XSD) and document-type/schema definition (XML).
