June 24, 2008 at 1:47 pm
The Tables :
Contacts
ProductList
BundleList
All 3 tables have SiteID which is not null, and is the same in all 3 tables.
The Criteria:
1. The client (Site) needs to be a current user. All Sites have a unique SiteId.
2. A current user will have (a) Product(s) and/or Bundle(s). This information is in the BundleList table for Bundles and the ProductList table for Products.
3. The BundleList must have a BundleType of "1" (Content) .
4. The BundleList must have a Status of "1" (Active).
6. The ProductList must have a ProductType of "1" (Content) .
7. The ProductList must have a Status of "1" (Active).
8. If the Product is Small Project ProductType of "6" it will need a version greater than or equal to 2003 (versions for Small Project are stored as a year like 2005).
9. When you have a list of Current Sites we then need to identify which of these Sites do not have a Valid (registered) WebAdmin Contact.
10. Contacts are stored in the "Contact" Table.
11. A site can have multiple contacts and each contact has a type determined by the "ContentType".
12. If a Site has a valid (registered) WebAdmin contact they will have a a Contact in the "Content" table with a ContentType of "WebAdmin." and the record will have a real email address that IS NOT "UNREG_USER" or NULL.
13. If a current Site does not have a valid WebAdmin Contact and we know every Site has a "Ship To" Contact in the "Contact" Table, we can use this information to contact the client (Site).
14. Site information can be found in the "Site" Table identified by SiteID.
June 24, 2008 at 2:24 pm
And what are your questions?
June 25, 2008 at 12:55 pm
Hi Buddy,
Please post your questions, are you expecting us to Post Questions your criteria :P:D
Thanks -- Vj
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply