|
How do I define custom query values? |
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.
For each users' account, add an EmployeeID value. This value is then tied to that user.
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.
|