ct4.us

Returns value of joined table field.

Basic usage:

{{ record.advancedjoin }}

Usage with parameters:

{{ record.advancedjoin(Function, Join With Table, Find What Field, Where to Look Field, Value Field, Filter) }}

Parameters:

1. Function (optional) – What to do with returned value(s)
   • count – (Count. Counts the number of records that match..)
   • avg – (Average. Calculates the average value of all the records that match..)
   • min – (Minimum. Finds minimum value of all the records that match..)
   • max – (Maximum. Finds maximum value of all the records that match..)
   • sum – (Sum. Summarizes values of a selected field of all the records that match..)
   • value – (Value. Returns the value of selected field of all the records that match..)
2. Join With Table (optional) – Table Name to join with (Where to look)
3. Find What Field (optional) – The field of the current table. use ‘_id’ to the find current table record id.
4. Where to Look Field (optional) – Field of a joined table
5. Value Field (optional) – Value of joined table field.
6. Filter (optional) – Optional filter, ie. fieldname=some value.

Example:

{{ record.advancedjoin("count","sales","_id","productid","_id") }}