[GLASSFISH-3628] Function REPLACE in named-query Created: 19/Sep/07  Updated: 06/Mar/12

Status: Open
Project: glassfish
Component/s: entity-persistence
Affects Version/s: 9.1peur1
Fix Version/s: not determined

Type: Improvement Priority: Blocker
Reporter: laurentapo Assignee: tware
Resolution: Unresolved Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Operating System: All
Platform: All


Issuezilla Id: 3,628

 Description   

Hello,

Currently, in named-query, functions avaliable on string are : CONCAT,
SUBSTRING, TRIM, LOWER, UPPER, LENGTH, LOCATE.

Function REPLACE don't exist.

We must use named-native-query if you want to replace caracter.

I need this function to search case insensitive and without accent.

For example:
DépAssà => depassa

With existing functions, I can only use LOWER funtion but it not convert accent.

Thanks Laurent



 Comments   
Comment by Tom Mueller [ 06/Mar/12 ]

Bulk change to set fix version to "not determined" where the issue is open but the value is for a released version.

Generated at Fri Jul 03 21:16:42 UTC 2015 using JIRA 6.2.3#6260-sha1:63ef1d6dac3f4f4d7db4c1effd405ba38ccdc558.