To define a new query, you must use an existing standalone integrator.

   To define a new query:

1. Select Create Document from the Web ADI menu.

2. Select a spreadsheet viewer. Leave the reporting box unchecked to download data.

3. Select HR Create Standalone Query integrator.

4. Select the default options for layout and content.

5. Specify the application short name that you used, when you created the standalone integrator, in the mapping window.

6. Specify the integrator username, if required.

7. Review the data entered in the review window, and select the Create Document button.

8. Specify the query restriction to use for your integrator in the SQL WHERE clause column.

   Enter the SQL WHERE clause in the following format:

   WHERE COL_NAME
   LIKE $PARAM$.app:COL_NAME
   

   col_name = any column in the view used by the integrator

   app = application shortname

   You can use any SQL conditional operator in the SQL WHERE clause. For example:

   WHERE first_name 
   LIKE $PARAM$.per:first_name
   

   Each instance of $PARAM$ is a bind variable, and you can use a maximum of 5 within a single WHERE clause.

9. Specify the name for each bind variable in the application parameter name column. For example: per:first_name.

10. Specify the type for each bind variable in the appropriate parameter type columns. For example: Varchar2. You can use the list of values to display the available options.

11. Specify the prompts for each bind variable. These prompts appear when you use the integrator (for example: first_name LIKE).

12. Upload your spreadsheet data to the database. Your integrator is now ready to use.

   Using your integrator:

1. Select Create Document from the Web ADI menu.

2. Select a spreadsheet viewer. Leave the Reporting check box unselected to download data.

3. Select the standalone integrator you created earlier.

4. Select the default options for layout and content.

5. Enter values for each prompt for every bind variable that you defined in the mapping window. You can also change the session date, if required, to ensure that you obtain the latest data for your query.

6. Review the data entered in the review window, and select the Create Document button.

7. View your results in the displayed spreadsheet.