# search for im_network @search_msgs = $schema->resultset('Message')->search( { 'from_user.im_network' => 'Yahoo', }, { join => 'from_user' }, ); ok (scalar @search_msgs == 2, 'join message to user'); # search for receiving_user @search_msgs = $schema->resultset('Message')->search( { 'user.im_username' => 'linux_rohan', }, { join => { conversation => { 'users' => 'user' } } }, ); ok (scalar @search_msgs == 2, 'join message to users');