Is it possible to compare property values using the fts (or cmis) query language? I have tried the following:
{ "query": { "query": "TYPE:'my:type' AND (cm:name != my:prop)", "language": "afts" }, "include": ["properties"], "paging": { "maxItems": "1000", "skipCount": "0" } }
And :
{ "query": { "query": "SELECT * FROM my:type WHERE my:prop IS NOT NULL AND my:prop <> cm:name", "language": "cmis" }, "include": ["properties"], "paging": { "maxItems": "1000", "skipCount": "0" } }
AFTS on SOLR could theoretically support something like this using conditions with query functions, but you could very likely not use the short prefix names, which need translation to proper field names by Alfresco, and likely only work in those "typical" and supported use cases of regular searches.
CMIS QL should support this as column references can be used on either side of an operator. Though of course you cannot use cm:name and have to use cmis:name, and obviously have to deal with table aliases when doing joins on aspects and stuff.
In any case, I seriously doubt anyone else has every tried any of those approaches. My money is on "FTS = no way", and "CMIS = maybe if you correct your query"
Ask for and offer help to other Alfresco Content Services Users and members of the Alfresco team.
Related links:
By using this site, you are agreeing to allow us to collect and use cookies as outlined in Alfresco’s Cookie Statement and Terms of Use (and you have a legitimate interest in Alfresco and our products, authorizing us to contact you in such methods). If you are not ok with these terms, please do not use this website.