orderBy value in related table

2 posts by 2 authors in: Forums > CMS Builder
Last Post: November 14, 2011 (RSS)

Archived
Reply
Reply

By rjbathgate - November 14, 2011

Howdy,

Say I have table "products", and each record has a field "category", which is linked (num value) to table "categories".

In table 'categories', each category has a value "Featured" checkbox.

Is there an easy / built in way I can use this value in the related table to order the products table...

I could do it by running both tables into a new array and restoring, but wondered if there was a simply way I could do it in the products list viewer "orderBy" statement....

Cheers!

Re: [rjbathgate] orderBy value in related table

Archived
Reply
Reply

By Jason - November 14, 2011

Hi,

Yes, you can do this by using the leftJoin option in getRecords. For example:

list($productsRecords, $productsMetaData) = getRecords(array(
    'tableName'       =>    'products',
    'allowSearch'     =>    false,
    'leftJoin'        =>    array('categories' => 'category'),
    'orderBy'         =>    'categories.featured DESC',
  
  ));

This returns the records in "products" sorted so that the products with a category where the featured checkbox is checked appear first.

Hope this helps

---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/