Feature I Need

[Danil Shingarev]

Hi. Latest thing i need to migrate from my current sql-clilent – fast search in results grid.

I know about SQL and i can filter them by query 😉 But i need to have a great tool for data manipulation. SQLyog haven't any data filtering system as i see.

Can brave developers team do anithing with it?

P.S. Toad for mySQL have it – simple and fast Excel-like filters.

Also fast search by ctrl+F or others in results grid (Firefox-like will be perfect ithink)

Thank you for your attention.

[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