https://interactivetools.com/forum/forum-search.php?k=user%3Ainternut Tue, 05 May 2026 14:22:40 -0700 en-us https://interactivetools.com/forum/forum-posts.php?postNum=2205129#post2205129
Now a new question is on record data from the join of "updates" its only pulling in:

[updates.job] => 533
[updates.stage] => 15

Shouldn't I be getting record created / updated variables returned?
]]> Fri, 25 Jun 2010 11:34:32 -0700 forum-posts.php?postNum=2205129#post2205129 https://interactivetools.com/forum/forum-posts.php?postNum=2205128#post2205128
I'm a little stuck on how to go about this.

I have a "orders" table / section. and a "Updates" section which is used to add updates to an order (stages of the order process).

I'm trying to get a list of records from "orders" and joining the "updates" table to get the latest stage of the update.

Using code:

// load records
list($ordersRecords, $ordersMetaData) = getRecords(array(
'tableName' => 'orders',

'leftJoin' => array(
'updates' => 'ON orders.num = updates.job',
'accounts' => 'ON accounts.num = updates.updatedByUserNum',
'whip_stages' => 'ON updates.stage = whip_stages.num',
),

'debugSql' => true,


'loadUploads' => '0',
'loadCreatedBy' => '0',
'where' => 'updates.job = orders.num AND archive = 0',
'limit' => '',

));

I get a record returned from "orders" as many times as there are related records in "updates". How can I get 1 record returned and just the most recent?

DISTINCT?

Thanks much!
]]> Fri, 25 Jun 2010 10:35:53 -0700 forum-posts.php?postNum=2205128#post2205128