Return-Path: Delivered-To: apmail-ofbiz-user-archive@www.apache.org Received: (qmail 44190 invoked from network); 10 Aug 2010 23:46:03 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 10 Aug 2010 23:46:03 -0000 Received: (qmail 14030 invoked by uid 500); 10 Aug 2010 23:46:02 -0000 Delivered-To: apmail-ofbiz-user-archive@ofbiz.apache.org Received: (qmail 13993 invoked by uid 500); 10 Aug 2010 23:46:02 -0000 Mailing-List: contact user-help@ofbiz.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@ofbiz.apache.org Delivered-To: mailing list user@ofbiz.apache.org Received: (qmail 13985 invoked by uid 99); 10 Aug 2010 23:46:02 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 10 Aug 2010 23:46:02 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [67.221.226.157] (HELO zimbra.hotwaxmedia.com) (67.221.226.157) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 10 Aug 2010 23:45:55 +0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by zimbra.hotwaxmedia.com (Postfix) with ESMTP id 1576F8C20006 for ; Tue, 10 Aug 2010 18:45:35 -0500 (CDT) X-Virus-Scanned: amavisd-new at zimbra.hotwaxmedia.com Received: from zimbra.hotwaxmedia.com ([127.0.0.1]) by localhost (zimbra.hotwaxmedia.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id Cs6x0LscB8pu for ; Tue, 10 Aug 2010 18:45:30 -0500 (CDT) Received: from hwm-scott.lan (unknown [222.155.244.79]) by zimbra.hotwaxmedia.com (Postfix) with ESMTP id 88CAB8C20001 for ; Tue, 10 Aug 2010 18:45:29 -0500 (CDT) From: Scott Gray Mime-Version: 1.0 (Apple Message framework v1081) Content-Type: multipart/signed; boundary=Apple-Mail-15-381530700; protocol="application/pkcs7-signature"; micalg=sha1 Subject: Re: About ProductFeatureCategoryAppl and ProductFeatureCatGrpAppl Date: Wed, 11 Aug 2010 11:45:24 +1200 In-Reply-To: <1281466311.6073.146.camel@miles-laptop> To: user@ofbiz.apache.org References: <1281463304208-2320190.post@n4.nabble.com> <4C619620.7010208@free-man.net> <1281466311.6073.146.camel@miles-laptop> Message-Id: <8136B589-2BAE-4495-AB19-9DDD0B4EA243@hotwaxmedia.com> X-Mailer: Apple Mail (2.1081) --Apple-Mail-15-381530700 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Hi Miles, I don't use it often but I believe the associations are currently pretty = much only used by the product search functionality. If you choose to = search within a given category and that category has features associated = with it then they will be displayed as selectable filtering options on = the search form. Regards Scott HotWax Media http://www.hotwaxmedia.com On 11/08/2010, at 6:51 AM, huang.miles@gmail.com wrote: > Hi BJ, >=20 > Thank for your quick reply. >=20 > I understand that in OFBIZ we can use an "Appl" table to implement = the > n:m relationship technically. >=20 > What I don't understand is the business level design of these two > relations: What's the purpose to associate a product feature category = or > group to a product category? I haven't find anywhere can use these > relationships. >=20 > Thanks, > Miles >=20 >=20 > On Tue, 2010-08-10 at 11:10 -0700, BJ Freeman wrote: >=20 >> *Appl is usually to have many to many relationships >>=20 >>=20 >> miles sent the following on 8/10/2010 11:01 AM: >>>=20 >>> Hi, >>> I'm relative new to OFBIZ and has worked on it for several months. = I've >>> understand the product feature applying to product to setup = virtual/variant >>> products. >>>=20 >>> But what's the purpose of ProductFeatureCategoryAppl and >>> ProductFeatureCatGrpAppl design? I can associate a product feature = category >>> or product feature group to product categories. But I can't find any = effect >>> on doing this, either in documentation or by hand-on experiment. I = may >>> missed something. Can any one explain the purpose of such = operations? >>>=20 >>> Thanks, >>> Miles. >=20 >=20 --Apple-Mail-15-381530700 Content-Disposition: attachment; filename=smime.p7s Content-Type: application/pkcs7-signature; name=smime.p7s Content-Transfer-Encoding: base64 MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIGPTCCBjkw ggUhoAMCAQICEQDYl7EXGWhQIpBs19Ozq1G2MA0GCSqGSIb3DQEBBQUAMIGuMQswCQYDVQQGEwJV UzELMAkGA1UECBMCVVQxFzAVBgNVBAcTDlNhbHQgTGFrZSBDaXR5MR4wHAYDVQQKExVUaGUgVVNF UlRSVVNUIE5ldHdvcmsxITAfBgNVBAsTGGh0dHA6Ly93d3cudXNlcnRydXN0LmNvbTE2MDQGA1UE AxMtVVROLVVTRVJGaXJzdC1DbGllbnQgQXV0aGVudGljYXRpb24gYW5kIEVtYWlsMB4XDTA5MTAx NDAwMDAwMFoXDTEwMTAxNDIzNTk1OVowgeAxNTAzBgNVBAsTLENvbW9kbyBUcnVzdCBOZXR3b3Jr IC0gUEVSU09OQSBOT1QgVkFMSURBVEVEMUYwRAYDVQQLEz1UZXJtcyBhbmQgQ29uZGl0aW9ucyBv ZiB1c2U6IGh0dHA6Ly93d3cuY29tb2RvLm5ldC9yZXBvc2l0b3J5MR8wHQYDVQQLExYoYykyMDAz IENvbW9kbyBMaW1pdGVkMRMwEQYDVQQDEwpTY290dCBHcmF5MSkwJwYJKoZIhvcNAQkBFhpzY290 dC5ncmF5QGhvdHdheG1lZGlhLmNvbTCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBALNA v8gB9OAet+B7Pm6SjpVHtavdj8RO5h75hmqYIu4gMhQmU/AJYL/pVddK85VQOMtJyngDvlKvlH5v Xc8HwLyM3IsfrxrNzZ6mbwM1eU2BbISYMzB5BmDjieLe6xQ7sQBKPV3cSZbTAyDPs5qm/mj3jDBH ynz5sSKcHDEvTAmubpD28mnROOSqIstApC8enFr/zMCMofL85DxOkqOjJlX0xUdvOrTaKqfk1Sej ZJtSg0gZ5M2Tkfah/2/ALGVXKSh3cceHwuP3yMvv/uYllQZBRZiHehvTBP6qEENNxYC1LN4Zg/YD h4+MieK2vMENUiv4qfrR5JKkaAl8A7EyI68CAwEAAaOCAhwwggIYMB8GA1UdIwQYMBaAFImCZ33E nSZwAEu0UEh83j2uBG59MB0GA1UdDgQWBBSuGHgRPxvu0/VVHM/UmH0tUUO2sDAOBgNVHQ8BAf8E BAMCBaAwDAYDVR0TAQH/BAIwADAgBgNVHSUEGTAXBggrBgEFBQcDBAYLKwYBBAGyMQEDBQIwEQYJ YIZIAYb4QgEBBAQDAgUgMEYGA1UdIAQ/MD0wOwYMKwYBBAGyMQECAQEBMCswKQYIKwYBBQUHAgEW HWh0dHBzOi8vc2VjdXJlLmNvbW9kby5uZXQvQ1BTMIGlBgNVHR8EgZ0wgZowTKBKoEiGRmh0dHA6 Ly9jcmwuY29tb2RvY2EuY29tL1VUTi1VU0VSRmlyc3QtQ2xpZW50QXV0aGVudGljYXRpb25hbmRF bWFpbC5jcmwwSqBIoEaGRGh0dHA6Ly9jcmwuY29tb2RvLm5ldC9VVE4tVVNFUkZpcnN0LUNsaWVu dEF1dGhlbnRpY2F0aW9uYW5kRW1haWwuY3JsMGwGCCsGAQUFBwEBBGAwXjA2BggrBgEFBQcwAoYq aHR0cDovL2NydC5jb21vZG9jYS5jb20vVVROQUFBQ2xpZW50Q0EuY3J0MCQGCCsGAQUFBzABhhho dHRwOi8vb2NzcC5jb21vZG9jYS5jb20wJQYDVR0RBB4wHIEac2NvdHQuZ3JheUBob3R3YXhtZWRp YS5jb20wDQYJKoZIhvcNAQEFBQADggEBAJ6ziClX9Dz6y35D8yjDqnEcoBrkbWPMekTFuMBI8j7O Wzz9ADIon1wgWGAuDKkaDi/RixEsx8WlESbcJX15egqICh09KtzjNg3G6IFHFtZH7Lkl9VX0zrS2 T409wyVWUEekBFnIKVuTwhNazsILn8nlwEWN0EoAziDNutlOH5F+G17139oMi2OfY9qK5HUn9VcV XCy72LeCo/ABtZRBnr12FaT6V6mfWwBvS35NTpJOWPS0/mEuS3+gQcOxA3Q+eNhbAj8+TQ6j41uA sg7Oxe36WPLgtIyDEk5MRaFBZnokkEo2m+QVfq4a4acYiX6veJ+dxDNSzLwbP+G+IYCXAUgxggP/ MIID+wIBATCBxDCBrjELMAkGA1UEBhMCVVMxCzAJBgNVBAgTAlVUMRcwFQYDVQQHEw5TYWx0IExh a2UgQ2l0eTEeMBwGA1UEChMVVGhlIFVTRVJUUlVTVCBOZXR3b3JrMSEwHwYDVQQLExhodHRwOi8v d3d3LnVzZXJ0cnVzdC5jb20xNjA0BgNVBAMTLVVUTi1VU0VSRmlyc3QtQ2xpZW50IEF1dGhlbnRp Y2F0aW9uIGFuZCBFbWFpbAIRANiXsRcZaFAikGzX07OrUbYwCQYFKw4DAhoFAKCCAg8wGAYJKoZI hvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMTAwODEwMjM0NTI1WjAjBgkqhkiG 9w0BCQQxFgQUw/FeA9j06DCSzaigmy/Wrik8fK4wgdUGCSsGAQQBgjcQBDGBxzCBxDCBrjELMAkG A1UEBhMCVVMxCzAJBgNVBAgTAlVUMRcwFQYDVQQHEw5TYWx0IExha2UgQ2l0eTEeMBwGA1UEChMV VGhlIFVTRVJUUlVTVCBOZXR3b3JrMSEwHwYDVQQLExhodHRwOi8vd3d3LnVzZXJ0cnVzdC5jb20x NjA0BgNVBAMTLVVUTi1VU0VSRmlyc3QtQ2xpZW50IEF1dGhlbnRpY2F0aW9uIGFuZCBFbWFpbAIR ANiXsRcZaFAikGzX07OrUbYwgdcGCyqGSIb3DQEJEAILMYHHoIHEMIGuMQswCQYDVQQGEwJVUzEL MAkGA1UECBMCVVQxFzAVBgNVBAcTDlNhbHQgTGFrZSBDaXR5MR4wHAYDVQQKExVUaGUgVVNFUlRS VVNUIE5ldHdvcmsxITAfBgNVBAsTGGh0dHA6Ly93d3cudXNlcnRydXN0LmNvbTE2MDQGA1UEAxMt VVROLVVTRVJGaXJzdC1DbGllbnQgQXV0aGVudGljYXRpb24gYW5kIEVtYWlsAhEA2JexFxloUCKQ bNfTs6tRtjANBgkqhkiG9w0BAQEFAASCAQBg6S3MTIpvdr/g96PD0qms39KsH0U+BruqOqRZpYGM 7/Rdb2m6UTJwAmPlde2zO8Xa5jEhoCgyGFtNqyD2YWvsM+9yEJurKSjrrT2+g2y7xEMUlta2FjaQ Cu0KX+/yGjje4s7iJstoN8DOaoYzId6LHyIaKVLddr7vmvPHC5thWnw/SEmQKlDyj9TILNZe3ujo 0xP0lIJDHOK1wIMKUwkBBMj8smwzC9SMj2u40HtE2N1QwcQvwu4ZudldWvGFMWWc/0LTVVhGbUKs mgRDhZgc3cXb2MPtRr3KFq2XjF3D2CYcjE9wtW+EdMFSHFkRgWIhxcKBZJdeasOyl0GApc8SAAAA AAAA --Apple-Mail-15-381530700--