Changes

Web Page View Field Variables

113 bytes added, 19:24, 9 July 2009

→‎How to display a list of UTA Level 1 Activities, Contacts or Companies

Results will be sorted on Startdate in Descending order.

</pre>

'''With Multiple Criteria''':

<pre>

[#(?object=contact;criteria=(rolename='External' or rolename='Internal'))<tr><td>~firstname~ ~lastname~</td></tr>#]

</pre>

'''To sort on custom field''':

<pre>

<table> [#(?object=activity;orderby=tbl_custom field id.valuestr)<tr><td>~location~</td><td>~startdate~</td></tr>#]</table>

e.g. where custom field id=999999

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

<pre>

<table>[#(?object=activity;orderby=startdate;criteria=typename='')<tr><td>~subject~</td><td>~location~</td><td>~startdate~</td></tr>#]</table>

e.g. where typename='activity name'

<table>[#(?object=activity;orderby=startdate;criteria=typeid='')<tr><td>~subject~</td><td>~location~</td><td>~startdate~</td></tr>#]</table>

e.g. where typeid='141414'</pre>

• ← Older edit
• Newer edit →

0

edits