Changes

[#(?object=activity;)|~statusstatusname~|~typename~|$speciality$|$123456$~|#]::''See [[MS Word Merge]] for further details on including tables on MS Word Merge documents.''

*To generate a list of all contacts for a [[Web Page View]], or [[Custom Field Type: Read Only – System Variables|Read Only – System Variables]] custom field (note that the HTML table formatting is included within the '''[#...#]''' syntax)

 * To sort descending by a custom field called "''Total Hours" '' with a custom field id of ''67292'':

'''* To list a specific activity type only''':

[#(?object=activity;orderby=startdate;criteria=typename='This Activity Type')<tr><td>~subject~</td><td>~location~</td><td>~startdate~</td></tr>#] e.g. where typename='activity name'</pre>

e.g. where typeid='141414'</pre> '''* To list activity activities based on a specific status name or status id''':

<table>[#(?object=activity;orderby=startdate;criteria=statusname='Open')<tr><td>~subject~</td><td>~location~</td><td>~startdate~</td></tr>#]</table> e.g. where statusname='status name' <table>[#(?object=activity;orderby=startdate;criteria=status.id='')<tr><td>~subject~</td><td>~location~</td><td>~startdate~</td></tr>#]</tablepre>

==To format Format the start date and start timeStart Date or Start Time==<font size="3">~date_format(startdate,'%Y-%m-%d') as startdate~</font>

:or<prefont size="3">~date_format(startdate,'%Y-h:%m-i %dp') as startdatestarttime~</prefont>

*'''Note: ''':* If you wish to use ''"orderby=startdate"'', along with a date format other than yyyy-mm-dd you must use a slightly different syntax.:*Using ''"~date_format(startdate,'%d-%m-%Y') as startdate~"'' when using ''"orderby=startdate"'' will cause the date to be ordered by dd-mm-yyyy (rather than yyyy-mm-dd, which is chronological) :*To avoid this, change ''"date_format(startdate,'%d-%m-%Y') as '''startdate'''"'' to ''"date_format(startdate,'%d-%m-%Y') as '''sdate'''"''

==How to display level three activities Displaying Level 3 Activities at level one Level 1 in the a Web Page View== When displaying a list of '''Level 2''' activities using the '''[#(?object=activity;)...#]''' syntax, the corresponding '''Level 3''' activities can now be displayed under each of the parent '''Level 2''' activities using:<font size="3">[@(?object=activity;)~standardfieldname~ $customfieldname$@]</font>

When displaying a list of '''Level 2Note:''' activities using the [ # (?object=object;orderby=field) # ] processor, the corresponding '''Level 3* This syntax will only work if there are ''' activities can now be displayed under each of the parent less than 25 fields'''at Level 2''' activities by using [ @ (?object=object;orderby=field) @ ]3.

This new feature allows level one web page fields to '''Example:'''* To display level a list of Level 2 activities, including any Level 3 items. This a type syntax for displaying level activities under their parent Level 2 items. activity:

<table border=1>

<tr><td colspan=>Level 2>Activity: ~subject~</td><td>~locationstatusname~</td><td>~startdate~</td><td>~enddate~</td></tr> <tr><td></td><td colspan=3> <table> [@(?object=activity;orderby=typename)<tr><td> Level 3 Activity: ~typename~</td><td>~location~</td></tr>@] </table> </td></tr>

The '''[[Custom Field Type: Read Only – System Variables|Read Only'''-System Variable ]] field can also now be used in the '''a [[Web Page View''' ]] field.  This is useful for to facilitate displaying '''Level 3''' activities at the '''Level 1''' in a '''Web Page View''' field. Currently we can display '''Level 3''' activities at '''Level 1''' using the following syntax: <pre><table border=1>[#(?object=activity;orderby=startdate) <tr><td colspan=2>~subject~</td><td>~location~</td><td>~startdate~</td></tr><tr><td> <table bgcolor="00FFFF"> [@(?object=activity;orderby=startdate)<tr><td>~subject~</td><td>~location~</td><td>~startdate~</td></tr>@]  </table></td></tr> #]</table> </pre> 

To display '''Level 3''' activities that have more than 25 fields, the following method is now available:

1. Create a '''[[Custom Field Type: Read Only – System Variables|Read Only - System Variable''' ]] field at '''Level 2'''. 2. Format that contains the field list of Level 3 activities, formatted and filtered as you would a '''Web Page View''' fielddesired. For example:

<table border=1> [#@(?object=activity;orderby=startdatetypename) <tr><td colspan=2>Level 3 Activity: ~subjecttypename~</td><td>~location~</td><td>~startdate~</td></tr>#@]

<table border=1>[#(?object=activity;orderby=startdate)<tr><td colspan=>Level 2>Activity: ~subject~</td><td>~locationstatusname~</td><td>~startdate~</td><td>~enddate~</td></tr> <tr><td></td><td colspan=23>$123456Level 3 Activity List$</td></tr>#]</table>