Changes

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>

• ← Older edit
• Newer edit →

0

edits