What is the syntax for a full query for IS_IN_DB?
In the example below, user's default email address is selected from a group
all users' emails in table PartyEmailIntersection.
I only want that user's emails to appear in the drop down selection list,
not all emails.
1. All emails are in table Email.
2. All users are in table Party.
4. All of the above emails are associated with their users in table
PartyEmailIntersection.
5. PartyDefaultInfo table keeps contains users' default email address. So
a user can have many emails in PartyEmailIntersection table, and I want
only that user's emails to appear in the drop-down selection, when
populating PartyDefaultInfo table. Do not want to see all users' emails in
the drop-down list.
This IS_IN_DB validator works but offers a drop down of everyone's email
address.
db.PartyDefaultInfo.defaultEMailAddressID.requires = IS_IN_DB(db, db.
PartyEmailIntersection.id, '%(eMailAddressID)s',zero=T('choose one'))
What is the syntax for limiting drop-down list to only the user's emails
(of which there are several)?
thanks,
Alex Glaros
##
---------------------------------------------------------------------------------------------
db.define_table('Party', ## super-type for people and organizations
Field('partyTypeID','reference PartyType'),
Field('displayName','string'))
##
---------------------------------------------------------------------------------------------
db.define_table('Email', ## A single person or organization can have many
emails. Centralized location of all emails. Unique; no duplicates allowed.
Field('eMailAddress','string'),
Field('eMailTitle','string')) ## e.g., “main email for Alex”, or “help
desk email address for Dept. of Motor Vehicles”
##
---------------------------------------------------------------------------------------------
db.define_table('PartyEmailIntersection', ## A single person or
organization can have many emails
Field('partyID','reference Party'),
Field('eMailAddressID','reference Email'))
##
---------------------------------------------------------------------------------------------
db.define_table('PartyDefaultInfo',
Field('partyID','reference Party'),
Field('defaultEMailAddressID','reference Email'))
##
---------------------------------------------------------------------------------------------
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
