asked on April 7, 2020

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 ?

3 0