Changes

Jump to: navigation, search

Web Page View Field Variables

334 bytes removed, 13:50, 27 August 2009
→‎To Display a List of Activities, Notes, Transactions, Contacts or Companies
:* <font size="3">orderby=tbl_''customfieldid''.valuestr</font> - sorts the list in ascending order by the custom field specified
:* <font size="3">criteria=''standardfieldname''=''value''</font> - filters the list to only those items that meet the criteria specified
:* <font size="3">criteria=(''standardfieldname''=''value'' or ''standardfieldname''=''value'')</font> - for multiple criteria
 
:* multiple options can be included, separated by semi-colons (;)
* For a list of contacts assigned to a Level 1 with the role of "Internal People", sorted by surname:
<pre>
<table>[#(?object=contact;orderby=lastname;criteria=rolename='Internal People')<tr><td>~firstname~</td><td>~lastname~</td><td>~email~</td></tr>#]</table>
</pre>
<table>[#(?object=contact;orderby=lastname;criteria=rolename='Internal People')<tr><td>~firstname~</td><td>~lastname~</td><td>~email~</td><td>~role~</td></tr>#]</table>
 
</pre>
*Note: Search results normally display in ascending order. You may use '''desc''' option to display results in descending order.
* With Multiple Criteria:
*To avoid this, change ''"date_format(startdate,'%d-%m-%Y') as '''startdate'''"'' to ''"date_format(startdate,'%d-%m-%Y') as '''sdate'''"''
 
'''To list level two entity at level one using level two fieldname instead of customfield ID'''
<pre>
[#(?object=activity;criteria=typeid='19997';)
<tr><td>~index~</td><td>Folder</td><td>$Field Name$</td><td>$customfieldID$</td><td>$customfieldID$</td></tr>
#]
</pre>
0
edits
Retrieved from ‘https://wiki.smartsimple.com/wiki/Special:MobileDiff/8672’

Navigation menu