Analyser Query - Parameters tab

Purpose

Specify the default values for Query Builder parameters.

These data fields are captured on the Analyser Query - Parameters tab.

Field	Setting
Name	The name of the parameter specified in the SQL Statement.
Description	A detailed description of the parameter name.
Parameter Type	The type of parameter specified in the SQL Statement for the specified Business Object (item). “String” if the parameter is a code. “Float” if the parameter is a decimal value. “Date” if the parameter is in date format.
Default Value	The default value for the specified parameter. The parameter value applies to the data field identified in the SQL Statement after “WHERE”. For example, “WHERE LastName like @LastNameParam”.

Please note!

The wildcard character “%” on its own is used to select all values.
The wildcard character “%” preceded or followed by a string of characters is used to select all values that contain that string.

What can I do?

These buttons are available in the toolbar of the Analyser Query - Parameters tab.

Click…	To…
	Fetch User Parameters from SQL.

© 2016 Pragma