Print

Hash Variables


Variables availability within Forms created by nuBuilder


FORMSession Hash Variables$_POST Variables ***Form Hash Variables#newID##recordID# or #id##clone##browseTable#$updateField$errorMessage#formID#
SQL
Yes
-
-
-
Yes
-
Yes
-
-
-
All Display Conditions
Yes
-
Yes
-
Yes
Yes
-
-
-
-
Before Browse
Yes
-
Yes
-
Yes
-
Yes
-
-
Yes
After Browse
Yes
-
Yes
-
-
-
Yes
Yes
-
-
Before Open
Yes
-
Yes
-
Yes
Yes
-
-
-
Yes
Before Save
Yes
Yes
Yes
Yes
Yes
Yes
-
-
Yes
-
After Delete
Yes
Yes
Yes
-
Yes
Yes
-
-
-
-
After Save
Yes
Yes
Yes
Yes
Yes
Yes
-
-
-
-


Variables availability in Objects created using nuBuilder


OBJECTSSession Hash Variables$_POST VariablesForm Hash Variables#recordID##clone##browseTable##formID##dir##browse_filter#
All Display Conditions
Yes
-
Yes
Yes
Yes
Yes
Yes
Yes
No
SQL Run Before Display
Yes
-
-
Yes
Yes
Yes
Yes
Yes
No
SQL to Display
Yes
-
Yes
Yes
Yes
Yes
Yes
Yes
No
All Default Value SQLs
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
All SQLs
Yes
-
-
Yes
Yes
Yes
Yes
Yes
No
Html Code
Yes
-
Yes
Yes
Yes
Yes
Yes
Yes
No


List of Session Hash Variables


Variable Name
Description
#access_level#Access Level of user
#zzsys_user_id#ID of the current user
#session_id#ID of the current session (expires upon logout)
#zzsys_user_group_name#sug_group_name from the zzsys_user_group table


List of Form Hash Variables


Variable Name
Description
#id#Primary Key of table used by current form
#rowPrefix#Prefix of the subform row


List of Activity Hash Variables

Variable Name
Description
#dataTable#Table used to generate report, procedure or export
#graphTable#Table used to generate graph


List of Report Editor Hash Variables (for Labels)

Variable Name
Description
#thePageNumber#Page number for the current page (generally used in page header and footer)
#totalNumberOfPages#Total number of pages in the report


Page #thePageNumber# of #totalNumberOfPages#

Note: The value of fields from the activity's (selection) screen can be passed to the activity's data code as Field Hash Variables

*** The way nuBuilder uses hash variables is by replacing all valid hash variables with their values before the cusom code or SQL statement is run.
This means that these values end up being hard coded and won't change throughout the code.
Which means that in the case of refering to fields in subform rows the only way to loop through changing row numbers is with $_POST variables.



--JEFF EDIT--

Hash Variable / Global Variables by Location
found in each section by using:
echo "
";
print_r($arrayOfHashVariables);
print_r($globalValue);
echo "
";
die;

Edit Form Fields:

SQL
Before Browse
$globalValue
session_id => 14a665b8e0f545
access_level => globeadmin
zzsys_user_id => globeadmin
zzsys_user_group_name => globeadmin
small => 0

# Variable
NONE FOUND

After Browse
Before Open
After Delete
After Save
Javascript

Difference between #recordID# and #newID#


Using the following code in Before Save or After Save

nuDebug("recordID : #recordID# ");
nuDebug("newID : #newID# ");


will return...

recordID : -1 (a new record always starts as -1)
newID : 14c11773f32f20
when saving a new record

recordID : 14a441db4b1284
newID : 14c1176c1b9572
when saving a cloned record

recordID : 14a441db4b1284
newID : 14a441db4b1284
when saving an existing record (the same value)





Created by: system. Last Modification: Friday 28 of September, 2012 10:01:05 CST by steven.