Hi there,
simple case. I got a table with a VARCHAR2 column. This may contain data like "09:5033" and "09:5080", let's call them App-Id.
When i create a Faceted Search report, the facet for this will automatically show the distinct values:
APP-ID
[ ] 09:5033
[ ] 09:5080
Well thats great so far. All other facet filters work excellent.
But, when choosing one entry in the APP-ID facet will bring up nothing but a no data found. The current facet display on top of the report shows:
in APEX 20.2 - PORTAL [POR x]; USER [ADMIN x]; APP_ID [null x] [null x] / report prints "no data found"
in APEX 21.1 (apex.oracle.com) - no current facets, even though there are selections / report prints "no data found"
If i replace the colon with a full stop and transform the string to "09.5033" the facet search works fine.
Conclusion: The string comparison is expected to compare the entire string with all characters.
But in fact, the search breaks up when identfifying a colon (:) within a string. It seem the search splits this string into two pieces as the current facet display shows: APP-ID [null x] [null x] (instead of expected value APP-ID [09:5033 x]).
Cheers
Stephan