Changes

Jump to: navigation, search

Web Page View Field Variables

687 bytes removed, 16:14, 27 August 2009
To Format the Start Date or Start Time
:* 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'''"''
 
 
 
'''To list notes (from the record that contains the notes):'''
<pre>
[@(?object=notes;orderby=createddate desc)<tr><td>~notes~</td><td>~createddate~</td><td>~username~</td></tr>@]
</pre>
::''Note: This syntax is for "Public (Default)" notes only, not custom note types.
 
 
'''To list level 2 notes for each level 2 record at level 1:
<pre>
[#(?object=activity;orderby=startdate desc)
<tr><td>~subject~</td><td>~description~</td><td>~startdate~</td>
<td><table>
[@(?object=notes;orderby=createddate desc)<tr><td>~notes~</td><td>~createddate~</td><td>~username~</td></tr>@]
</table></td>
</tr>#]
</pre>
::''Note: This syntax is for "Public (Default)" notes only, not custom note types.
 
==Displaying Both Level 2 and Level 3 Activities at Level 1==
0
edits

Navigation menu