L
LastFlowTest(expC1,expC2)
Data Format Returned: X
Returns a value or expression from the last flow test record found for a specified hydrant number.
Parameters
Variable | Status | Description |
---|---|---|
expC1 | Required | The hydrant number you want to retrieve the value for. |
expC2 | Required | The field name or expression to evaluate and return. |
LastFlowTest('Flow_test_by_hydrant.Hydr_id','Flow_test_by_hydrant.Date')
returns the last date a flow test was conducted for a hydrant. In
this case, it would return a last flow test date for each hydrant that
the query returns.
LastFlowTest('Flow_test_by_hydrant.Hydr_id','Flow_test_by_hydrant.last')
returns
the last name of the staff member who performed the last hydrant flow
test.
LastHydrActivity(expC1,expC2,expN,expL)
Data Format Returned: X
Returns a value or expression from the last activity record found for a specified hydrant number.
Parameters
Variable | Status | Description |
---|---|---|
expC1 | Required | The hydrant number you want to retrieve the value for. |
expC2 | Required | The field name or expression to evaluate and return. |
expN | Optional |
The type of hydrant activity to retrieve the value from.
|
expL | Optional | Type .T. to exclude the type of hydrant activity specified by <expN>. If nothing is entered,
the specified hydrant field or expression value for the specified inspection
type is displayed. |
LastHydrActivity(Hydr_id,'Date',1)
returns the
date of the last flow test hydrant activity.
LastLoginDate(expC1)
Data Format Returned: X
Returns the last login date for a specified user.
Parameters
Variable | Status | Description |
---|---|---|
expC1 | Required | User ID to return last login date for. |
LastLoginTime(expC1)
Data Format Returned: X
Returns the last login time for a specified user.
Parameters
Variable | Status | Description |
---|---|---|
expC1 | Required | User ID to return last login time for. |
LastLoginWorkstation(expC1)
Data Format Returned: X
Returns the name of the workstation where a specified user last logged in.
Parameters
Variable | Status | Description |
---|---|---|
expC1 | Required | User ID to return last login workstation time for. |
LastMaint(expC1,expC2,expD,expC3)
Data Format Returned: X
Returns a value or expression from the last maintenance found for a specified equipment number on or before a specified date and time. Typically used to extract the last known meter readings for a piece of equipment on or before a given date/time.
Parameters
Variable | Status | Description |
---|---|---|
expC1 | Required | The equipment number you want to retrieve the value for. |
expC2 | Required | The field name or expression to evaluate and return. |
expD | Optional | If passed, the value returned will be the last value found for the piece of equipment on or before this date. If not passed, the current system date is assumed. |
expC3 | Optional | If passed, the value returned will be the last value found for the piece of equipment on or before this time (and date as specified in expD. If not passed, the current system time is assumed. |
LastMaint(INV_ID,'DATE')
returns the date
of the last meter reading.
LastMaint(INV_ID,'MILEAGE')
returns the
mileage shown in the last meter reading.
LastMaint(INV_ID,'HOURS')
returns the Hours
shown in the last meter reading.
LastMeter(expC1,expC2,expD,expC3)
Data Format Returned: X
Returns a value or expression from the last maintenance or usage record found for a specified equipment number on or before a specified date and time. Typically used to extract the last known meter readings for a piece of equipment on or before a given date/time.
Parameters
Variable | Status | Description |
---|---|---|
expC1 | Required | The equipment number you want to retrieve the value for. |
expC2 | Required | The field name or expression to evaluate and return. |
expD | Optional | If passed, the value returned will be the last value found for the piece of equipment on or before this date. If not passed, the current system date is assumed. |
expC3 | Optional | If passed, the value returned will be the last value found for the piece of equipment on or before this time (and date as specified in expD. If not passed, the current system time is assumed. |
LastMeter(INV_ID,'DATE')
returns the date
of the last meter reading.
LastMeter(INV_ID,'MILEAGE')
returns the
mileage shown in the last meter reading.
LastMeter(INV_ID,'HOURS')
returns the Hours
shown in the last meter reading.
LastModifiedBy(expC1,expC2)
Data Format Returned: X
Returns the name of the user who last modified a specific record in a specific table.
Parameters
Variable | Status | Description |
---|---|---|
expC1 | Required | Name of the table in which the record resides. This must be a literal table name and not the name of an alias or view. |
expC2 | Required | The key value of the record to return information for. This must be a primary key value. |
LastModifiedBy(‘inc_main’,lst.inci_id)
returns the user id of the last person who modified a particular record
in the Fire Incident main table
(inc_main
).
Note: The inci_id
field would generally need to be added to the query through the query properties. LastModifiedBy(‘occ_main’,lst.occup_id)
returns
the user ID of the last person who modified a particular record in the
occupancy main table (occ_main
).
LastModifiedDate(expC1,expC2)
Data Format Returned: X
Returns the date of the last modification to a specific record in a specific table.
Parameters
Variable | Status | Description |
---|---|---|
expC1 | Required | Name of the table in which the record resides. This must be a literal table name and not the name of an alias or view. |
expC2 | Required | The key value of the record to return information for. This must be a primary key value. |
LastModifiedDate(‘inc_main’,lst.inci_id)
returns most recent date a particular record was modified in the Fire Incident main table
(inc_main
).
Note: The inci_id
field would generally need to be added to the query through the query properties.
LastModifiedDateTime(expC1,expC2)
Data Format Returned: X
Returns the date a of the last modification to a specific record in a specific table.
Parameters
Variable | Status | Description |
---|---|---|
expC1 | Required | Name of the table in which the record resides. This must be a literal table name and not the name of an alias or view. |
expC2 | Required | The key value of the record to return information for. This must be a primary key value. |
LastModifiedDateTime(‘inc_main’,lst.inci_id)
returns most recent date a particular record was modified in the Fire Incident main table
(inc_main
).
Note: The inci_id
field would generally need to be added to the query through the query properties.
LastModifiedWks(expC1,expC2)
Data Format Returned: X
Returns the name of the workstation where a specific record in a specific table was last modified.
Parameters
Variable | Status | Description |
---|---|---|
expC1 | Required | Name of the table in which the record resides. This must be a literal table name and not the name of an alias or view. |
expC2 | Required | The key value of the record to return information for. This must be a primary key value. |
LastModifiedWks(‘inc_main’,lst.inci_id)
returns the ID number of
the workstation upon which the last modification was made to a particular
record.
LastUsage(expC1,expC2,expD,expC3)
Data Format Returned: X
Returns a value or expression from the last usage record found for a specified equipment number on or before a specified date and time. Typically used to extract the last known usage for a piece of equipment on or before a given date/time.
Parameters
Variable | Status | Description |
---|---|---|
expC1 | Required | The equipment number you want to retrieve the value for. |
expC2 | Required | The field name or expression to evaluate and return. |
expD | Optional | If passed, the value returned will be the last value found for the piece of equipment on or before this date. If not passed, the current system date is assumed. |
expC3 | Optional | If passed, the value returned will be the last value found for the piece of equipment on or before this time (and date as specified in expD. If not passed, the current system time is assumed. |
LastUsage(INV_ID,'DATE')
returns the date
of the last meter reading.
LastUsage(INV_ID,'MILEAGE')
returns the
mileage shown in the last meter reading.
LastUsage(INV_ID,'HOURS')
returns the Hours
shown in the last meter reading.
Later(expD1,expC1,expD2,expC2)
Data Format Returned: X
Determines if the combined date/time value of a date and time are chronologically later than the combined date/time value of a comparison date and time.
Parameters
Variable | Status | Description |
---|---|---|
expD1 | Required | Date value to compare against. |
expC1 | Required | Time value
to compare against in the format HH:MM:SS . |
expD2 | Required | Date to compare. |
expC2 | Required |
Time value
to compare in the format |
LeapYear(expD)
Data Format Returned: X
Returns true if expD is a date in a leap year. Respects the Gregorian calendar rule for leap years which states that a year is a leap year if it is divisible by 4, unless it is a centurial year which is not evenly divisible by 400.
Parameters
Variable | Status | Description |
---|---|---|
expD | Required | Date value. |
LEFT(expC,expN)
Data Format Returned: Character
Returns a specified number of characters from a character expression,
starting with the leftmost character.
LEFT( )
is identical to SUBSTR
with
a starting position of 1.
Parameters
Variable | Description |
---|---|
expD1 | Specifies
the character expression from which LEFT( )
returns characters. |
expC1 | Specifies the number of characters returned from the character expression. If expN is greater than the length of expC, all of the character expression is returned. The empty string is returned if expN is negative or 0. |
ListDetail(expC1,expC2,expV,expC3,expC4,expN)
Data Format Returned: R
Returns a multi-line list of values from a child table linked to a parent master record based on a key value or expression specified.
Parameters
Variable | Status | Description |
---|---|---|
expC1 | Required | Name of alias or table name containing expression to retrieve. This can be the name of an alias already in use, or can point to a physical table name, in which case the alias name does not have to be in use. |
expC2 | Required | Field name or expression used to qualify records. If passed as an empty string, all records in the table named in expC1 qualify and will be returned. |
expV | Required | Value used to compare field name or expression in expC2 to qualify records. |
expC3 | Required | Expression to return. If records are found in expC1 based on qualifying expression in expC2, then expC3 is evaluated against each record found and a separate line containing that value is returned for each record. |
expC4 | Optional | Format mask to apply to return expressions. By default, all expressions are converted to character data type. Use this parameter to specific additional formatting options. For example, $999,999.99" would convert a numeric value to a dollars/cents type character display. |
expN | Optional | Maximum number of records (lines) to return. If passed as zero or not passed, all records are assumed. |
Locked(expC1,expC2)
Data Format Returned: X
Returns true or false to indicate whether or not a user-level security lock has been placed on a specific record in a specific table.
Parameters
Variable | Status | Description |
---|---|---|
expC1 | Required | Name of the table in which the record resides. This must be a literal table name and not the name of an alias or view. |
expC2 | Required | The key value of the record to return information for. This must be a primary key value. |
LockedBy(expC1,expC2)
Data Format Returned: X
Returns the name of the user who has the current security lock, if applicable, on a specific record in a specific table.
Parameters
Variable | Status | Description |
---|---|---|
expC1 | Required | Name of the table in which the record resides. This must be a literal table name and not the name of an alias or view. |
expC2 | Required | The key value of the record to return information for. This must be a primary key value. |
LockedDateTime(expC1,expC2)
Data Format Returned: X
Returns the date and time that the security lock, if applicable, was placed on a specific record in a specific table.
Parameters
Variable | Status | Description |
---|---|---|
expC1 | Required | Name of the table in which the record resides. This must be a literal table name and not the name of an alias or view. |
expC2 | Required | The key value of the record to return information for. This must be a primary key value. |
LoginUserName(expC)
Data Format Returned: X
Returns the user name for a specific login record.
Parameters
Variable | Status | Description |
---|---|---|
expC | Required | ID of the login to return user name for. Typically this value is stored in login_id field in the audit database. |
LoginWorkstationName(expC)
Data Format Returned: X
Returns the name of the workstation where a specific login occurred.
Parameters
Variable | Status | Description |
---|---|---|
expC | Required | ID of the login to return workstation name for. Typically this value is stored in login_id field in the audit database. |
LongDate(expD)
Data Format Returned: X
Returns the name of the workstation where a specific login occurred.
Parameters
Variable | Status | Description |
---|---|---|
expD | Required | Date value for which to return long date name. |
Longdate(lst.alm_date)
returns the date of the alarm in the following
format: Wed June 5, 2002
.
LongState(expC)
Data Format Returned: X
Returns the full name of a state from a two-letter state or territory abbreviation.
Parameters
Variable | Status | Description |
---|---|---|
expC | Required | The two-letter state abbreviation to return the long state or territory name for. |
LongState(lst.state)
returns the whole name of
the state. Converts
IA to Iowa.
Converts all upper-case letters (A-Z) to lower-case (a-z). All other characters remain unchanged.
LOWER
Data Format Returned: C
Parameters
Variable | Status | Description |
---|---|---|
expC | Required | The two-letter state abbreviation to return the long state or territory name for. |
Lower(anyexpression)
converts the text returned into
lower case no matter what its original case was.
LTRIM(expC)
Data Format Returned: Character
Returns the specified character expression with leading blanks removed.
Parameters
Variable | Status | Description |
---|---|---|
expC | Required | Specifies the character expression whose leading blanks LTRIM( ) removes. |
This function is especially useful for removing the leading blanks that
are inserted when you use the STR()
to convert a numeric value to a character string.