0
edits
Changes
→To Display a List of Activities, Notes, Transactions, Contacts or Companies
=To Display a List of Activities, Notes, Transactions, Contacts or Companies=
==To display the entire listDisplay an Entire List==:<font size="3">[#(?object=''objectname'';{options})~''fieldname1standardfieldname''~ ~$''fieldname2customfieldname''~$#]'''</font>
'''where:'''
:* objectname is one of: activity, contact, user, company, notes, association, transaction or level-1:* fieldname1 and fieldname2 are standardfieldname is the names name of a standard or field (between tildes ~):* customfieldname is the name of a custom fields on the objectfield (between dollar signs $)
'''Notes:'''
:* You can refer to [[Custom Fields]] on the objects using ''customfieldid'' instead of ''fieldnamecustomfieldname'' and replacing the tilde , still between dollar signs (~$) with :* ''level-1'' can only be used as an object when referenced from a dollar sign contact record '''Options:''':* <font size="3">orderby=''standardfieldname''</font> - sorts the list in ascending order by the standard field specified:* <font size="3">orderby=''standardfieldname'' desc</font> - sorts the list in descending order by the standard field specified:* <font size="3">criteria=''standardfieldname''=''value''</font> - filters the list to only those items that meet the criteria specified:* multiple options can be included, separated by semi-colons ($;)
'''Examples:'''
* To generate a list of Level 2 activities for a [[MS Word Merge]]:
[#(?object=activity;)~status~ ~typename~ ~$speciality~ $ $123456$~#]
*To generate a list of all contacts for a [[Web Page View]] (note that the HTML table formatting is included within the '''[#...#]''' syntax)
<pre>
<table><tr><td>First Name</td><td>Last Name</td><td>E-mail Address</td><td>Cell Phone Number</td></tr>[#(?object=contact;)<tr><td>~firstname~</td><td>~lastname~</td><td>~email~</td><td>$Cell Phone$</td></tr>#]</table>
</pre>
==To sort the listSorting a List==
To sort Ascending:
:<font size="3">[#(?object=''objectname'';orderby=''fieldname'')~''fieldname1''~ ~''fieldname2''~#]'''</font>