Re: Need help building an EOQualifier with session values

Sun, 21 May 2006 06:51:34 -0700

Reid,

Just so I understand what you want to do - you're trying to fetch Process records from the database for the client, right?

My first question is, since you say you have a client object, why are you using the clientName instead of the client object?  You should really have a relationship in Process called 'client', which is a relationship to the Client entity based on the name (or better, a unique integer primary key so the client's name can change without breaking the database).

To address your specific question, are you sure that user.client.clientName is getting the result you want?  Have you tried:

System.out.println("Client name is "+session().valueForKey("user.client.clientName"));

Otherwise, if Process has an attribute called 'clientName' that matches the clientName in the client object, this code should work.  It would help if you gave more information about the model...

Ken

On May 21, 2006, at 5:06 AM, Reid Bundonis wrote:

All,

Forgive me for asking what should be obvious (it is the weekend and I left the books at the office, I am a new dad which equals no sleep and brain dead, and the dog ate my homework).  

I am trying to construct an EOQualifier to grab a value from the session store and use that in its search.  For example, I have entities: User, Client, Process & Result.  When the user logs in, they are stored in the session so I can extract stuff about them later on.  This is simple using WOString and the session.user.client.<key> binding.  However, for what ever reason, I can not wrap my empty head around how to call a value from the session and use it for a search.  As an example, there is a user Bob, that is a member of Pretend Co., and has three processes, Run, Spin, & Sit.  These processes have results.  When Bob logs in, I know all about him since he is now in the session store and I can pull values about him throughout the app.  However, I want to build a qualifier with string values from the session store so I can do searches, such as Bob logs in and in the super I request the user's client name from the session and use it in a qualifier to search for all processes related to that client.

For simplicity, I am working in Main and have confirmed that I can access the session store by using WOString and viewing values from the logged user.  Now, I want to create a search that will pull results of Process using the User's Client.  Usually, I just use a bindings with valueForKey and toss it at the qualifier.  But that is for entities in the db.  However, I am not sure how to code the session request.  In my brain it would be something like:


NSArray bindings = new NSArray( new Object [] { (Session)session().valueForKey("user.client.clientName") } );


qual = EOQualifier.qualifierWithQualifierFormat("clientName = %@", bindings );

       

    fs = new EOFetchSpecification("Process", qual, null);

Obviously, that does not work.  If anyone can point a confused session using newbie in the right direction I would appreciate it.  Hope all are enjoying the weekend.  Thanks in advance.

R- _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:

This email sent to [EMAIL PROTECTED]

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to