Feature I Need

[peterlaursen]

You are right .. we have no GUI filtering functionality in SQLyog as of now.

There are plan for such things. My best guess would be that it will be available by 2nd quarter 2007.

What you can do now is to use the favorites feature to store queries.

[Danil Shingarev]

ok. thank you

[Pavel Chysky]

Hi all,

I am a new user of SQLyog, it is great tool.

But I want interpellate for GUI quick filtering functionality, it is a very essential feature.

Writing something like SELECt .. WHERE .. is quite hairy.

But WHERE clause must be simply editable, options Field=value, Field>value,.. only are too few.

Very important is especially Field LIKE %value% etc.

e.g. I have table, thousands records. I want find record where Name=Mary, but I see records with other names only, because limit=e.g.50.

Right click at field “Name” with value John, option “QuickFilter” -> “Field like %value%”.

Into field “Condition” somewhere in form appears text “Name LIKE '%John%'”. I must edit this text – change to “Name LIKE '%Mary%'” (or “Name LIKE '%Mary%' AND Age > 16” is better 😛 ), and then click “apply filter”.

Many thanx

Pavel

[Author]

Posts