Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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
 +
 +
 +
 +
  

QR Code
QR Code tech:codecharge:filter_on_logged_in_user (generated for current page)