• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Simple Search
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Simple Search


  • Subject: Re: Simple Search
  • From: David Holt <email@hidden>
  • Date: Mon, 17 Jul 2006 14:36:11 -0700

Thanks for the reply Chuck. Your hint about using a derived column was really helpful. I defined it as CONCAT(author,title) which works as expected. I am not sure what the COALESCE function would give me?

David

On 17 Jul 2006, at 9:27 AM, Chuck Hill wrote:

I have never done this, but you should be able to set this up in EOModeler. Add a new Attribute named simpleSearch, make it Derived instead of Column. Define it as
COALESCE( author, '') || COALESCE( title, '')
and mark it as read only. You can get rid of the method below and your existing search should work.


Chuck


On Jul 14, 2006, at 5:03 PM, David Holt wrote:

I am using DisplayGroups which make queries on individual attributes very easy.

I would like to provide a simple search where one text field returns a search on a concatenation of several attributes of the entity. I just tried putting the following code in my EO to try this concept out (title and author are attributes in the entity):

	public String simpleSearch() {
          String author = author();
		String title = title();

		String simpleSearch;

        if ((author != null) && (!author.equals(""))) {
            simpleSearch = author + " " + title;
        }
        else {
            simpleSearch = title;
        }

        return simpleSearch;
    }

When I try and do a queryMatch on the simpleSearch field I get an error:
java.lang.IllegalStateException: sqlStringForKeyValueQualifier: attempt to generate SQL for com.webobjects.eocontrol.EOKeyValueQualifier (simpleSearch caseinsensitivelike '*test*') failed because attribute identified by key 'simpleSearch' was not reachable from from entity 'Document'


I assume this is because the attribute "simpleSearch" is not actually in the database. Is there a better strategy for searching concatenated fields using DisplayGroups?

Thanks,
David


_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40global-village.net


This email sent to email@hidden

--
Coming sometime... - an introduction to web applications using WebObjects and Xcode http://www.global-village.net/wointro


Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems. http://www.global-village.net/products/ practical_webobjects





_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (email@hidden) Help/Unsubscribe/Update your Subscription: This email sent to email@hidden
  • Follow-Ups:
    • Re: Simple Search
      • From: Chuck Hill <email@hidden>
References: 
 >Simple Search (From: David Holt <email@hidden>)
 >Re: Simple Search (From: Chuck Hill <email@hidden>)

  • Prev by Date: Framework build fails on network home directory
  • Next by Date: Re: Simple Search
  • Previous by thread: Re: Simple Search
  • Next by thread: Re: Simple Search
  • Index(es):
    • Date
    • Thread