Grouper Developers Forum

[Tom Zeller <>]

It seems to make sense to use like instead of =, leaving wildcards to the caller.

I guess I need findAllByCaseInsensitiveAttr.

Should there be a way to execute an arbitrary hql or sql statement ?

On Mon, Feb 23, 2009 at 12:18 PM, Chris Hyzer <> wrote:

I wonder if it would be confusing if findGroupByAttr just used "like" instead of "=", so if you don't pass in wildcards, you get by attr, and if you pass in wildcards, it would do the right thing…  just trying to avoid too many overloads… maybe other methods could benefit by this too…

 

Chris

 

From: [mailto:] On Behalf Of Tom Zeller
Sent: Monday, February 23, 2009 1:14 PM
To: Grouper Dev
Subject: [grouper-dev] findAllByApproximateAttr ?

 

Would it make sense to provide a method like Hib3GroupDAO.findAllByApproximateAttr() that doesn't surround the attribute value with wildcards ? Or perhaps a boolean arg to turn off the wildcards ?

 

Instead of

 

.setString( "value", "%" + val.toLowerCase() + "%" )

 

just

 

.setString( "value", val.toLowerCase() )

 

I'm interested because I'd like to search for case-insensitive group names and partial case-insensitive group mail addresses (value like "mailLHS@%") in order to force uniqueness of our naming conventions.

 

Thanks,

TomZ