Ultimate Database

{ULT_LIST(n1,n2,n3,n4,n5,n6,n7)}}

Displays a list of items.

'n1' is the parent object id of the list.

If the parent object id is not the id of the list of items to be displayed then it should be followed by a ; and the id of the list.
e.g. If the parent object were to be the id of an invoice and the list were to show the lines related to the invoice then it should be followed by ; and the id of the invoice line list.

'n2' is the relationship type between the parent object and its children, which is usually 0. This can be a minus number if it is a parent relationship.

'n3' is the display option, which can be {sub-template id} or options or '?Option'. Options are

'1' if you want a header,
'2' if you want to display a title against an image as an ALT.
'4' puts navigation icons at top.
'8' puts them at the bottom.
'16' specifies that any URLs in the list are to be created as a link in the first column rather than a link to the object.
'64' means there are no options to edit any of the items.

You can add the numbers together if you want multiple options. So '3' gives '1' and '2'. 
If you place a '?' in front of the number then a sample List Template will be displayed. You can copy and paste this into an HTML temple object, modify it and use it to display the items exactly as required. To use it in the list place the Template Object ID in {} instead of the numbers listed above.
Click here for a full explanation of how the template works. (To follow!)

'n4' is the default order.

'1' is alphabetical,
'2' is most recent,
'3' is highest rated.
'>3' indicates the id of the relationship to the object that is to use for the order.

A minus sign in front of the order states that it is to be displayed  in decending order.

'n5' is the default number of items per page. 10,20,50,100 will result in the user being able to change the qty per page. Any other number will fix the qty.

You can display more than one item across the page by adding "/n" after the page quantity. So if you want 9 items on a page (3 across and 3 down) then enter 9/3.

'n6' is the id of the limiting relationship.

'n7' is the id of the limiting object via the relationship.