Microsoft 4.5.X manual Designing Queries, String Replaced With Example

you do not need to enter a setting query. If this checkbox is checked, you will need to enter a setting query. The Account Reset Console uses this query to set the answer in the database when the user configures his identity verification answers.

Insertion queries are only required for verification questions whose answers can be set by the user. If the “Allow users to set their own answers to this question” checkbox is not checked, you do not need to enter an insertion query. If this checkbox is checked, you will need to enter an insertion query. The Account Reset Console uses this query to add a user to the database when an appropriate entry for that user does not exist.

User deletion queries are only required for verification questions accessing databases which should be “cleaned up” periodically, that is, have inactive or nonexistent accounts removed. The Account Reset Console currently does not utilize this query.

Designing Queries

Queries should be in SQL. Before the Account Reset Console sends the query language to the data source, it will perform the following substitutions in the query string:

String	Replaced With	Example
#user#	The username (without domain)	bob
#domain#	The user’s domain	SALESDMN
#question#	The GUID of the question	3C1D8B25-D423-
		419B-AD6E-
		E78169B89374
#answer#	The text of the answer	Blue

When the Account Reset Console performs this replacement, it does not insert (or remove) quotation marks or other tokenizers. Thus, if you have a character-valued column and you want to look up the user name in that column, you will probably have to enclose the #user# in quotes:

…where user_name_column = ‘#user#’…

When retrieving the answer from the data source using the retrieval query, it will take the value in the first column of the first row of the retrieved recordset as the answer to the question. You may return any number of rows or columns, but only the first cell will be utilized by the Account Reset Console.

When you click “Save Question Settings,” the Account Reset Console will attempt to retrieve the answer for the specified test user from the data source you have selected, using the retrieval query you have entered. It will also attempt to set that user’s answer, using a predefined test value.

If you have selected the checkbox “Allow users to set their own answers to this question,” users will be allowed to enter an answer to the question in the “Set Up My Identity” tab (described earlier in the document). Users will only be prompted to enter answers to questions

Page 73 of 94 - Administration Manual - Copyright 2007 - Lieberman Software Corporation - All Rights Reserved