How do I assign a unique identity to a user for using in generic queries?

Top   « Previous  Next »

Custom Query Values

 

The Custom Query Values option provides the ability to associate a system variable (e.g. Employee ID) with a user so that purely generic queries can be created that only pull data relevant to that user.

 

eg. Create 'Employee ID' and give each user a unique Employee ID. This is then tied to the users' messaging details, so a query can be created with the generic term Employee ID and when the query is run, only data relevant to that user is shown.

 

 

Create a custom field, EmployeeID in the Users & Groups screen.

 

User-custom-fields2-doc

 

For each users' account, add an EmployeeID value. This value is then tied to that user.

 

User-custom-fields2a-doc

 

This new field can then be used in queries like below. In this case if this employee with EmployeeID number 345 sends in a query, they will receive information back relevant to them.

 

User-custom-fields3-doc