Difference between revisions of "Auto Values"

From Hornbill
Jump to navigation Jump to search
 
(15 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
__NOTOC__[[Main_Page|Home]] > [[Administration]] > [[Data]] > Auto Values
+
This document can now be found at its new location in the [https://docs.hornbill.com/esp-config/advanced-tools-and-settings/auto-values/ Hornbill Document Library].
 +
 
 +
[[file:hornbill-document-library.png|Hornbill Cloud|link=https://docs.hornbill.com/esp-config/advanced-tools-and-settings/auto-values/]]
 +
<!--
 +
__NOTOC__[[Main_Page|Home]] > [[Administration]] > [[System Administration|System]] > [[Data]] > Auto Values {{#ev:youtube|_9Dduf-Ga10|400|right}}
 
==Introduction==
 
==Introduction==
−
The Auto Values feature lets an administrator define how auto-generated values, such as reference IDs, are constructed.  Places where more than a sequence number (000001234) is required, an Auto Value can be modified to include dates, time, location, teams, user IDs and more.  There are many situations where this type of sequence is much more preferable over a simple numeric sequences. Some examples include: -
+
The Auto Values feature lets an administrator define how auto-generated values, such as reference IDs, are constructed.  Places where more than a sequence number (000001234) is required, an Auto Value can be modified to include dates, time, location, teams, user IDs and more.  There are many situations where this type of sequence is much more preferable over a simple numeric sequences. Some examples include:
  
 
* Shipment numbers
 
* Shipment numbers
Line 8: Line 12:
 
* Asset ID's
 
* Asset ID's
 
* Access Code numbers
 
* Access Code numbers
 +
 +
==Auto Value Configuration==
 +
*Description
 +
*Add Auto Value Component
 +
*Current Value
 +
*Daily Increment
 +
*Monthly Increment
 +
*Yearly Increment
 +
*Time last generated
  
 
== Available Auto Value Component Parts ==
 
== Available Auto Value Component Parts ==
 
The following lists of component parts are available to construct an auto value.
 
The following lists of component parts are available to construct an auto value.
  
−
{| class="prettytable"
+
{| class="wikitable"
  
 
|-
 
|-
Line 26: Line 39:
 
|A number starting at 1 when the sequence is first used and incremented by one each time the sequence is used and will never be reset for the entire life of the sequence.  
 
|A number starting at 1 when the sequence is first used and incremented by one each time the sequence is used and will never be reset for the entire life of the sequence.  
 
|}
 
|}
 +
  
 
|-
 
|-
 
|nowrap="1"|'''seqd(''' ''z'', ''r'' ''')'''
 
|nowrap="1"|'''seqd(''' ''z'', ''r'' ''')'''
 
|
 
|
 +
 
:{| class="prettytable"
 
:{| class="prettytable"
  
 
|- bgcolor="#e0e0e0"
 
|- bgcolor="#e0e0e0"
 
|'''Description'''
 
|'''Description'''
 +
 +
|-
 
|A number starting at 1 at the beginning of each day, and incremented by one each time the sequence is used. This is the daily incremental value for this specific sequence instance.  
 
|A number starting at 1 at the beginning of each day, and incremented by one each time the sequence is used. This is the daily incremental value for this specific sequence instance.  
 
|}
 
|}
 +
  
 
|-
 
|-
Line 49: Line 67:
 
|A number starting at 1 at the beginning of each month, and incremented by one each time the sequence is used. This is the monthly incremental value for this specific sequence instance.
 
|A number starting at 1 at the beginning of each month, and incremented by one each time the sequence is used. This is the monthly incremental value for this specific sequence instance.
 
|}
 
|}
 +
 +
 
|-
 
|-
 
|nowrap="1"|'''seqy(''' ''z'', ''r'' ''')'''
 
|nowrap="1"|'''seqy(''' ''z'', ''r'' ''')'''
−
|Will be translated into a number starting at 1 at the beginning of each year, and incremented by one each time the sequence is used. This is the yearly incremental value for this specific sequence instance. See the component 'seq' for and explanation of the optional 'z' and 'radix' parameters.
+
|
 +
 
 +
:{| class="prettytable"
 +
 
 +
|- bgcolor="#e0e0e0"
 +
|'''Description'''
 +
|
  
 
|-
 
|-
 +
|Will be translated into a number starting at 1 at the beginning of each year, and incremented by one each time the sequence is used. This is the yearly incremental value for this specific sequence instance.
 +
|}
 +
 +
|-
 +
|
 +
|
 +
 +
:{| class="prettytable"
 +
 +
|-
 
|
 
|
 
|
 
|
  
−
''The 'z' parameter is optional but if specified indicates the number of leading zero's to display, if not specified then ZERO is assumed.  If the number of digits in the resultant value exceeds the number of places defined here, then the left-most digits will be discarded. ''  
+
|-
 +
 
 +
 
 +
|''The 'z' parameter is optional but if specified indicates the number of leading zero's to display, if not specified then ZERO is assumed.  If the number of digits in the resultant value exceeds the number of places defined here, then the left-most digits will be discarded. ''  
 
''The 'r' parameter allows you to specify the base to use when converting the numeric value to a string. The default value if not specified is ten (10), any value between 2 and 36 is valid. ''
 
''The 'r' parameter allows you to specify the base to use when converting the numeric value to a string. The default value if not specified is ten (10), any value between 2 and 36 is valid. ''
  
−
 
+
|}
  
 
|-
 
|-
Line 178: Line 217:
 
|-
 
|-
 
|nowrap="1"|''secure''
 
|nowrap="1"|''secure''
−
|This generates a UUID that cannot be traced to the ethernet address of the computer on which it was generated  
+
|This generates a UUID that cannot be traced to the Ethernet address of the computer on which it was generated  
  
 
|-
 
|-
Line 190: Line 229:
 
|-
 
|-
 
|nowrap="1"|'''sess( ''prop_name'' )'''
 
|nowrap="1"|'''sess( ''prop_name'' )'''
 +
|
 +
:{| class="prettytable"
 +
 +
|-
 +
|
 +
|
 +
 +
|-
 
|The current user’s session property.
 
|The current user’s session property.
 +
|}
  
 
|-
 
|-
 
|nowrap="1"|'''param(''param_name'')'''
 
|nowrap="1"|'''param(''param_name'')'''
 +
|
 +
:{| class="prettytable"
 +
 +
|-
 +
|
 +
|
 +
 +
|-
 
|A value passed into the function when invoking the sequence.
 
|A value passed into the function when invoking the sequence.
 +
|}
  
 
|-
 
|-
 
|nowrap="1"|'''rec( ''column_name'' )'''
 
|nowrap="1"|'''rec( ''column_name'' )'''
−
|will be translated into the value that will be written to the database record.
+
|
 +
:{| class="prettytable"
  
 +
|-
 +
|
 +
|
 +
 +
|-
 +
|Use a value that is stored in the database record.
 +
|}
 
|}
 
|}
 +
[[Category:Administration]][[Category:Videos]]
 +
-->
 +
[[Category:HDOC]]

Latest revision as of 18:07, 10 April 2024

This document can now be found at its new location in the Hornbill Document Library.

Hornbill Cloud

Retrieved from "https://wiki.hornbill.com/index.php?title=Auto_Values&oldid=32096"