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