Filter Questions

ollyno1uk posted 6 years ago in General
Is there any documentation on how to use the filter?

I use it to sometimes filter all products with categories_id of, for example, 65 for manual editing of the cells but sometimes I need to also be able to only do this when another condition from another table is met.

Is this possible or not with filters?

Great software - been using it for years now!
ansgar posted 6 years ago
You can use both - a WHERE filter clause on the top of the data grid, and on the bottom use Ctrl+Alt+F to activate a client-filter editor.
ollyno1uk posted 6 years ago
Thanks for the quick response.

I do not understand though.

Could you give me a quick example of filtering data for editing from 2 x tables?

Thanks again
BubikolRamios posted 6 years ago
If you want to edit data that are result of join , you cant.

Mybe with use of "WHERE IN (SELECT ...)"
ollyno1uk posted 6 years ago
Thanks - is this as a filter? or does this mean I can only do it with an sql query?

I need to ideally visually be able to edit the cells
ansgar posted 6 years ago
You can use such a WHERE filter in both data grid and query tab, and you can edit both results. If there are joins or computed columns HeidiSQL will say you can't edit the result. Just try it out.
gnulinux posted 6 years ago

select * from tabname where id>3 and id<10;


Please login to leave a reply, or register at first.