Standard caveat:
I'm fairly new to WO, and while I've learned quite a bit in the last few
weeks as I have spare moments, I'm probably still as likely to ask stupid
questions as good ones. I'm doing my work pretty much entirely in Java, and
I don't know much about Objective-C or WebScript. I'm using WO 4.0, in case
that wasn't clear.
Question:
How the heck do I make an EOQualifier across a relationship? I'll use the
example I'm working with, simplified: I have a table of rates that can be
applied to particular companies at particular dates. I want to filter the
display group based on the company. Reasonable enough, right? So I begin
to make an EOQualifier. But then it occurs to me that I have no idea how to
actually go about it in this case, since I want to filter it based on a
relationship.
Were I using pure SQL and ASP, I could just grab the primary key for the
company in question and filter the rates based on the primary key. However,
in EOModeller, I've not made the pri key or the foreign key class
properties, since they have no meaning other than maintaining the
relationship. This makes sense, of course, but it doesn't help me with my
problem.
So, let's say, for the sake of having terms to work with, I have a Rates
table/object with a toCompany relationship defined based on the
non-class-property "companyID" and a Companies table whose primary key is
companyID. I have a display group called dgRates which is connected to the
rates table, and I want to qualify it based on a the users's company, which
is known coming into the page. Where do I go from here?
Thanks,
- Geoffrey
--
Geoffrey Wiseman,
New Media Developer, Medium One Productions
[EMAIL PROTECTED] http://www.mediumone.com/ (416)361-2030
"here is little effie's head whose brains are made of gingerbread"
