search

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
36 stars 11 forks source link

Filtering on a value of he type integer? #30

Closed mennoswaak closed 2 years ago

mennoswaak commented 2 years ago

Hello

is there a possibility to filter list on some value in one of the fields. If I add now a a list to a menu item I can filter on values related to user and user field (I do not understand now how its works because of I did not study it). But what i need is a filter that can come from a field (can be an integer) in order to only present records with a specific value. I hope this is possible somehow

thanks in advance Menno

joomlaboat commented 2 years ago

Hello Menno,

I just wrote a small article to explain how Filters work:

https://github.com/joomlaboat/custom-tables/wiki/07.-Filters

Also you can insert records from any tables to any layout using {{ tables.getrecords() }}

{{ tables.getrecords() }}

Renders another table records using selected layout.

Parameters

Catalog Layout

Filter - Example: price>100

Order By Field - Example: name desc

Limit - Max number of records to load. Example: 20

Example

{{ tables.getrecords("CountriesPage","population>" ~ citypopulation.value,"name",20) }}

where "citypopulation" is the current table field and "CountriesPage" is the layout of another table to get the records from.

Hope it will be helpful.

joomlaboat commented 2 years ago

You can use the Menu Item/Filter/Search Parameter

Example:

price>0 and active=1

price<{{ payment.value }}