Filter Questions

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!

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.

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

If you want to edit data that are result of join , you cant.

Mybe with use of "WHERE IN (SELECT ...)"

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

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.

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