TBD

When searching on user fields like Assigned To, Creator or Modified By the system expects you to give the full user name to search on. In other words you have to use the first and last name of the user like this:

assigned_to = user.first_name + ' ' + user.last_name

A typical situation that arises often is the need to create a filter and show only the “current user”'s records. So you create a filter of activities to be done “today” and you don't want to have to create 50 “today” filters. one for each of your 50 users. Exactly the same way you don't have to create 365 filters for each day of the year.

To accomplish this we can use a special meta-variable when defining our filters for the user fields. This field is called “current_user”.