clear filters

[unicar]

How to erase the filter cleaner without the filter option is removed?

 

[cheesegrits]

Not sure what you mean.

-- hugh

 

[unicar]

I'm sorry for my English
I have a list (customers) with some records and a list together (bills) with "databasejoin" to this list,
The first (customers) list has a prefilter users but when they enter the second list (bills) and cleaned the filters you can see all records to any user ....

That's why I wanted to handle the filter but remove the icon to clean

-- hugh

 

[cheesegrits]

You'll need to add a pre-filter on the second (bills) list as well.

If you don't have a user element on the bills list, you'll have to set up your prefilter to reference the customers list, like ...

WHERE
Field: id
Condition: IN
Value: SELECT bills.id FROM bills LEFT JOIN customers ON customers.id = bills.customer WHERE customer.userid = '{$my->id}'
Type: Query
Apply to: customers

-- hugh

 

[unicar]

Sorry for my question ,
all invoice records are hidden when I put the prefilter...

I left an image of what I 'm doing

 

[unicar]

It is also good to know that invoice records are entered by an administrator, not users

 

[cheesegrits]

The pre-filter you created isn't what I suggested.

Re-read my previous post, and try that.

-- hugh

 

[unicar]

and now this error
(500 - Column 'id' in field list is ambiguous SQL=SELECT DISTINCT `pedidos`.`id` AS __pk_val0 FROM `pedidos` LEFT JOIN `clientes` AS `clientes` ON `clientes`.`id` = `pedidos`.`nombre_cliente` WHERE ( pedidos.id IN (SELECT id FROM pedidos LEFT JOIN clientes ON clientes.id = pedidos.clientes WHERE clientes.userid = '561') ) AND ( `pedidos`.`nombre_cliente` = '7' ) ORDER BY `pedidos`.`actualizado` DESC)

 

[cheesegrits]

My bad.

I've corrected that in my post - should be bills.id.

-- hugh