Hi All,

I have 3 SmartObjects; a header, an item and an approval step.  For each workflow process I have one header.  Each header has many items and the header also has many approval steps.

I want to query the SmartBox to return all items where header.workflowstatus = 'InProgress'.  How would I go about writing a smartobject method that does a join on two SmartObjects?  In SQL the query would look like:

SELECT     *
FROM        
  Item INNER JOIN
  Header ON Item.Parent = Header.ID
WHERE
  Header.WorkflowStatus <> 'Completed'

Many Thanks

Dave