Re: [GNUe] foreign key question

[Reinhard Mueller]

Am Die, den 08.06.2004 schrieb address@hidden um 1:17:
> I'd like to offer a dropdown list to the user with a subset of the
> employees table records made with those ones that are indirectly linked
> to a known (constant condition) org record, with dept intermediate
> record (may be others conditions, but the one I've worried just now is
> this).

We had a quite similar problem in our hotline form and we were able to
solve it with appserver - with these indirect properties
(foo.bar.baz...)

> The org record definition has a 'nick' field, but org record isn't a
> 'user' record. What the user sees is a customer record, a provider
> record, or a shipping operator one.
> 
> I'd like that, when the user is dealing with a customer record, the
> 'nick' (org) field has the focus and (s)he strokes up/down keys,
> navigates into customer records. I've solved the cuestion adding a
> type field to org records but I wonder if there is a way to do
> something like that without org table knowing about the class of record
> that is actually linking to one of its ones.

I'm sorry but I can't follow you here.

> El lun, jun 07, a las 22:22:24 Reinhard Mueller escribía:
> > Am Mon, den 07.06.2004 schrieb address@hidden um 21:27:
> > > I have an issue where a form record needs to hold the key of an employee
> > > belonging to a known org, but, as said before, employee records are linked
> > > to dept records, that are linked to org records. That is, there isn't an
> > > employee field that directly links to an org record. Is there a way for
> > > doing that kind of thing without re-structuring data?
> > 
> > Using appserver, you could access the org of an employee as a field
> > named "dept.org". You could filter by that, sort by that, or display it.
> > You could even display a field named "dept.org.name", if the org_org
> > table has a field "name".
> 
> This sounds like what I am looking for. How could this be done? By mean of
> a 'virtual' or mediated datasource from gnue-form point of view?

No. By means of nothing. Just add a condition on the "dept.org" field of
the employee datasource. You can play as if the employee table really
had a field named "dept.org". Appserver will do all joins and everything
automagically. No extra action required.

> > However, I'm not sure if you are using appserver with this application.

> Not, I'm not still using appserver. It seems appserver is being heavily
> developed just now, and I have a lot of things to do with my app and a
> lot of them to learn about GNUe, out of appserver, so I'm trying to
> advance as much as I can do without appserver in both ways, the app
> and my knowledge.

That's ok :-)

Thanks,
-- 
Reinhard Mueller
GNU Enterprise project
http://www.gnue.org
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
No army can stop an idea whose time has come.
        -- Victor Hugo, 1802-1885

signature.asc
Description: Dies ist ein digital signierter Nachrichtenteil