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
Filtering related records based no logged in user
2 posts
• Page 1 of 1
Filtering related records based no logged in userHi 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
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:
Then in your relationship you might have:
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
2 posts
• Page 1 of 1
Who is onlineUsers browsing this forum: No registered users and 24 guests |