Filtering related records based no logged in user

[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

[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