Filter Questions
| User, date | Message |
|---|---|
|
Written by ollyno1uk
2 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
2 years ago 3966 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
2 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
2 years ago 273 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
2 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
2 years ago 3966 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
2 years ago 1 posts since Mon, 17 Oct 11 |
 select * from tabname where id>3 and id<10; 
|
|
Please login to leave a reply, or register at first. |