Re: Is there a way to get a slice of many tables?
Or you can specify only the fields you're interested in via 'fields' array. in Model::find() On 3 Říj, 00:22, Steveston [EMAIL PROTECTED] wrote: For example: a typical university project, I have users, user_courses (for instructors), user_enrolls (for students), courses, events (each course have one or more events), groups (each event has one or more groups), group_members (each group has 1+ members), etc It is very common for me to get data from all of these tables. While I can set association in model to do this, it requires me to do associations in many tables and returned data will be large and contain lots of fields that I am not interested in. Is there a way to get a slice of all those tables? For exmaple: user_id=1 user_name=joe enrolled course name group name etc. Thank you, --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Is there a way to get a slice of many tables?
For example: a typical university project, I have users, user_courses (for instructors), user_enrolls (for students), courses, events (each course have one or more events), groups (each event has one or more groups), group_members (each group has 1+ members), etc It is very common for me to get data from all of these tables. While I can set association in model to do this, it requires me to do associations in many tables and returned data will be large and contain lots of fields that I am not interested in. Is there a way to get a slice of all those tables? For exmaple: user_id=1 user_name=joe enrolled course name group name etc. Thank you, --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Is there a way to get a slice of many tables?
Use associations to define your relationships, then use Containable behavior to limit what data is returned. Easy! On Oct 3, 8:22 am, Steveston [EMAIL PROTECTED] wrote: For example: a typical university project, I have users, user_courses (for instructors), user_enrolls (for students), courses, events (each course have one or more events), groups (each event has one or more groups), group_members (each group has 1+ members), etc It is very common for me to get data from all of these tables. While I can set association in model to do this, it requires me to do associations in many tables and returned data will be large and contain lots of fields that I am not interested in. Is there a way to get a slice of all those tables? For exmaple: user_id=1 user_name=joe enrolled course name group name etc. Thank you, --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---