Changes

Custom Field Type: Special - Advanced Data Table

211 bytes added, 13:32, 3 June 2016

→‎Variables

==Variables==

===Access to the data within an entire XML section===

Uses standard SmartSimple variable references.

To display the section when there are no variables references within the section itself::<font size=3>@xml.fieldname.sectionname.html@</font> To display the section when there are variables referenced within the section itself::<font size=3>@xmlpre.fieldname.sectionname.html@</font>   ===Access to the data within the XML field uses ===  Uses standard SmartSimple variable references.

:<font size=3>'''@xml.'''''field name.parentnodename.nodename'''''.nodevalue@</font>

===Formatting node values:===

:<font size=3>'''@xml.'''''field name.parentnodename'''''.[# ~comma('''''nodename'''''.nodevalue)~ #]@</font>

:* This will return a numeric nodevalue in currency format. (See also [[Displaying_a_Number_Value_as_Currency#XML_data|Displaying a Number Value as Currency]].)

===Date formatting node values===

To display the section::<font size=3>@xml.fieldname.sectionname.html@</font>:<font size=3>@xmlpre.fieldname.sectionname.html@</font> - This will process variables that are referenced in the section Date formatting node values: The available syntax for date formats are as follows: ~formatdate(Date.nodevalue)~ >> returns the date in the user's date format ~year(Date.nodevalue)~ >> returns the year from the date ~month(Date.nodevalue)~ >> returns the month from the date ~monthname(Date.nodevalue)~ >> returns the month name from the date ~day(Date.nodevalue)~ >> returns the day from the date ~dayweek(Date.nodevalue)~ >> returns the day of week from the date

''Examples'':

DAYWEEK: Tuesday

===Counting nodes:===

:<font size=3>'''@xml.'''''field name.parentnodename.nodename'''''.nodecount@</font>

===For child records:===

:<font size=3>'''@xml.'''''fieldname.nodename'''''[# ~nodevalue~ ~attributes('''''attribute name''''')~ #]@'''''</font>

:<font size=3>'''@xml.'''''fieldname.nodename'''''[# ~'''''childnodename'''''.nodevalue~ ~'''''childnodename'''''.attributes('''''attribute name''''')~ #]@'''''</font>

===To return the actual XML code from the field:===

:<font size=3>'''@'''''fieldname'''''.xmlvalue@'''</font>

• ← Older edit
• Newer edit →

Ciaran Donnelly

Smartstaff, administrator

4,478

edits