Differences
This shows you the differences between two versions of the page.
|
tech:codecharge:filter_on_logged_in_user [2014/11/15 09:13] |
tech:codecharge:filter_on_logged_in_user [2014/11/15 09:13] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ====== Filter based on which user is logged in ====== | ||
| + | The Session varibale UserID can be used to dynamically filter data in menus, lists, etc based on the user who is logged in. | ||
| + | |||
| + | In the where clause choose | ||
| + | * Condition Type as Parameter (as opposed to Expression) | ||
| + | * Field | ||
| + | * Name Field = <the column name> e.g. member_user_id | ||
| + | * Type = Integer | ||
| + | * Format is left blank | ||
| + | * Condition = <choose the correct one> e.g. = | ||
| + | * Parameter | ||
| + | * (1st box) UserID | ||
| + | * Type = Session | ||
| + | * Format is left blank | ||
| + | * Choose option "Use Is Null Condition" | ||
| + | * Condition = And | ||
| + | |||
| + | |||
| + | |||
| + | |||
