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

some help with filtering with table join #64

Closed mennoswaak closed 7 months ago

mennoswaak commented 8 months ago

greetings

I have a table that can be filtered with the next line (from the layout):

{{ artikelid.label(true) }}
{{ html.search("artikelid","","reload") }}

It works well but artikelid is a Table join. Is it possible to show as well as the value of artikleid as the other field (which is cursusnaam)?

Hope this is possible thanks in advance

menno

joomlaboat commented 8 months ago

Hello Menno,

You can combine the search like this {{ html.search("artikelid,cursusnaam") }}

When combined Table Join field search box will look like an input box, not a Select box.

mennoswaak commented 8 months ago

thanks but this is not going to work for me. I need a dropddown list. I found a workaround that is good enough for now.

allow me two more questions sometimes in layout

change into this after save

.datagrid th{text-align:left;} .datagrid td{text-align:left;} and .datagrid th{text-align:left;} .datagrid td{text-align:left;} will be displayd above the table in frontend and can .datagrid th en .datagrid td be expanded with valign:top ? thanks in advance menno
joomlaboat commented 8 months ago

.datagrid th{text-align:left;vertical-align:top;}

is this what you need?

I guess I didn't understand the question about {{ html.search("artikelid","","reload") }}

mennoswaak commented 8 months ago

.datagrid th{text-align:left;vertical-align:top;} has nothing to do with my first question about filtering. I was able to solve that.

But something else was what I saw when I'm changing layouts. in layout

change after save into this:

.datagrid th{text-align:left;} .datagrid td{text-align:left;} so

mennoswaak commented 8 months ago

thanks very much it is working now