Re: Searching on an Attributes Substring
Jon Nolan <[email protected]>
| Newsgroups | gmane.comp.web.webobjects.devel |
|---|---|
| Message-ID | <[email protected]> |
Jeff,
Not in fetch spec syntax but you'll get the idea.
new EOKeyValueQualifier("myStringAttribute", EOQualifier.QualifierOperatorCaseInsensitiveLike, "*" + value + "*");
Be sure your DB is up to the task though. It can get hairy depending on a myriad of things.
Jon
Jeff Dunnett wrote:
> Hello,
>
> I know that most DBMS have the SUBSTRING function that allows you to
> search substrings. I have an attribute that is an NSString and would
> like to search on a substring of that attribute as part of a fetch
> specification. Is this possible using EOModeler or manually building
> the fetch specification? Is this possible or is using the SUBSTRING
> function in raw SQL the way to go?
>
> Regards,
> Jeff
> _______________________________________________
> WebObjects-dev mailing list
> [email protected]
> http://www.omnigroup.com/mailman/listinfo/webobjects-dev
>