214
edits
Changes
m
→How to display a list of UTA Level 1 Activities, Contacts or Companies
<pre><table>[#(?object=object;orderby=field)<tr><td>~field~</td><td>~field~</td><td>~field~</td><td>$customfield id$</td></tr>#]</table></pre>
'''Example''':
<pre>
<table>[#(?object=activity;orderby=startdate)<tr><td>~subject~</td><td>~location~</td><td>~startdate~</td></tr>#]</table>
<table>[#(?object=contact;orderby=lastname;criteria=role='Internal People')<tr><td>~firstname~</td><td>~lastname~</td><td>~email~</td></tr>#]</table>
</pre>
'''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>
<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>
'''To list activity based on a specific status name or status id''':
<pre>
<table>[#(?object=activity;orderby=startdate;criteria=statusname='')<tr><td>~subject~</td><td>~location~</td><td>~startdate~</td></tr>#]</table>
<table>[#(?object=activity;orderby=startdate;criteria=status.id='')<tr><td>~subject~</td><td>~location~</td><td>~startdate~</td></tr>#]</table>
e.g. where status.id='1234'</pre>
'''To format the start date and start time''':
<pre>~date_format(startdate,'%Y-%m-%d') as startdate~</pre>
'''or'''
<pre>
~date_format(startdate,'%h:%i %p') as starttime~
</pre>
