distal-attribute
distal-attribute
distal-attribute
distal-attribute

Filter Questions

User, date Message
Written by ollyno1uk
3 years ago
Category: General
10 posts since Fri, 30 Nov 07
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!
Written by ansgar
3 years ago
4793 posts since Fri, 07 Apr 06
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.
Written by ollyno1uk
3 years ago
10 posts since Fri, 30 Nov 07
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
Written by BubikolRamios
3 years ago
326 posts since Thu, 14 Jan 10
If you want to edit data that are result of join , you cant.

Mybe with use of "WHERE IN (SELECT ...)"
Written by ollyno1uk
3 years ago
10 posts since Fri, 30 Nov 07
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
Written by ansgar
3 years ago
4793 posts since Fri, 07 Apr 06
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.
Written by gnulinux
3 years ago
1 posts since Mon, 17 Oct 11
smile

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

surprised
 

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