|
|
|
The parameter element defines an individual parameter for a search. Specifically, it defines an input field that can be used directly or indirectly as a search parameter.
The supported entities are as follows:
Specifies an item for parameters of type="list" or type="choice". For example:
<option value="4">Four</option>
Required: Yes
Note: List and choice parameters generally need at least two options
Specifies a unique name for the parameter. This can be used to identify the parameter in a script. It does not need to match the argument name in the SP. For example:
name="idUser"
This attribute is also used to configure context searches. See Context Searches <parameter>.
Required: Yes
Specifies the default value for the parameter in the Search screen. For example:
value="my value"
See Context Searches <parameter>.
Required: No
Specifies the type of search parameter. The type must be
compatible with the SP. See Parameter Type Mappings. For example:
type="text"
Required: Yes
The supported types are:
A text label, for enhancing the screen display. It provides no input to the search.
A graphic, for enhancing the screen display. It provides no input to the search.
A text input box.
A numeric value.
A date value. Dates may be specified as absolute or relative dates. See Single Date.
A pair of date values indicating a time period. This is an aggregate parameter that includes several fields to simplify the selection of common time periods. Defaults for the date range may be specified using special attributes as absolute or relative dates. See Date Range.
A check box.
A list of items from which the user may select one or more. You can enable multiple selections using the multiple attribute and specify dynamic retrieval using the spname attribute. The appearance of the list can be modified using the attrs attribute.
Radio buttons.
A text box with dynamic lookup, for example, to retrieve a list of users matching a name fragment and to allow selection from a popup.
Similar to lookup, but uses an ID for the search rather than a string. As an example, this is used for the user lookup where instead of using the user name in the stored procedure, the user’s id is used which is more precise and more efficient.
Specifies a real (decimal) number.
A special parameter type that provides the reviewer’s user ID or machine ID. These parameters are used internally and do not appear in iConsole search screens.
Specifies additional, type specific attributes which control the behavior of the parameter. The primary use for this attribute is in conjunction with the list parameter type (see Multi-Select List Parameters, the date parameter type and the date_range parameter type.
Required: No
Specifies the order in which the parameter is listed in the arguments passed to the SP (see the CREATE line in the examples). This allows you to change the parameter layout in a search screen independently of the order in which they are passed to the SP.
Note: If no argpos attribute is specified the parameter will not be passed to the SP but may be used in the generation of an actual parameter.
Required: No
Specifies the text that is shown next to the search parameter in the Customize Search screen. For example:
label="Audit Status"
Required: No
Specifies a text label appended to a numeric parameter in the search screen. For example:
units="%"
Required: No
Defines the JavaScript code to be executed if the parameter value is changed. Use this attribute to give dynamic behavior to the search properties page page, for example, to alter another parameter based on the setting of this one.
onchange="UpdateParameters();"
Required: No
Defines the JavaScript code to be executed if the parameter is clicked. Use this attribute to give dynamic behavior to the Customize Search page, for example, to disable a particular feature of the search if a parameter is selected.
onclick="DisableFeature();"
Required: No
Defines the JavaScript code to be executed if a key is. Use this attribute to give dynamic behavior to the Search Properties page, for example, to apply input validation rules.
onkeypress="ValidateInteger();"
Required: No
A Boolean attribute for specifying that the search parameter cannot be seen or modified by the user. This can be useful for making parameters inaccessible in a simple search variant.
constant="true"
Required: No
Specifies the package name for an SP. For example:
sppackage="MyPackage"
Required: No
Note: On an Oracle database this defines the package in which the SP resides. On an SQL Server database it defines a prefix which is added to the spname parameter.
Specifies the name of an SP to use to retrieve a dynamic list of items for a list parameter. The SP returns two columns: values and text labels for each item in the list box. For example:
spname="WgnWCAuditField1List"
Required: No
Applies only to parameters which are based on stored procedures (that is, those that include the spname attribute—see above). Setting this attribute to true, allows the values retrieved from the stored procedure specified in spname to be cached. This speeds up loading of the properties page as the iConsole does not need to retrieve these values from the database each time the page is opened.
Defaults to false if not specified.
By default, the cache will expire 5 minutes after it has first been populated. To change this default, you need to add or edit the registry value SearchParamsCachePeriodMinutes (for details, see the Deployment Guide; search the index for ‘timeouts, for iConsole’).
Required: No
Applies only to those parameters based on stored procedures. Specifies whether ‘row level security’ (RLS) is switched on or off for the stored procedure used to retrieve the parameter values. If set to true, RLS is switched on, which can cause the retrieval of the parameter values to run more slowly. If set to false, searches will run unrestricted, allowing access to all data values. Defaults to true if not specified.
Required: No
Defines the function used to show a dialog for selecting values for lookup and lookupbyid parameter types. The list of values is retrieved from the database and may be sorted and filtered to ease selection from a large list of items. For example:
lookup_function="MyUserLookupFunction"
For details and example usage, see Lookup Parameters.
Required: Yes (for lookup and lookupbyid types)
A flag to indicate that more than one item may be selected from a list type parameter. For example:
multiple="true"
By default, specifying this attribute sets the visible size of the list to 4 items (see size). There are two variants of list parameter when used with the multiple flag. For details see List Parameters.
Required: No
For text, numeric, real, lookup or lookupbyid parameters specifies the maximum number of characters that can be displayed in the input.
For list parameters, specifies the number of items to be displayed. By default this is 1 for a normal list; or 4 when multiple is selected.
size="3"
Required: No
Specifies the number of rows to display in a ‘text’, 'lookup' or lookupbyid parameter.
Required: No
Specifies the text displayed as a tooltip when the mouse pointer hovers over the parameter. For example:
tooltip="Specify the audit status of the e-mails you want to review."
Required: No
Specifies the horizontal alignment of the field: left, center, right. For check boxes, the text label is placed to the right if align="left" and vice versa.
Required: No
Specifies the vertical alignment of the field: top, middle, bottom.
Required: No
Specifies the column where this parameter should be placed in a grid. By default a parameter will be specified in the next column. If the value of col is less than the current column a new row is started. For example:
col="1"
Note: This attribute is only supported when requires="12.5" (or later).
Required: No
Specifies how many columns this parameter spans in the current parameter line. For example:
colspan="2"
Required: No
Specifies the row where this parameter should be placed in a grid. For example:
row="2"
Note: This attribute is only supported when requires="12.5" (or later).
Required: No
Specifies how many rows this parameter spans in the current parameter group.
Required: No
Specifies the cell width for the current parameter. For example:
width="50%" or width="120px"
Required: No
Specifies whether the parameter should be hidden by default, for example:
hidden="true"
Required: No
If search attribute show_parameters="true" (see Zoom Element), this specifies whether the current parameter is shown in a search report. This attribute defaults to true so report="false" must be specified to disable the display of the parameter in the report. For example:
report="false"
Required: No
If parameter attribute report="true" (see above), this specifies a text label for the parameter in the report and overrides the default label attribute described earlier in this topic. For example:
report_label="reviewed E-mails"
Required: No
Specifies a value to be displayed on a report rather than the value passed to the stored procedure. This attribute gets populated automatically for list and choice parameter types, with the item value (generally an index number) being passed to the stored procedure and the report_value being set to the item text.
Required: No
Specifies a CSS style for this parameter. This is used typically to specify text formatting, for example:
style="font-weight: bold"
Required: No
Specifies the precision required for the time component in date and date_range parameters (see Customizing Time Display in Date Parameters). Possible values are:
none – no time shown
hour – only hours shown
minute – hours and minutes shown
second – hours, minutes and seconds shown (default)
For example, to hide the seconds component:
time="minute"
Required: No
Specifies the name of a subsection to be controlled by this parameter when type="checkbox". This is used to display optional parameters, for example:
subsection="optionalParameters"
Required: No
Defines a collection of parameters that should be grouped together. They will be displayed in a separate panel that can be collapsed when those parameters are not of interest.
Note: This element is only supported when requires="12.5" (or later).
The supported entities are as follows:
<parameter>
See <parameter> Element.
Required: No
A anme by which the subsection can be identified. For example:
name="optionalParameters"
Required: Yes
A text label to be used as the title for the subsection panel. For example:
label="Optional Parameters"
Required: No
Specifies the text displayed as a tooltip when the mouse pointer hovers over the subsection. For example:
tooltip="Show optional parameters."
Required: No
Specifies the column where this subsection should be placed in a grid. By default it will be specified in the next column. If the value of col is less than the current column a new row is started. For example:
col="1"
Required: No
Specifies the row where this subsection should be placed in a grid. For example:
row="2"
Required: No
Specifies how many columns this subsection spans in the current. For example:
colspan="2"
Required: No
Specifies how many rows this subsection. For example:
rowspan="2"
Required: No
A flag indicating whether the subsection should be collapsed by default. For example:
collapse="true"
Required: No
| Copyright © 2011 CA. All rights reserved. | Email CA Technologies about this topic |