Primary key
PK or ID

None

The record’s primary key or ID is passed as an argument in the URL.

The “ID” URL Parameter constructs a Key object, which is rendered as an XML structure to accommodate composite keys (where the key consists of more than one column).

Virtual foreign keys of database views cannot be used as a URL Parameter using ID.  Consider using FV instead.

Note: PK is an alias for the ID Type.  The record’s primary key or ID is passed as an argument in the URL.

DK

None

Returns a "best guess" implicit or default key string.  DK is similar to PK, but can also be used on tables, database views, and custom queries that lack a primary key.  If the record has a primary key, the primary key is passed as an argument in the URL.  If a record (virtual record in a database view) has no primary key, the virtual record’s default key is passed as an argument in the URL.

Foreign key
FK

Foreign Key Name

The foreign key or foreign key ID is passed as an argument to the URL.  The Foreign Key Name is the name of the foreign key either in the database or as a virtual foreign key defined in Iron Speed Designer.

Example:  FK:FK_Orders_Customers

FK may be prefixed by NoUrlEncode to indicate that the value will not be URL encoded.  (E.g., spaces will not be converted to %20.)

Example:  NoUrlEncode:FK_Orders_Customers

Field value
FV

Database field name
or
Field display name

FV returns (converts) the database field value as a string without using the field’s display format.  For example, dates will always be displayed in the web server's default date format regardless of the field’s properties.  Value is the database field name (not the name of the code generation tag).

Example:

            FV:BirthDate

Returns:

            12%2f8%2f1948+12%3a00%3a00+AM
            (12/8/1948 12:00:00 AM)

FV may be prefixed by NoUrlEncode to indicate that the value will not be URL encoded.  (E.g., slashes will not be converted to %2f.)  However, the value will be HTML encoded.  (E.g., spaces are converted to %20.)

Example:

            NoUrlEncode:FV:BirthDate

Returns:

            12/8/1948%2012:00:00%20AM

Page count
PageCount

N/A

Returns the page count when used with a table control.

Table name
TName

N/A

Returns the table name when used with a table control.

Use field display format
FVS

Database field name
or
Field display name

FVS returns (converts) the database field value as a string using the field’s “editable” or “reparsable” string format as specified by the database field properties.  This is the same as the FV type, but converted into a string.

Example:

            FVS:BirthDate

Returns:

            08+December+48+A.D.+00-00-00-AM

(08 December 48 A.D. 00-00-00-AM, assuming the display format is dd MMMM yy gg HH-mm-ss-tt)

FVS may be prefixed by NoUrlEncode to indicate that the value will not be URL encoded.  (E.g., slashes will not be converted to %2f.)  However, the value will be HTML encoded.  (E.g., spaces are converted to %20.)

Example:

            NoUrlEncode:FVS:BirthDate

Returns:

            08%20December%2048%20A.D.%2000-00-00-AM

Use reparsable display format
FDV

Database field name
or
Field display name

FDV returns (converts) the database field value as a string using the field’s display format, as specified by the database field properties, but the string may not be reparsable.  The display string may be different than the database field name because you may have selected a different display format.

For example, FDV converts field values to an expanded “display foreign key as” (DFKA) string for DFKA-enabled fields.  For most field types, this is the same as FVS if there is no DFKA configured.  However, FDV will convert Password values to "*****" and Credit Card Number values to the "masked" format (e.g. "XXXX-XXXX-XXXX-0000").

Example:

            FVS:BirthDate

Returns:

            08+December+48+A.D.+00-00-00-AM

(08 December 48 A.D. 00-00-00-AM, assuming the display format is dd MMMM yy gg HH-mm-ss-tt)

FDV may be prefixed by NoUrlEncode to indicate that the value will not be URL encoded.  (E.g., spaces will not be converted to %20.)  However, the value will be HTML encoded.  (E.g., spaces are converted to %20.)

Example:

            NoUrlEncode:FDV:Birth Date

Returns:

            08%20December%2048%20A.D.%2000-00-00-AM