Page 1 of 1

Filtering related records based no logged in user

PostPosted: Mon Aug 03, 2009 12:35 pm
by yokaiface
Hi Steve,

Yet another challenge! Is there a way to filter related records based on logged in user? I want the related records to display on those records owned by the one logged in.

Regards

PostPosted: Wed Aug 05, 2009 12:24 pm
by shannah
OK.. haven't tested this but it should work..

2 steps:

1. Create a calculated field in the delegate class for the source table that simply returns the logged in user.

2. Include this calculated field as part of the relationship definition.

E.g.

Your calculated field might look like:

Code: Select all
function field__current_user(&$record){
    $auth =& Dataface_AuthenticationTool::getInstance();
    return $auth->getLoggedInUserName();
}


Then in your relationship you might have:
Code: Select all
[books]
books.category_id="$category_id"
books.owner_id="$current_user"


This all assumes that your relationship is going from a "category" table to a "books" table and includes only books that match the current category's category_id AND the book's owner_id field matches the username of the currently logged in user.

-Steve