I am trying to execute a CMIS query and am having trouble with spaces in the queries. One of our Template names is 'Master Folder Document'. I am trying to query documents that have that template name. I have tried
SELECT * FROM cmis:document WHERE lf:templateName = 'Master%20Folder%20Document'
which returns no documents (which is incorrect)
and
SELECT * FROM cmis:document WHERE lf:templateName = 'Master Folder Document'
which gives me a bad query error. One of the template field names is 'Part Number' and I have successfully queried that by using the following:
SELECT * FROM cmis:document WHERE lf:fields.field:Part%20Number = 'apartnumber'
so it seems there is some inconsistency in how the CMIS query language handles spaces. How do I get the first query to work ?