Dear sirs,
The ACS API has a serious bug that does not allow us search using the equals operator when the column type is Boolean, UUID or EUID. It is a serious API inconsistency, once the result returns empty even when you have records matching the criteria. A workaround is to use the "Contains" operator, but it's dangerous and may bring some unexpected results.
This problems seems to be caused by the com.adobe.adept.util.PredicateUtil, line 177, due the lack of use of the method "SQLTextUtil.getSearchableFieldExpression" that makes the "Contains", "StartsWith" and "EndsWith" work for the previously cited cases.
Do you know whether there is any prevision to fix this bug?
Thanks in advance,
Marcos
AdChoices