Hi,
I would like to ask some help from the SQL gurus out there. We did some discussion on IRC on this.
The basic problem is.
- How can I query the different content types and all of the uncommon attributes of a content type on a folder?
The solutions that was discussed was:
- make a 2 pass query. Do a query to build a super union query. Then execute the union query
- query each content type, then append a multirow. although we can't sort the whole result set. Unless there was some easy way to do a sort on a multirow.
- query the common attributes, and query on each row for the specific uncommon attribute of a content type. likely to be super slow.
Its like querying acs_objects table and getting all of the object attributes. But this one smaller on cr_items table only.
Or maybe someone respectable tell me, not to do this and make my life simple. Just query the common attributes and be happy.