Download 460202008

Transcript
302
Picture Perfect 4.5
User Manual
{$utc_date|}
{$utc_date|n}
UI Control:
None
Output:
Current date minus “n” days
Current time minus “n” hours
Example Query:
SELECT * FROM badge_history WHERE dept=”{$multiple_choice|Department:|SELECT id, description
FROM department}”
{$translate_lookup_exclusive|<tablename>}
UI Control:
Translates the view results lookup values for the specified table
Output:
None
{$column_selection_exclusive|<all possible columns>|<columns selected by default>}
UI Control:
“Column Manager” provides a control to select the columns to be included in the report results.
Output:
Comma-delimited list of column names
{$union_exclusive|<table1>|<table2>}
UI Control:
Expands the SQL query into two queries; one against table1 and one against table2
Output:
None
{$number_exclusive|<label>|<field>}
UI Control:
Text field with a label
Output:
Replaces tag with user-supplied number
{$time_range_exclusive|report.DateAndTime|report.Device|report.Host|report.UTC|dev_xac
t|host_xact|utc_xact}
UI Control:
Date and time control
Output:
Replaces tag with SQL clauses that correspond to Date and Time criteria selected in the control