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)