#348 Alfresco Lucene Equals Queries

[George Steimer]

NOTE - this is more of an OC bug, but it affects the wizard in a number of ways. In the current Alfresco code, running an equals query actually behaves more like a LIKE query. This has to do with how Alfresco Lucene queries work. For example, if you run a query that's something like "give me all page set objects where page_set_name is equal to Change Request", this actually will match 'Change Request' AND 'Simple Change Request' This error has manifested it self in two places so far:

1) Create two page sets, one called Change Request and another called Simple Change Request. Attempt to create a PSI for each. Change Request will fail because the OC code unexpectedly gets two results instead of one.
2) Create a query called 'Wizard Users in Group'. Attempt to create another query called 'Users in Group'. The admin will say that the query name already exists. Since the query "get queries with name 'Users in Group'" returns the Wizard Users in Group query, the code incorrectly thinks that the name already exists.

Fixing the issue can be done one of two ways:

1) PREFERABLY - figure out how to get this to work correctly with Lucene queries in Alfresco. Basically, return the results as we would expect. Perhaps there is a way to have OC put some characters in the query or format it a certain way to get this to work right?
2) LAST RESORT - manually filter the results in OC before returning the query. This would be doable, but could get pretty complex for queries that use a combination of ANDs and ORs and multiple attributes.