joomlaboat / custom-tables

The Custom Tables extension allows you to create, manage, and display custom data on your Joomla site. It is helpful if you need to display data that is not part of the standard Joomla content structure. For example, you could use this extension to create a custom table for product information, customer data, or any other type of data that you need to display on your site. The Custom Tables is the CRUD solution for Joomla 3.x and 4.x - CREATE, READ, UPDATE and DELETE. You can add tables, fields, and layouts to create catalogs, forms, or details pages. It has 40 Field Types: Integer (numbers), Decimal, Text String, Time, Email, Color, Image, File, User, Language, etc.
https://joomlaboat.com/custom-tables
GNU General Public License v2.0
35 stars 11 forks source link

field display sum(fields) #62

Closed rcr54 closed 7 months ago

rcr54 commented 9 months ago

I want to sum the value of a field over all rows, Like 'select sum(field) from custom.tables. Is this already possible?

joomlaboat commented 9 months ago

{{ record.sum("products","price","country==germany") }}

Summarizes values of a selected field of all the records that match the filter.

Parameters

Table - The name of the Table to count records from.

Value Field - The field to read the value from.

Filter - Optional filter, ie. fieldname=some value.